primary keys

From: Perry Seleski <seleski(at)ronix(dot)ptf(dot)hro(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: primary keys
Date: 1998-05-18 07:48:30
Message-ID: 355FE7CE.167E@ronix.ptf.hro.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marin D 1998-05-18 12:29:02 Re: [SQL] primary keys
Previous Message Andy Lewis 1998-05-16 14:10:06 Re: [SQL] Duplicate rows