Adding a unique number to each record in a table

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Adding a unique number to each record in a table
Date: 2011-10-24 16:19:08
Message-ID: CAADeyWjTe0oP+XiUxmjd3uc=6_E9qYz-TZziaWs4HkS9yXq_UA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a table in PostgreSQL 8.4.9 storing
user comments (in the "about" field):

# \d pref_rep
Table "public.pref_rep"
Column | Type | Modifiers
------------+-----------------------------+---------------
id | character varying(32) |
author | character varying(32) |
good | boolean |
fair | boolean |
nice | boolean |
about | character varying(256) |
last_rated | timestamp without time zone | default now()
author_ip | inet |
Check constraints:
"pref_rep_check" CHECK (id::text <> author::text)
Foreign-key constraints:
"pref_rep_author_fkey" FOREIGN KEY (author) REFERENCES pref_users(id)
"pref_rep_id_fkey" FOREIGN KEY (id) REFERENCES pref_users(id)

But now after having 40000 comments I've
realized, that I need a web script for me as
admin - for delete obscene/aggressive ones.

Because doing it thru "psql" is tedious + error prone.

Is there please a way to add a column to my table,
which I could use to uniquely identify each
record in that table (incl. old records)

Regards
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2011-10-24 16:43:18 Re: Adding a unique number to each record in a table
Previous Message Javier Amor Garcia 2011-10-24 15:45:14 Re: Error inserting RFC1738-encoded URLs