pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (2+ messages)  latest in thread

Message-ID: <002601c1888d$9ac2aba0$c801a8c0@opla.it>
Permalink:  ../002601c1888d$9ac2aba0$c801a8c0@opla.it/
Also on:    postgresql.org/message-id/002601c1888d$9ac2aba0$c801a8c0@opla.it

 · 

reply

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