Thread

1. list of tables?

   Marc G. Fournier <scrappy@hub.org> — 1998-05-21T02:03:18Z

   Hello
   
   I d like to know if it is possible to have the list of tables like we can do with psql with \dt
   
   thanks
   
   Guillaume
   
   
   

2. Re: [SQL] list of tables?

   jose' soares <sferac@bo.nettuno.it> — 1998-05-21T09:26:52Z

   On Wed, 20 May 1998, The Hermit Hacker wrote:
   
   > 
   > Hello
   > 
   > I d like to know if it is possible to have the list of tables like we can do with psql with \dt
   > 
   > thanks
   > 
   -- list all and only tables/views...
   SELECT usename, relname
   FROM pg_class, pg_user
   WHERE ( relkind = 'r')
   AND relname !~ '^pg_'
   AND relname !~ '^xin[vx][0-9]+'
   AND usesysid = relowner
   ORDER BY relname;
                                              Jose'
   
   
   
   

3. Re: [SQL] list of tables?

   Oleg Broytmann <phd@comus.ru> — 1998-05-21T09:30:09Z

   Hello!
   
      I see this SELECT every other day in mailbox. Isn't it a FAQ?
   
   On Thu, 21 May 1998, Jose' Soares Da Silva wrote:
   > -- list all and only tables/views...
   > SELECT usename, relname
   > FROM pg_class, pg_user
   > WHERE ( relkind = 'r')
   > AND relname !~ '^pg_'
   > AND relname !~ '^xin[vx][0-9]+'
   > AND usesysid = relowner
   > ORDER BY relname;
   
   Oleg.
   ---- 
     Oleg Broytmann     http://members.tripod.com/~phd2/     phd2@earthling.net
              Programmers don't die, they just GOSUB without RETURN.
   
   
   

4. Re: [SQL] list of tables?

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-05-22T02:44:09Z

   > 
   > Hello!
   > 
   >    I see this SELECT every other day in mailbox. Isn't it a FAQ?
   
   Added to FAQ.  See the web site for the most recent version.
   
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)