Re: Newbie Question - Mailing list pgsql-general

From Joel Burton
Subject Re: Newbie Question
Date
Msg-id Pine.LNX.4.21.0105041716430.3424-100000@olympus.scw.org
Whole thread Raw
In response to Newbie Question  ("Clay & Judi Kinney" <cricketk@home.com>)
List pgsql-general
On Tue, 1 May 2001, Clay & Judi Kinney wrote:

> How do I create an autoincrement field in a postgresql table???
>
> What are the correct field type and parameters????
>
> Any help would be appreciated.....

CREATE TABLE foo (
  id SERIAL,
  ...
)

it comes out as an int4 or integer type.

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-general by date:

Previous
From: John Coers
Date:
Subject: Re: commit_delay CANCEL
Next
From: "Mitch Vincent"
Date:
Subject: Re: underlying structure: varchar vs. text