Primary and foreign key - Mailing list pgsql-sql

From Daniel Facciolo Pires
Subject Primary and foreign key
Date
Msg-id Pine.SOL.3.93.980915181905.14560B-100000@pilsen.intermidia.icmsc.sc.usp.br
Whole thread Raw
List 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@intermidia.icmc.sc.usp.br
http://www.intermidia.icmc.sc.usp.br/~dfpires


pgsql-sql by date:

Previous
From: Leslie Mikesell
Date:
Subject: varchar vs. upper(), lower() etc.
Next
From: maloune
Date:
Subject: create a new user in a group