Re: automatic numbering in a new column

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: ppdcc(at)sapo(dot)pt
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: automatic numbering in a new column
Date: 2011-08-24 18:43:04
Message-ID: 1314211384.2193.35.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, 2011-08-24 at 19:40 +0100, ppdcc(at)sapo(dot)pt wrote:
[...]
>
> I'm have a database with two tables, one of them is the streets. Can
> anybody tell me how do i create, with a sql instruction, a new column
> with automatic numbering in this table?

Use the serial pseudo type for this column.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-08-24 18:52:28 Re: automatic numbering in a new column
Previous Message ppdcc 2011-08-24 18:40:13 automatic numbering in a new column