RV: Tables Question

> How can I retrieve the "names" of all the tables in my database ?

In Postgres 7:

From psql: \dt
    or \d for all objects

From SQL:
    select * from pg_tables where tablename not like 'pg_%';