Обсуждение: RV: Tables Question

Поиск
Список
Период
Сортировка

RV: Tables Question

От
"Rafa Couto"
Дата:
> 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_%';