[plug] Re: Finding out names of tables in postgresql
Denis Brown
dsbrown at cyllene.uwa.edu.au
Mon Jul 21 10:41:12 WST 2003
At 10:28 21/07/2003 +0800, David wrote:
>Hi all,
>never mind; I figured it out. It is pg_tables;
>hence, the command:
>select * from pg_tables;
>gives me the info I need.
Hello, David.
That is probably exactly what you need but one(?) alternative would be the
psql command /dt; which, correct me if I'm wrong, describes the tables in
your specific database. pg_tables should contain all tables, system as
well as user, IIRC.
Cheers,
Denis
More information about the plug
mailing list