Thread

1. List of all system tables.

   Boulat Khakimov <boulat@inet-interactif.com> — 2001-03-06T00:44:07Z

   Hi,
   
   How do I get the list of all system tables starting with "pg_"
   
   
   Regards,
   Boulat Khakimov
   
   -- 
   Nothing Like the Sun
   
   

2. Re: List of all system tables.

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-03-06T01:04:30Z

   In psql, \dS.
   
   
   > Hi,
   > 
   > How do I get the list of all system tables starting with "pg_"
   > 
   > 
   > Regards,
   > Boulat Khakimov
   > 
   > -- 
   > Nothing Like the Sun
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 2: you can get off all lists at once with the unregister command
   >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
   > 
   
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
   
   

3. Re: List of all system tables.

   Richard Huxton <dev@archonet.com> — 2001-03-06T11:58:00Z

   On 3/6/01, 12:44:07 AM, Boulat Khakimov <boulat@inet-interactif.com> wrote 
   regarding [GENERAL] List of all system tables.:
   
   > Hi,
   
   > How do I get the list of all system tables starting with "pg_"
   
   > Regards,
   > Boulat Khakimov
   
   Try \dS from the psql prompt. If you want to see how it does it try 
   starting psql with a -E flag.
   
    - Richard Huxton