On 1/9/06 12:37 PM, "Joao Miguel Ferreira" <jmf(at)estg(dot)ipvc(dot)pt> wrote:
> this is my first question... I'm really new to PG.
>
> How do I get a list of all tables in a database ?
Bom Dia! Bemvindo ao Pg.
In psql, type:
\dt
> Is there an SQL command for this ?
Look at the chapter from the manual here:
http://www.postgresql.org/docs/8.1/static/view-pg-tables.html
As a starter, you can do:
select * from pg_tables;
Sean