List of all system tables.

Started by Boulat Khakimovabout 25 years ago3 messagesgeneral
Jump to latest
#1Boulat Khakimov
boulat@inet-interactif.com

Hi,

How do I get the list of all system tables starting with "pg_"

Regards,
Boulat Khakimov

--
Nothing Like the Sun

#2Bruce Momjian
bruce@momjian.us
In reply to: Boulat Khakimov (#1)
Re: List of all system tables.

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
#3Richard Huxton
dev@archonet.com
In reply to: Boulat Khakimov (#1)
Re: List of all system tables.

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