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 по дате отправления: