Answers for "how to check table in postgresql from terminal"

how to check table in postgresql from terminal

postgres=# \dt+Code language: PHP (php)

show table postgres command

PostgreSQL show tables command
	
\dt

show table details postgresql

\d table

how to check table in postgresql from terminal

SELECT *
FROM pg_catalog.pg_tables
WHERE schemaname != 'pg_catalog' AND 
    schemaname != 'information_schema';Code language: SQL (Structured Query Language) (sql)

how to check table in postgresql from terminal

postgres=# \dtCode language: PHP (php)