PostgreSQL: Afficher les tables dans PostgreSQL

92

\c database_name 

\dt 

SELECT * FROM pg_catalog.pg_tables; 

87

sudo -u postgres psql 

79

psql DBNAME USERNAME 

sudo -u postgres psql 

psql -U postgres psql --username=postgres 

61

SELECT     table_schema || '.' || table_name FROM     information_schema.tables WHERE     table_type = 'BASE TABLE' AND     table_schema NOT IN ('pg_catalog', 'information_schema');