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