Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA16792; Fri, 10 Apr 92 13:30:44 -0700
Message-Id: <9204102030.AA16792@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: listing classes
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 07 Apr 92 13:37:29 PDT."
             <9204072039.AA04243@postgres.Berkeley.EDU> 
Date: Fri, 10 Apr 92 13:30:28 PDT

you write:

> I'm a new user to postgres.  I've read through most of the user manual
> in search of the command to list the classes that I've created.  I
> can't find it.  Is there a way to list these out as it is in ingres
> with the help command?

There's no explicit command to do this, you have to query the system
catalogs.  In this particular case you can use a pattern match:

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

All the system catalog names begin with pg_ so we retrieve all the
names where the first three characters are not pg_ .


Jeff Meredith
mer@postgres.berkeley.edu