Re: [GENERAL] Querying database for table pk - better way?

[Rodrigo De León]

On 9/5/07, Josh Trutwin <[EMAIL PROTECTED]> 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'

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster