Re: Primary Keys

Brian Z wrote:

> How can you create a Primary Key which contains multiple columns on for a
> table.

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-createtable.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