You can give the primary key a name when you are creating the table just
like you can give indexes, foreign keys, unique etc
create table foo (
foo_pkey integer not null,
foo_data varchar(50) not null,
CONSTRAINT foo_pk PRIMARY KEY(poo_pkey)
)
;
The primary key for this table is called foo_pk
HTH
Darren Ferguson
On Fri, 15 Mar 2002, Christian von Kietzell wrote:
> Hi,
>
> I'm sorry if this is a stupid question, but how can I obtain the name
> of a primary key of a given table? Suppose I've got a simple table
> like this:
>
> create table foo (
> foo_pkey int primary key,
> foo_data varchar(50)
> );
>
> In a programme I only know the table name "foo" and want to get the
> name of the primary key.
> Any help on this?
>
> Cheers,
> Chris
>
> --
> Christian von Kietzell
> mailto: chris@gammu.ath.cx
> Jabber: cuboci@charente.de
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>