| 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: | Whole Thread | Raw Message | 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 |