Stupid question on INDEXES - Mailing list pgsql-novice

From Giorgio Ponza
Subject Stupid question on INDEXES
Date
Msg-id 002601c1888d$9ac2aba0$c801a8c0@opla.it
Whole thread Raw
In response to Re: Operation on bit strings with different length  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Stupid question on INDEXES
List pgsql-novice
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



pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Operation on bit strings with different length
Next
From: Tom Lane
Date:
Subject: Re: Stupid question on INDEXES