Re: [GENERAL] System tables - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] System tables
Date
Msg-id 200001171619.LAA29434@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] System tables  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List pgsql-general
> System tables are all tables starting with pg_. They store everything
> about your database installation, such as name of the actual databases,
> tables, attribute types, rules, indexes, what-have-you. Access statistics
> as in "How many times did table x get accessed since then" are not stored
> anywhere, at least not where you could make use of it.

psql \dS shows you the system tables.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  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

pgsql-general by date:

Previous
From: Robert Davis
Date:
Subject: Re: [GENERAL] How do you live without OUTER joins?
Next
From: james
Date:
Subject: (no subject)