Thread:

From
"Sujith C S"
Date:
Sir.
How to list the table names in SQL server using a query...
Like Select * from tab in Oracle...
Plz help.

Re:

From
"D. Duccini"
Date:
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!"
-----------------------------------------------------------------------------


Re:

From
"Albert REINER"
Date:
On Fri, Oct 27, 2000 at 06:32:15PM +0530, 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.

In psql you can see that information with \d. Start psql with some
option (I think it is -E, see the man page or psql --help) to get the
actual queries sent to the backend.

Albert.


--

--------------------------------------------------------------------------
Albert Reiner                                   <areiner@tph.tuwien.ac.at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------