Re: serial

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Marcelo Fernández <fernandezm22(at)yahoo(dot)com(dot)ar>
Cc: Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: serial
Date: 2008-12-04 16:16:16
Message-ID: 20081204161616.GN4106@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Marcelo Fernández escribió:
> Gustavo Rosso escribió:

> Hola Gustavo, por ejemplo así:
>
> CREATE TABLE cliente (
> id SERIAL PRIMARY KEY,
> apellido VARCHAR(30),
> nombre VARCHAR(30)
> );

> Ejemplo:
>
> INSERT INTO CLIENTE (apellido, nombre) VALUES ('Rosso','Gustavo');

otro ejemplo:

INSERT INTO CLIENTE (id, apellido, nombre) VALUES (DEFAULT, 'Rosso','Gustavo');

--
Alvaro Herrera Valdivia, Chile Geotag: -39,815 -73,257
"If it wasn't for my companion, I believe I'd be having
the time of my life" (John Dunbar)

In response to

  • Re: serial at 2008-12-04 16:11:49 from Marcelo Fernández

Responses

  • Re: serial at 2008-12-04 16:18:43 from Alvaro Herrera

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-04 16:18:43 Re: serial
Previous Message Edwin Quijada 2008-12-04 16:16:09 RE: serial