Thread: how to insert data in a row with serial type

Hi!

How to insert data in a registry like

create table pp (
    cod serial primary key,
    des text not null allowed
);

insert into pp values ('','hola');

----- Original Message -----
From: Jaume Pausas <a1649@dis.ulpgc.es>
To: <pgsql-general@postgreSQL.org>
Sent: Thursday, February 10, 2000 11:03 AM
Subject: [GENERAL] how to insert data in a row with serial type


> Hi!
>
> How to insert data in a registry like
>
> create table pp (
>     cod serial primary key,
>     des text not null allowed
> );
>
> insert into pp values ('','hola');

INSERT INTO pp (des) VALUES ('hola');