Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA26410; Wed, 5 May 93 18:35:54 -0700 Date: Wed, 5 May 93 18:35:54 -0700 From: "David J. Hughes" Subject: Re: Displaying the Database structure (schema) To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: andrew@gmvt4.Concordia.CA, andrew@gmvt4.Concordia.CA Cc: postgres@postgres.Berkeley.EDU In-Reply-To: <9305052058.AA24054@postgres.Berkeley.EDU> Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 5 May 1993 andrew@gmvt4.Concordia.CA wrote: > I am new to Postgres and I have a very simple question: How do I display > the structure of a particular database? I cannot seem to find the command > in the reference manual. Any help would be appreciated. I wrote a small program a while back that (very simply) allows you to list the relations in a database and then select a relation and display it's fields and associated types (limited type recognition though). I'm not taking it any further because it was a trial for some Motif based code I'm using in the network management system I'm developing. Those points understood, if anyone still wants it I'll put it up for FTP. bambi ___ David J. Hughes bambi@bu.oz.au / \ / / / / __/ __ __ ____/ / / __ Senior Network Programmer / \ / \ / \ / / / / / \ / Comms Development & Operation \____/ \__// / \__/ \___/ / / / Qld. 4229 AUSTRALIA (+61 75 951450)