how to set the value to the column

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: how to set the value to the column
Date: 2009-04-16 19:00:28
Message-ID: eae6a62a0904161200j14dd0759j9b3fb656f526f833@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I have a table test with columns name and value

test table
name
value

It has around 500 rows.

I added a new column id to the table,

Table test
id,
name,
value

I am not sure how to insert numbers to my column id (1-500).

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message DM 2009-04-16 19:11:00 Re: how to set the value to the column
Previous Message Tom Lane 2009-04-16 14:13:20 Re: Ordering a name list and ignoring whitespace