Thread: RV: Tables Question

RV: Tables Question

From
"Rafa Couto"
Date:
> 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_%';