PostgreSQL 7.2 Documentation

From: "Mathias Zajaczkowski" <mathias(at)ubik(dot)ch>
To: <pgsql-docs(at)postgresql(dot)org>
Subject: PostgreSQL 7.2 Documentation
Date: 2002-09-02 14:43:20
Message-ID: 71BFB6708920D211967300805F85071C072A73@UBK_SRV1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


3.3. Foreign Keys

[..]
CREATE TABLE cities (
name varchar(80) primary key,
location point
);

CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);

Table weather refernces table cities and not itself.
Best regards

Mathias Zajaczkowski,
UBIK S.A.
Av. Cortot 7d,
1260, Nyon, Switzerland
Tel : +41 22 362 04 60
Fax: +41 22 362 04 61
mailto:mathias(at)ubik(dot)ch
http://www.ubik.ch

 

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jerome Chochon 2002-09-03 09:42:50 PostgreSQL papers
Previous Message Peter Eisentraut 2002-09-01 22:02:11 Re: Projects moved to gborg