How to insert with a serial
От
elwood@agouros.de (Konstantinos Agouros)
Тема
How to insert with a serial
Дата
Msg-id
elwood.1003670142@news.agouros.de
Список
Дерево обсуждения
Re: How to insert with a serial "Ian Harding" <ianh@tpchd.org>
Hi,
I have a table defined like this:
Attribute | Type | Modifier
-------------+-----------------------+------------------------------------------
name | character varying(40) |
type | integer |
id | integer | not null default nextval('serial'::text)
ownerteamid | integer |
Index: devices_pkey
How do I insert into it so that id is automatically incremented?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres
В списке pgsql-general по дате отправления