morannon:~/www_tip/misc>psql spares
Welcome to psql, the PostgreSQL interactive terminal.

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

spares=# \d
              List of relations
          Name           |   Type   | Owner  
-------------------------+----------+--------
 parts_main              | table    | sauron
 parts_main_parts_id_seq | sequence | sauron
 spares_dbs              | table    | sauron
 spares_dbs_dbs_id_seq   | sequence | sauron
 spares_parts            | table    | sauron
(5 rows)

spares=# INSERT INTO spares_dbs (dbs_name, dbs_desc) VALUES ('test1', 'Test table');
NOTICE:  CREATE TABLE will create implicit sequence 'test1_test1_id_seq' for SERIAL column 'test1.test1_id'
NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'test1_test1_id_key' for table 'test1'
INSERT 28051804 1

spares=# \d
              List of relations
          Name           |   Type   | Owner  
-------------------------+----------+--------
 parts_main              | table    | sauron
 parts_main_parts_id_seq | sequence | sauron
 spares_dbs              | table    | sauron
 spares_dbs_dbs_id_seq   | sequence | sauron
 spares_parts            | table    | sauron
 test1                   | table    | sauron
 test1_test1_id_seq      | sequence | sauron
(7 rows)

spares=# DELETE FROM spares_dbs WHERE dbs_name = 'test1';
DELETE 1
spares=# \d
              List of relations
          Name           |   Type   | Owner  
-------------------------+----------+--------
 parts_main              | table    | sauron
 parts_main_parts_id_seq | sequence | sauron
 spares_dbs              | table    | sauron
 spares_dbs_dbs_id_seq   | sequence | sauron
 spares_parts            | table    | sauron
(5 rows)

spares=# \q