Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06953; Tue, 31 Mar 92 18:08:07 -0800
Message-Id: <9204010208.AA06953@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Classes belonging to a given Database
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 31 Mar 92 13:28:18 PST."
             <9203312128.AA02916@postgres.Berkeley.EDU> 
Date: Tue, 31 Mar 92 18:07:50 PST

you write:

> Is it possible to know the name of all classes belonging to a given database?

> My problem is that I can't distinguish the classes I create from the 
> "administration" ones .

To get all user defined class names try:

	retrieve (pg_class.relname)
	where pg_class.relname !~ "pg_.*"

query-able system catalogs will begin with "pg_"

Jeff Meredith
mer@postgres.berkeley.edu