From: | "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu> |
---|---|
To: | "Juan Jose Natera Abreu" <jnatera(at)net-uno(dot)net> |
Cc: | "PostgreSQL novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Parse error creating tables |
Date: | 2001-06-19 05:16:20 |
Message-ID: | 001f01c0f87e$f9d24a50$6e3da8c0@ev.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> Here are 2 of the tables i am trying to create:
>
> CREATE TABLE Distribucion (
> Id serial PRIMARY KEY NOT NULL,
> Nombre varchar(15)
> );
>
> CREATE TABLE Perfil_Aplicacion (
> Id serial PRIMARY KEY NOT NULL,
> Nombre varchar(20),
> Abreviatura char(4),
> Descripcion varchar(50),
> Distribucion integer,
> Enviar_Correo boolean,
> Enviar_Page boolean,
> Enviar_Popup boolean,
> Numero_Aprobadores integer,
> Numero_Acciones integer,
> Cierre_Automatico boolean,
> Caduca integer,
> FOREIGN KEY Distribucion REFERENCES Distribucion(Id)
> );
FOREIGN KEY <field> REFERENCES <table>
Where <field is a field in your table and <table> is another table, your table is referncing.
Nix.
From | Date | Subject | |
---|---|---|---|
Next Message | Diogo Saad | 2001-06-19 21:51:01 | database size |
Previous Message | GH | 2001-06-19 03:14:52 | Re: Insert into two tables |