A few comments before answering:
1. Don't top post. It makes it hard to read.
2. Reply to the list.
3. Choose your list more carefully. pgadmin-support is about pgAdmin
support, not about SQL.
This being said, I'll quickly answer your question...
On Wed, 2011-08-24 at 19:47 +0100, pp...@sapo.p
On Wed, 2011-08-24 at 19:40 +0100, pp...@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.
