Re: Primary Keys - Mailing list pgsql-general

On Mon, 30 Apr 2001, Brian Z wrote:
> How can you create a Primary Key which contains multiple columns on for a
> table.
>
CREATE TABLE foo (
    col1    integer,
    col2    text,
    col3    timestamp,
    PRIMARY KEY (col1,col2)
);

Creates the primary key on columns col1 and col2. Please see the
documentation for CREATE TABLE for further information.

- Einar Karttunen