Re: Using oids

On Wed, Sep 03, 2003 at 10:08:47PM +0200, Bo Lorentsen wrote:
> On Wed, 2003-09-03 at 18:24, Greg Stark wrote:
>
> I am maintaining a driver layer, so that exactly why I care about this
> kind of problem :-)
>
> > The pros: no extra overhead for OIDs, more portable to other databases.
> So when will this kind of meta data be provided, to let me detect if
> there is at "PRIMARY KEY" on a table. ?

That metadata has been around for a while, it's all stored in the system
tables. It's not returned with each query though. pg_attribute and pg_class
tell you almost everything you need to know.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato