Thread
-
Sujith C S <sujithcs@ddsl.net> — 2000-10-27T13:02:15Z
Sir. How to list the table names in SQL server using a query... Like Select * from tab in Oracle... Plz help.
-
Re:
D. Duccini <duccini@backpack.com> — 2000-10-27T18:09:58Z
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:
Albert REINER <areiner@tph.tuwien.ac.at> — 2000-10-28T14:36:14Z
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 --------------------------------------------------------------------------