RV: Tables Question

Started by Rafa Coutoover 25 years ago1 messagesgeneral
Jump to latest
#1Rafa Couto
rcouto@pascualsilva.com

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