Re:

simply, you can

 select tablename from pg_tables;

but that gives you all of them, including the system tables

-duck


On Fri, 27 Oct 2000, Sujith C S wrote:

> Sir.
> How to list the table names in SQL server using a query...
> Like Select * from tab in Oracle...
> Plz help.
> 


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   
-----------------------------------------------------------------------------