Hello,
I am trying to building an app using a postgres sql database hosted on AWS.
I am trying to connect a test postgres sql database hosted in AWS to Appsheet.com.
I can get Appsheet.com to access the database. However, it does not see the table in the database.
However, the table is there. I created it using pgAdmin4
I am a novice in SQL and databases. Are there some permissions I am missing? Could it be other issues?
Please let me know if there are any questions.
Douglas_Thoms:
I am a novice in SQL and databases.
Not to disuade you, but perhaps using Google sheets as the data source would be easier; the integration with AppSheet is much simpler. This would allow you to at least progress things forward and make progress.
Unless your tables are going to have 50,000+ records, there’s not much to be gained (on the AppSheet side of things) from utilizing a SQL table. So unless there’s a specific requirement for this type of data source, I would stick to Gsheets.
That said: I assume you’ve done all of the following?
Did a quick google search for:
“I can connect to sql database but not see tables”
this came up:
https://blog.sqlauthority.com/2017/03/02/sql-server-unable-see-tables-objects-ssms/
and this
MultiTech_Visions:
Not to disuade you, but perhaps using Google sheets as the data source would be easier; the integration with AppSheet is much simpler. This would allow you to at least progress things forward and make progress.
Hi Mutlitech_Visions and Steve,
Thanks for the advice. I determined the issue. I wasn’t access the right data base in pgAdmin. As you can see in my earlier graphic, there are a couple of databases - postgres and test database.
I was writing tables to test database in pgAdmin4 but had access postgres with Appsheet.
Thanks for the insight,
Douglas
