Re: Where's The Primary Key?

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

In response to

Browse pgsql-novice by date

  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