Postgres Pro
Downloads
Home   >   mailing lists

check for primary key - Mailing list pgsql-general

From Tom Brown
Subject check for primary key
Date
Msg-id 1257794396.18623.415.camel@brown.esteem.com
Whole thread Raw
Responses Re: check for primary key  (Thom Brown <thombrown@gmail.com>)
Re: check for primary key  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view 
Hey guys!

I would like to know how to query for the existence of a primary key on
a table. All of the tables have the column 'id' in them. That should be
the primary key. However, the primary key constraint got "lost" somehow.
Probably due to stupidity on my part.

I just want to add back the primary key constraint to the tables that
lost it. I want to query for the existance of it first, so I don't
produce an error when I do an 'ALTER TABLE ...' statement.

Any suggestions appreciated.

Thanks!
Tom

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: What to install to be able to build docs on Arch Linux?
Next
From: Tim Uckun
Date:
Subject: Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.