I am a universitary student from BRASIL, and I�m using PostGreSQL data base.
I�m designing my data base and I have one question.
How to create a foreing key in PostGreSQL.
I�m using the following command:
CREATE TABLE test(
pnr char(10),
nome char(20),
id   decimal REFERENCE <parent table>);

and

CREATE TABLE test(
pnr char(10),
nome char(20),
id decimal,
FOREING KEY (id) REFERENCES <parent table>);

Where parent table is the table with the primary key.

Regards

Filipi Damasceno Vianna
&
Alessandro Orso

Wed, 2 Jun 1999 17:29:36 -0300
Filipi Damasceno Viana <filipi@em.pucrs.br>
Foreign Key in PostGreSQL