Search Postgresql Archives

Re: Some newbie question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks.

So the implicit value means that PG gave it a name?

Jeff Davis wrote:
On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:
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?


It only creates one index, the primary key index.

Regards,
	Jeff Davis





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux