Re: [GENERAL] how to insert data in a row with serial type

From: "Moray McConnachie" <moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk>
To: "Jaume Pausas" <a1649(at)dis(dot)ulpgc(dot)es>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] how to insert data in a row with serial type
Date: 2000-02-10 11:13:06
Message-ID: 010c01bf73b7$ce5fd6a0$760e01a3@oucs.ox.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
From: Jaume Pausas <a1649(at)dis(dot)ulpgc(dot)es>
To: <pgsql-general(at)postgreSQL(dot)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');

In response to

Browse pgsql-general by date

  From Date Subject
Next Message slamet pramono 2000-02-10 12:18:33 UNSUBSCRIBE
Previous Message Jaume Pausas 2000-02-10 11:03:43 how to insert data in a row with serial type