From: | Ritesh Nadhani <riteshn(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Some newbie question |
Date: | 2006-10-19 23:32:09 |
Message-ID: | 45380AF9.4020606@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence "ncbi_id_seq" for
serial column "ncbi.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"ncbi_pkey" for table "ncbi"
CREATE TABLE
test=# drop table ncbi;
DROP TABLE
test=# create table ncbi ( id serial, title varchar(50), abstract text);
NOTICE: CREATE TABLE will create implicit sequence "ncbi_id_seq" for
serial column "ncbi.id"
CREATE TABLE
======
q1) Does 'implicit index' means that they have given a default name to
the PK which I defined in the first query since I didnt give a name or
does it mean one another index is created apart from the PRIMARY KEY?
Ritesh
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-10-19 23:38:36 | Re: Latest /etc/rc.d/init.d/postgresql startup/shutdown script |
Previous Message | Maurice Yarrow | 2006-10-19 22:47:50 | Latest /etc/rc.d/init.d/postgresql startup/shutdown script |