Re: Parse error creating tables - Mailing list pgsql-novice

From Nikola Milutinovic
Subject Re: Parse error creating tables
Date
Msg-id 001f01c0f87e$f9d24a50$6e3da8c0@ev.co.yu
Whole thread Raw
In response to Parse error creating tables  (Juan Jose Natera Abreu <jnatera@net-uno.net>)
List 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.

pgsql-novice by date:

Previous
From: GH
Date:
Subject: Re: Insert into two tables
Next
From: Poul Kristensen
Date:
Subject: no suitable driver i browser - but works fine in appletviewer