From: Michael Fuhr <mike@fuhr.org>
To: Roger Tannous <roger77_lb@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: A Table's Primary Key Listing
Date: Thu, 18 Aug 2005 09:05:46 -0600
Message-ID: <20050818150546.GA97974@winnie.fuhr.org> (raw)
In-Reply-To: <20050818143622.32448.qmail@web51910.mail.yahoo.com>
References: <20050818143622.32448.qmail@web51910.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, roger77_lb@yahoo.com
Subject: Re: A Table's Primary Key Listing
In-Reply-To: <20050818150546.GA97974@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox