Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA10790; Wed, 2 Dec 92 19:36:35 -0800
Message-Id: <9212030336.AA10790@postgres.Berkeley.EDU>
From: shlam@ie.cuhk.hk
Subject: Re: List the class and rule
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Thu, 03 Dec 92 11:39:05 -0800
From: shlam@ie.cuhk.hk
X-Mts: smtp


> I am quite certain that there are many of us who would
> like to know the answer.  If someone *should* mail you a way to make
> these lists, it would probably be well for you to post it to the group.

1) To review the defined classes, try the following query:
 
  retrieve (r.relname, a.attnum, a.attname, t.typname)
	from r in pg_class, a in pg_attribute, t in pg_type
	where a.attnum > 0 
	and (r.relname < "pg" or r.relname > "ph")
	and a.attrelid = r.oid and a.atttypid = t.oid\g

2) To review the defined rules, try the following query:


	retrieve(pg_prs2rule.prs2text)\g


Here I would like to express my gratitude to the people who give me
the above hints. Thanks.

Alan S. H. Lam
Department of Information Engineering, CUHK, Hong Kong
E-mail: shlam@ie.cuhk.hk 
Tel: (852) 609 7975 Fax: (852) 603 5032