Received: from mail.d2interactive.com (mail.y2interactive.com [64.224.155.97] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4G41FA22153 for ; Wed, 16 May 2001 00:01:15 -0400 (EDT) (envelope-from tswan@olemiss.edu) Received: from olemiss.edu [12.6.178.90] by mail.d2interactive.com with ESMTP (SMTPD32-6.00) id AE184D10086; Mon, 14 May 2001 17:28:56 -0400 Message-ID: <3B004DC6.70301@olemiss.edu> Date: Mon, 14 May 2001 16:27:34 -0500 From: Thomas Swan User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:0.9+) Gecko/20010511 X-Accept-Language: en MIME-Version: 1.0 To: Sylte CC: pgsql-sql@postgresql.org Subject: Re: Auto incrementing an integer References: <9dokvu$4uo$1@sunsite.dk> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/157 X-Sequence-Number: 2974 Sylte wrote: >How do I construct a datatype that autoincrement in postgreSQL? > Use the SERIAL data type instead of an INT4. Serial is an integer (INT4) that's default value is base on a sequence. for example... create table foo ( my_id serial not null, my_data text );