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_%';