From: | "Christian Marschalek" <cm(at)chello(dot)at> |
---|---|
To: | "'Brian Z'" <brian0(at)verizon(dot)net> |
Cc: | "[GENERAL] PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: [ADMIN] Primary Keys |
Date: | 2001-05-05 13:15:15 |
Message-ID: | 000101c0d565$7e19b100$0200a8c0@server |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
I'll quote Thomas F.O'Connell on this one as it has been discussed just
some days ago:
<quote>
first of all, i recommend checking out the syntax for the CREATE TABLE
command. it's available here:
http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/sql-cre
atetable.html
for a quick example, though:
create table foo (
bar int4,
baz int4,
ola int4,
primary key( bar, baz )
);
this statement will make the columns bar and baz coincidentally the
primary key for the table foo.
-tfo
</quote>
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Brian Z
> Sent: Monday, April 30, 2001 11:21 PM
> To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general@postgresql.org
> Subject: [ADMIN] Primary Keys
>
>
> How can you create a Primary Key which contains multiple
> columns on for a table.
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your message can get through
> to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-05 14:52:30 | Re: PostgreSQL 7.1 now in OpenBSD ports/packages |
Previous Message | John Pagakis | 2001-05-04 23:56:40 | RE: Queries |
From | Date | Subject | |
---|---|---|---|
Next Message | Gyozo Papp | 2001-05-05 13:45:51 | Re: psql with PHP question |
Previous Message | Eric G. Miller | 2001-05-05 13:13:06 | Re: arbitrary number of values from a sequence |