Re: view table pkey values - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: view table pkey values
Date
Msg-id 4A92C332.5000205@iol.ie
Whole thread Raw
In response to view table pkey values  (Scott Frankel <leknarf@pacbell.net>)
List pgsql-general
On 24/08/2009 17:31, Scott Frankel wrote:
> Is it possible to select or otherwise view a table's primary key values?

[snip]

> CREATE TABLE foo (
>     foo_id    SERIAL        PRIMARY KEY,

select foo_id from foo;

?

....or am I missing something?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Scott Frankel
Date:
Subject: view table pkey values
Next
From: james bardin
Date:
Subject: warm standby and reciprocating failover