[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