Re: A Table's Primary Key Listing

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Roger Tannous <roger77_lb(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: A Table's Primary Key Listing
Date: 2005-08-18 15:05:46
Message-ID: 20050818150546.GA97974@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message daq 2005-08-18 15:29:58 Re: A Table's Primary Key Listing
Previous Message Robert Treat 2005-08-18 14:43:36 Re: [GENERAL] pgsql-bugs