Postgres Pro
Downloads
Home   >   mailing lists

Re: automatic numbering in a new column - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: automatic numbering in a new column
Date
Msg-id 1314211384.2193.35.camel@localhost.localdomain
Whole thread Raw
In response to automatic numbering in a new column  (ppdcc@sapo.pt)
List pgadmin-support
Tree view 
On Wed, 2011-08-24 at 19:40 +0100, ppdcc@sapo.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

pgadmin-support by date:

Previous
From: ppdcc@sapo.pt
Date:
Subject: automatic numbering in a new column
Next
From: Guillaume Lelarge
Date:
Subject: Re: automatic numbering in a new column