Thread

1. Re: [GENERAL] listing all tables

   Matt Vanderpol <fandarel@mail.solisys.com> — 1998-07-16T18:50:39Z

   >   How would I list all tables in a database?
   
   You can list all tables with:
   
   select * from pg_class;
   
   but that will give you system tables also.
   
   I think that if you use the \z command in psql, it will give you a list 
   of all tables in the current database.
   
   Matt
   
   
   

2. Re: [GENERAL] listing all tables

   Rostislav Matl <xmatl@informatics.muni.cz> — 1998-07-17T19:28:23Z

   On 16-Jul-98 Fandarel wrote:
   >>   How would I list all tables in a database?
   > 
   > You can list all tables with:
   > 
   > select * from pg_class;
   > 
   > but that will give you system tables also.
   > 
   > I think that if you use the \z command in psql, it will give you a list 
   > of all tables in the current database.
   > 
   > Matt
   > 
   
   It's in docs even maybe in FAQs, or in archive - it was already discussed.
   
   +-----------------------------------------------------------------------------+
   |  ROSTISLAV MATL, student of Masaryk University - Faculty of Informatics     |
   |  e-mail: xmatl@fi.muni.cz      WWW: http://www.fi.muni.cz/~xmatl/index.html | 
   +-----------------------------------------------------------------------------+