Some newbie question
От | Ritesh Nadhani |
---|---|
Тема | Some newbie question |
Дата | |
Msg-id | 45380AF9.4020606@gmail.com обсуждение исходный текст |
Ответы |
Re: Some newbie question
Re: Some newbie question |
Список | 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
В списке pgsql-general по дате отправления: