Postgres Pro
Downloads
Home   >   mailing lists

Thread: List of tables

List of tables

From
"Marcel Wolf"
Date:

Guys & Gals

What is the best way to get a list of tables in a database? Is there a syntax for getting from the database after I connect or do I have to query the System Catalog? Either way what would be the syntax? (Note : Using PHP )

 

Thanks Again

 

Marcel Wolf

Re: List of tables

From
George Weaver
Date:
Hi Marcel,
 
Assuming you want just the tables you've created (and not a listing of system tables), you can use the following:
 
SELECT relname FROM pg_class  WHERE relkind='r' AND relfilenode > (SELECT datlastsysoid FROM pg_database WHERE datname = 'template0') ORDER BY relname;
 
Regards,
George
----- Original Message -----
Sent: Wednesday, January 28, 2004 10:04 AM
Subject: [NOVICE] List of tables

Guys & Gals

What is the best way to get a list of tables in a database? Is there a syntax for getting from the database after I connect or do I have to query the System Catalog? Either way what would be the syntax? (Note : Using PHP )

 

Thanks Again

 

Marcel Wolf