Thread

1. primary keys

   Perry Seleski <seleski@ronix.ptf.hro.nl> — 1998-05-18T07:48:30Z

   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
   
   

2. Re: [SQL] primary keys

   Marin D <marin@iclub.techno-link.com> — 1998-05-18T12:29:02Z

   Just use the ANSI SQL syntax
   
   
   On Mon, 18 May 1998, Perry Seleski wrote:
   
   > 
   > CREATE TABLE Homepages (
   > 	URL			varchar(80) PRIMARY KEY,
   > 
   
   	
   Marin