From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | Jim Louis <jim(dot)louis(at)worldnet(dot)att(dot)net> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Where's The Primary Key? |
Date: | 2003-07-28 02:42:17 |
Message-ID: | 1059360137.2148.36.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am Fre, 2003-07-25 um 09.13 schrieb Jim Louis:
> Table "junk_t"
> Attribute | Type | Modifier
> -----------+---------+----------
> idx | integer | not null
> dat | integer |
> Index: junk_idx
\d junk_idx
apart from that, it's much easier just to do:
...
idx int PRIMARY KEY,
...
Just leave the naming of the index to postgresql.
FYI:
You may also want to use SERIAL instead of INT.
It creates INT but with (auto-filled) serial numbers (auto increment).
hth
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | A.Bhuvaneswaran | 2003-07-28 03:52:10 | Re: Accessing Postgres db from apache using PHP |
Previous Message | Rod Taylor | 2003-07-28 02:24:08 | Re: [PHP] Accessing Postgres db from apache using PHP |