Primary and foreign key

From: Daniel Facciolo Pires <dfpires(at)pilsen(dot)intermidia(dot)icmsc(dot)sc(dot)usp(dot)br>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Primary and foreign key
Date: 1998-09-15 21:24:17
Message-ID: Pine.SOL.3.93.980915181905.14560B-100000@pilsen.intermidia.icmsc.sc.usp.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I don't know how can I set an attribute like a primary key.

And how can I set the references integrated.

I saw at help's PostgreSQL:

create table <class_name>
(<attr1> <type1> [default <expression>] [not null] [,...])
[inherits (<class_name1>,...<class_nameN>)
[[constraint <name>] check <condition> [,...] ]

Will I have to control the integrated by myself in the program?

Thanks!

-----------------------------------------
Daniel Facciolo Pires
Mestrado em Ciencias da Computacao
ICMC-USP-Sao Carlos
Grupo: Hipermidia
dfpires(at)intermidia(dot)icmc(dot)sc(dot)usp(dot)br
http://www.intermidia.icmc.sc.usp.br/~dfpires

Browse pgsql-sql by date

  From Date Subject
Next Message maloune 1998-09-16 12:33:51 create a new user in a group
Previous Message Leslie Mikesell 1998-09-15 18:46:31 varchar vs. upper(), lower() etc.