primary keys - Mailing list pgsql-sql

From Perry Seleski
Subject primary keys
Date
Msg-id 355FE7CE.167E@ronix.ptf.hro.nl
Whole thread Raw
Responses Re: [SQL] primary keys  (Marin D <marin@iclub.techno-link.com>)
List pgsql-sql
I would really like to know how I can define a primary key in postgres.
The database is for a search engine. The table looks like this:

CREATE TABLE Homepages (
    URL            varchar(80),
    PageName        varchar(80),
    UserName        varchar(40),
    Keywords        varchar(255)
);

And I'd like to define the attibute URL as the primary key but I've
got no clue on how to do that. Anyone?

Thanks in advance,

Perry Seleski
Rotterdam Art Institute

pgsql-sql by date:

Previous
From: Andy Lewis
Date:
Subject: Re: [SQL] Duplicate rows
Next
From: Marin D
Date:
Subject: Re: [SQL] primary keys