Re: [HACKERS] Empty system tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: darcy(at)druid(dot)net ("D'Arcy" "J(dot)M(dot)" Cain)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Empty system tables
Date: 1999-05-21 15:07:02
Message-ID: 5484.927299222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

darcy(at)druid(dot)net ("D'Arcy" "J.M." Cain) writes:
> perhaps we can update the docs to describe them.

> pg_listener

pg_listener records which backends are actively listening for NOTIFY
conditions, and is used to transmit NOTIFY signals from one backend to
another. It will be empty if you do not have any active LISTEN
commands.

> pg_shadow

Shadow user table, with the real passwords. (pg_user is actually
only a view of pg_shadow.)

> pg_statistic

Per-column stats collected by VACUUM ANALYZE and used by the query
optimizer.

Dunno about the rest.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-05-21 15:46:05 Re: [HACKERS] Broken select on regular expression !!!
Previous Message Tom Lane 1999-05-21 14:01:39 Re: [HACKERS] Numeric and Aggregate: transform node 107