Re: Creating a table

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Reuben Olson <reuben(dot)olson(at)clear(dot)net(dot)nz>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a table
Date: 2001-11-12 03:29:08
Message-ID: 20011111192828.X72575-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 12 Nov 2001, Reuben Olson wrote:

> Hi there
>
> I am converting a mySQL database to postgresql database and I was
> wondering if there was any auto increment function like there is in
> mysql or di I need to use a sequence or something...

The easiest way is to use the serial type which is an int4 with an
associated sequence it takes its default value from.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-11-12 03:54:44 Re: Creating a table
Previous Message Reuben Olson 2001-11-12 02:42:39 Creating a table