Thread: Cannot view tables when connecting to PostgreSQL from SQL Developer
I am new to PostgreSQL and I have an issue connecting to it from SQL Developer. I create a connection, enter the user ID and password, click "choose database" and it populates a drop-down list with all of the available databases. That all works great. However, when I select a database and connect to it, I don't see any tables. If I open the same database in pgAdmin III, there is a sub-node under the database name called "schemas". If you expand that, you can see all of the tables. In SqlDeveloper, however, there is no "schema" node, and clicking on tables displays nothing. Is there something I'm doing wrong? How can I view my postgreSQL tables from a SQL Developer connection? -- View this message in context: http://postgresql.nabble.com/Cannot-view-tables-when-connecting-to-PostgreSQL-from-SQL-Developer-tp5853254.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
Re: Cannot view tables when connecting to PostgreSQL from SQL Developer
From
"David G. Johnston"
Date:
Is there something I'm doing wrong? How can I view my postgreSQL tables
from a SQL Developer connection?
Please do a Google Search for "sql developer postgresql"
The very first post is a Stack Overflow question on this very same topic. I didn't read it. There seem to be other potentially informative results.
You are more likely to find a SQL Developer that happens to use PostgreSQL (as well) as opposed to a PostgreSQL person who happens to use SQL Developer. IOW, other forums are more likely to yield fruit.
David J.
Thanks, but I poked around and finally figured it out. When you connect to a database, it creates a node for that database with all of the objects listed. The TABLES node under this tree has nothing in it. You have to view the TABLES node under "public" under the root database folder. It has all of the tables in it. Thanks again. I hope this helps some other novices. -- View this message in context: http://postgresql.nabble.com/Cannot-view-tables-when-connecting-to-PostgreSQL-from-SQL-Developer-tp5853254p5853258.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.