automatic numbering in a new column

From: ppdcc(at)sapo(dot)pt
To: pgadmin-support(at)postgresql(dot)org
Subject: automatic numbering in a new column
Date: 2011-08-24 18:40:13
Message-ID: 20110824194013.11313oys0qgyid8t@mail.sapo.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


Hello to all,

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?
This column don?t have to be the primary key but has to be unique for
each feature.

can anybody tell me?

thanks

pdcc

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-08-24 18:43:04 Re: automatic numbering in a new column
Previous Message Richard Broersma 2011-08-24 16:09:56 Re: Views->Create Script + Regular Expressions