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   <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to