From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Nosyman <nosyman(at)easymail(dot)ro> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: PRIMARY KEY and INDEX |
Date: | 2004-09-02 14:48:35 |
Message-ID: | Pine.LNX.4.61.0409021747590.1213@emo.org.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Thu, 2 Sep 2004, Nosyman wrote:
> It is necessary to define an index for a primary key column?
>
> Let's have an example
> CREATE TABLE users(
> id_user INTEGER PRIMARY KEY,
> user_name VARCHAR(25)
> );
>
> Does PgSQL automatically create an index for id_user (primary key) or it
> must be created by hand?
You could give it a try before asking:
test=# CREATE TABLE users(
test(# id_user INTEGER PRIMARY KEY,
test(# user_name VARCHAR(25)
test(# );
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"users_pkey" for table "users"
CREATE TABLE
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBNzLFtl86P3SPfQ4RAuOZAKDoE5NFtu7B3Dg356+CH5P9CGp7cgCfaBQm
33nie6C/x2PIfA0D1zqWgLE=
=QlUA
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Nosyman | 2004-09-02 16:58:16 | PRIMARY KEY and INDEX |
Previous Message | Jeff Boes | 2004-09-02 14:39:36 | Re: Complicated "group by" question |