Some newbie question

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

Responses

Browse pgsql-general by date

  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