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!"
-----------------------------------------------------------------------------