[david@mars citewfs-1.1]$ psql -U cite cite
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

cite=# \d
               List of relations
 Schema |        Name        |   Type   | Owner
--------+--------------------+----------+-------
 public | Deletes            | table    | cite
 public | Deletes_pkey_seq   | sequence | cite
 public | Fifteen            | table    | cite
 public | Fifteen_pkey_seq   | sequence | cite
 public | Inserts            | table    | cite
 public | Inserts_pkey_seq   | sequence | cite
 public | Lines              | table    | cite
 public | Lines_pkey_seq     | sequence | cite
 public | Locks              | table    | cite
 public | Locks_pkey_seq     | sequence | cite
 public | MLines             | table    | cite
 public | MLines_pkey_seq    | sequence | cite
 public | MPoints            | table    | cite
 public | MPoints_pkey_seq   | sequence | cite
 public | MPolygons          | table    | cite
 public | MPolygons_pkey_seq | sequence | cite
 public | Nulls              | table    | cite
 public | Nulls_pkey_seq     | sequence | cite
 public | Other              | table    | cite
 public | Other_pkey_seq     | sequence | cite
 public | Points             | table    | cite
 public | Points_pkey_seq    | sequence | cite
 public | Polygons           | table    | cite
 public | Polygons_pkey_seq  | sequence | cite
 public | Seven              | table    | cite
 public | Seven_pkey_seq     | sequence | cite
 public | Updates            | table    | cite
 public | Updates_pkey_seq   | sequence | cite
 public | geometry_columns   | table    | cite
 public | spatial_ref_sys    | table    | cite
(30 rows)

cite=#