Auto increment

Поиск
Список
Период
Сортировка
От Fontenot, Paul
Тема Auto increment
Дата
Msg-id 230BCAB977308F43BD851AFAE55A86413D6CFA@phx01018.bannerhealth.com
обсуждение исходный текст
Ответы Re: Auto increment  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: Auto increment  (Doug Silver <dsilver@urchin.com>)
Re: Auto increment  (Adam Witney <awitney@sghms.ac.uk>)
Re: Auto increment  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-novice
When creating a table how do you make an auto incrementing field? I'm
using:

Create table hosts (
    id int not null unique primary key,
    ip char(16),
    hostname text
);

Is there a way to make the host.id field automagicaly increment?

 ***PRIVILEGED & CONFIDENTIAL***
Unless expressly stated otherwise, this message (and any attachment(s)
thereto) is confidential and may be privileged. It is intended for the
addressee(s) only. If you are not an addressee, any disclosure or
copying of the contents of this e-mail or any action taken (or not
taken) in reliance on it is strictly prohibited. If you are not an
addressee, please inform sender immediately and delete this message from
your system.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: Examples of accessing postgresql with scripts?
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Transaction in function problem