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