Postgresql

[Kostas Georgakopoulos]

Gia aplo primary key :

CREATE TABLE abc (

        id  SERIAL UNIQUE NOT NULL PRIMARY KEY,
        field1     CHAR(2) NOT NULL,
        field2   VARCHAR(30) NOT NULL

);

Gia syntheto primary key:

CREATE TABLE abc (

        id_1    INT4 NOT NULL ,
        id_2    INT4 NOT NULL ,
        field1     VARCHAR(30) NOT NULL,
        PRIMARY KEY(id_1,id_2)

);

---------------------------------------------------------------------------
Kostas Georgakopoulos,
EDP/Technical Support
Northlink L.t.d E- Business Solutions
-
Tel. +3031522772
Fax +3031522772
Cel. +30932142872
-
URL: http://www.northlink.gr/
-
e-mail: kgeorga at northlink.gr   (personal account)
             info at northlink.gr      (Info account)
--------------------------------------------------------------------------

----- Original Message -----
From: "Giorgos Pallas" <gpall at hal.csd.auth.gr>
To: <linux-greek-users at hellug.gr>
Sent: Saturday, December 09, 2000 6:24 PM
Subject: Postgresql


> Re paidia exo faei tou kosmou to documentation, pos dilonei kaneis primary
> key stin Postgresql??
>
> Giorgos
>
>
> --
> linux-greek-users mailing list -- http://lists.hellug.gr