Stupid question on INDEXES

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-novice by date

  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

Browse pgsql-sql by date

  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!!