agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Stewart Allen <stewart@oec.com>
To: Postgres Group <postgres@postgres.Berkeley.EDU>
Subject: gleaning the database structure
Date: Thu, 4 Aug 1994 17:57:57 -0400 (EDT)
Message-ID: <Pine.3.89.9408041735.A4358-0100000@outland.oec.com> (raw)


 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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: stewart@oec.com
  Subject: Re: gleaning the database structure
  In-Reply-To: <Pine.3.89.9408041735.A4358-0100000@outland.oec.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox