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"
On Thu, 2006-10-19 at 19:05 -0500, Ritesh Nadhani wrote:
> Thanks.
>
> So the implicit value means that PG gave it a name?
>
Right, when you declare a column to be a primary key, PostgreSQL must
create an index to enforce the unique constraint. This index must have
some kind of name, so PostgreS
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 tex
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 seq
