Postgres Pro
Downloads
Home   >   mailing lists

Re: A Table's Primary Key Listing - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: A Table's Primary Key Listing
Date
Msg-id 20050818150546.GA97974@winnie.fuhr.org
Whole thread Raw
In response to A Table's Primary Key Listing  (Roger Tannous <roger77_lb@yahoo.com>)
List pgsql-sql
Tree view 
On Thu, Aug 18, 2005 at 07:36:22AM -0700, Roger Tannous wrote:
> Is there any means to get a list of the Primary Keys (or simply the
> Primary Key if there's only one :) ) for a given table using an SQL query?

Are you looking for the primary key definition or do you want the
primary key values themselves?  It's not clear what problem you're
trying to solve if "SELECT columnname FROM tablename" isn't the answer.

-- 
Michael Fuhr

pgsql-sql by date:

Previous
From: Roger Tannous
Date:
Subject: A Table's Primary Key Listing
Next
From: daq
Date:
Subject: Re: A Table's Primary Key Listing