From: | "Giorgio Ponza" <giorgio(at)opla(dot)it> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Stupid question on INDEXES |
Date: | 2001-12-19 13:03:50 |
Message-ID: | 002601c1888d$9ac2aba0$c801a8c0@opla.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
I'd like to know if i think in the right way. With
CREATE TABLE Test1 (
my_id int,
descr text,
primary key (my_id))
Postgres automatically creates an index named test1_pkey.
If i use
CREATE TABLE Test1 (
my_id int,
descr text)
without specifying a pkey, i can write
create unique index i_test1_pkey on (my_id).
The only difference is that in the 2nd case i can use the name i want, or
the usage is different?
Many thanks
Giorgio
From | Date | Subject | |
---|---|---|---|
Next Message | Paulo Jan | 2001-12-19 13:20:26 | Query hangs when getting too complex... |
Previous Message | Roderick A. Anderson | 2001-12-19 06:09:31 | Re: another foreign key question |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-19 15:11:51 | Re: Stupid question on INDEXES |
Previous Message | Peter Eisentraut | 2001-12-18 22:23:52 | Re: Operation on bit strings with different length |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-19 15:11:51 | Re: Stupid question on INDEXES |
Previous Message | Radu-Adrian Popescu | 2001-12-19 12:23:56 | Re: [SQL] Maximum Execution Timeout Error!! |