Re: Some newbie question

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
> 
> 
>