psql: list tables
July 12, 2010 18:37:14 Last update: July 12, 2010 18:37:14
Use the
\d command to list tables, sequences, etc.:
postgres=# \d
List of relations
Schema | Name | Type | Owner
--------+--------------------+----------+-------
public | carrierinfo | table | boss
public | deviceinfo | table | boss
public | eventdatalog | table | boss
public | eventinfo | table | boss
public | eventlog | table | boss
public | settinginfo | table | boss
(6 rows)
