In pgAdmin 4 right click on the database and then "Generate ERD (Beta)"
What am I missing? I am able to auth into postgres with psql from Terminal with the connection string, but when I use pgadmin with the exact same info, I just see a big list of this and am unable to see the actual tables:
EDIT: I realize that it's showing me all of the DBs and the one I specifically want is in the list and I can connect to it. But wish I could filter out all the irrelevant ones...
From the psql command line interface,
First, choose your database
\c database_name
Then, this shows all tables in the current schema:
\dt
Programmatically (or from the psql interface too, of course):
SELECT * FROM pg_catalog.pg_tables;
The system tables live in the pg_catalog database.
You can use PostgreSQL's interactive terminal Psql to show tables in PostgreSQL.
1. Start Psql
Usually you can run the following command to enter into psql:
psql DBNAME USERNAME
For example, psql template1 postgres
One situation you might have is: suppose you login as root, and you don't remember the database name. You can just enter first into Psql by running:
sudo -u postgres psql
In some systems, sudo command is not available, you can instead run either command below:
psql -U postgres
psql --username=postgres
2. Show tables
Now in Psql you could run commands such as:
\?list all the commands\llist databases\conninfodisplay information about current connection\c [DBNAME]connect to new database, e.g.,\c template1\dtlist tables of the public schema\dt <schema-name>.*list tables of certain schema, e.g.,\dt public.*\dt *.*list tables of all schemas- Then you can run SQL statements, e.g.,
SELECT * FROM my_table;(Note: a statement must be terminated with semicolon;) \qquit psql
Or, to retrieve all rows, just press the blue data grid.
The tooltip "View data in the selected object" is almost making it too easy.
Try the button with the funnel next to it to retrieve only a selection (for big tables).
Right click on the table and choose "View data"
For a list of alternatives, check out the Postgres wiki:
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
So I'm new to Postgres and I want to have a look at how postgres stores schema data since I am building a database manager like pgAdmin as a hobby project. My understanding is that all the schema data like names of tables and columns, column types, etc is stored in the `information_schema` table, however I cannot find the `information_schema` table anywhere in pgAdmin.
Edit: sorry I meant tables named eg `information_schema.tables`, not a table named `information_schema`
Edit 2: Having read more about Postgres, I think "metadata" is a more accurate word for what I was looking for than "schema" which is the language used by SQLite which I was using previously.