Can't see table on postgres AWS database but can access database

[Douglas_Thoms]

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.

[MultiTech]

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?

help.appsheet.com

Using Data from SQL Server

How you can build an AppSheet app with data from SQL Server.

---

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

[Steve]

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.

[Douglas_Thoms · Accepted solution]

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