Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199408042158.OAA06798@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Thu, 4 Aug 1994 17:57:57 -0400 (EDT)
From: Stewart Allen <stewart@oec.com>
Subject: gleaning the database structure
To: Postgres Group <postgres@postgres.Berkeley.EDU>
Message-Id: <Pine.3.89.9408041735.A4358-0100000@outland.oec.com>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 04 Aug 94 14:58:59 -0700
Resent-XMts: smtp


 Is there a simple set of queries which would provide basic table/column
 structure information within a database? I've poured over all the .ps
 documents that came with 4.0x and the pg_<whatever> structures listed
 there do not exactly match those used by the system.

 In Informix this information is simply defined in systables and 
 syscolumns.

 I've also encountered problems when searching on the oid. Actually,
 I've been completely unable to do it. Whether using the built in
 operators or just "table.oid = xxx" it fails with a error about
 explicit casts and defining operators for oid and int4 (aren't the
 built-in operators supposed to do this?).

 I guess one basic question arises from this:
	- where do I get better information about oid's, casts, etc?

 The FAQ is only minimally useful and I've read all of the available
 documentation several times (or maybe I haven't, but I've tried to
 be diligent in my research).

--
 Stewart Allen
 (stewart@oec.com)

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================