From: Giorgio Ponza <giorgio@opla.it>
To: pgsql-novice@postgresql.org
Subject: Stupid question on INDEXES
Date: Wed, 19 Dec 2001 14:03:50 +0100
Message-ID: <002601c1888d$9ac2aba0$c801a8c0@opla.it> (raw)
References: <web-531103@davinci.ethosmedia.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: giorgio@opla.it, pgsql-novice@postgresql.org
Subject: Re: Stupid question on INDEXES
In-Reply-To: <002601c1888d$9ac2aba0$c801a8c0@opla.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox