Return-Path: aoki
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA07705; Sun, 1 Aug 93 17:31:07 -0700
Message-Id: <9308020031.AA07705@postgres.Berkeley.EDU>
From: aoki@postgres.berkeley.edu (Paul M. Aoki)
Subject: Re: PG System tables
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Sun, 1 Aug 93 21:13:08 BST 
	     <9308012029.AA07064@postgres.Berkeley.EDU> 
Date: Sun, 01 Aug 93 17:38:02 -0700
Sender: aoki@postgres.Berkeley.EDU
X-Mts: smtp

David Allan Finch <sarum@vger.demon.co.uk> writes:
> 	In PG they seam to be not documention anywhere
> 	could some spiffing chap tell *one* where to
> 	look for the System Tables. I know there is a
> 	'pg_users' table because the Users Guide mensions
> 	it. What are the others please?

retrieve (pg_class.relname) where 
	pg_class.relname ~ "pg_" and pg_class.relkind = 'r'\g
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki