Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199408051019.DAA18983@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
To: stewart@oec.com
CC: postgres@postgres.Berkeley.EDU
In-reply-to: <Pine.3.89.9408041735.A4358-0100000@outland.oec.com> (message from Stewart Allen on Thu, 4 Aug 1994 17:57:57 -0400 (EDT))
Subject: Re: gleaning the database structure
Date: Fri, 5 Aug 1994 12:18:06 +0200
From: Thilo Gaul <gaul@ira.uka.de>
Message-ID: <"i31s7.ira..724:05.07.94.10.18.12"@ira.uka.de>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 05 Aug 94 03:19:10 -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
pg_class, pg_type, pg_attribute? 
You might need to use Version 4.2, users manual page 27 explains all you
wanted, I think.

> 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 
table.oid? Defining a attribute with a system-class name won't work!
If this should only express the usage of an "oid":
table.attr = "123"::oid  will do it...

>	- where do I get better information about oid's, casts, etc?
the only reason is, that a number is passed as "int4" and there's no
implicit typecast for "oid"s.

Thilo.

(gaul@ira.uka.de)

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