Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying database for table pk - better way? - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Querying database for table pk - better way?
Date
Msg-id a55915760709051438l79f9709l8a557f9f6b94be49@mail.gmail.com
Whole thread Raw
In response to Querying database for table pk - better way?  (Josh Trutwin <josh@trutwins.homeip.net>)
Responses Re: Querying database for table pk - better way?
List pgsql-general
Tree view 
On 9/5/07, Josh Trutwin <josh@trutwins.homeip.net> wrote:
> Curious if there is a better/cheaper way to get the data I'm looking
> for though?

SELECT conname
  FROM pg_constraint c JOIN pg_class l ON c.conrelid = l.relfilenode
       JOIN pg_namespace n ON n.OID = l.relnamespace
 WHERE contype = 'p'
   AND relname = '$table'
   AND nspname = '$schema'

pgsql-general by date:

Previous
From: Josh Trutwin
Date:
Subject: Querying database for table pk - better way?
Next
From: "Rodrigo De León"
Date:
Subject: Re: Querying database for table pk - better way?