Thursday, June 26, 2008

Show Tables equivalent in Postgresql

The equivalent of mysql 'show tables' command in postgresql:


To see more information about the table, do \dt with the table name:

\dt table_name

If you want to see more than just tables (eg. sequences), use:


To see all databases, like 'show databases' in mysql:

select datname from pg_database;


Post a Comment