Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B69FA635766
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Apr 2009 16:01:29 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 52193-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Apr 2009 16:01:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.25])
	by mail.postgresql.org (Postfix) with ESMTP id 29DF163534B
	for <pgsql-sql@postgresql.org>; Thu, 16 Apr 2009 16:00:29 -0300 (ADT)
Received: by qw-out-2122.google.com with SMTP id 8so451696qwh.61
	for <pgsql-sql@postgresql.org>; Thu, 16 Apr 2009 12:00:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=O4XOUdesawx5xThys85+hNILOLeknrcyy38ljoWfVtc=;
	b=jFIH5pUFByeTBQC4VGZkBH8wUbaGtT8UHsxEhhfH884Q/t3Jz1hbk18Yku7szr8S0t
	LbiTI5xMV0P9TNqfP/22oGZaNCuuCpYpPAIGucpJ13GNBxI9DP2rx0FytfdXrfTwr85C
	tjPJQjq9pGVIEpLI6JeI6bXp5KAYeTBhDI5sw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=ibhV9zYr0+dQshMa3cK5uyuIJH8hUTPSC67IBt+dOqbxr8iP56RCbipXEV/2sW5gst
	ncQm8mYPVK32rE0fWRtIf6VzN28tQzzNR0blVazskawuhzBwYaDNMhV5SGoZ4WS60gJC
	xg3TOOqGa81mdm6nD/NskDSmU1RhcdWY1Klzc=
MIME-Version: 1.0
Received: by 10.224.3.8 with SMTP id 8mr2248093qal.364.1239908428727; Thu, 16
	Apr 2009 12:00:28 -0700 (PDT)
Date: Thu, 16 Apr 2009 12:00:28 -0700
Message-ID: <eae6a62a0904161200j14dd0759j9b3fb656f526f833@mail.gmail.com>
Subject: how to set the value to the column
From: DM <dm.aeqa@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0015175ca7be731aa10467b0adb8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200904/93
X-Sequence-Number: 32439

--0015175ca7be731aa10467b0adb8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--0015175ca7be731aa10467b0adb8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi All,</div>
<div>=A0</div>
<div>I have a table test with columns name and value</div>
<div>=A0</div>
<div>test table</div>
<div>name</div>
<div>value</div>
<div>=A0</div>
<div>It has=A0around 500 rows.</div>
<div>=A0</div>
<div>I added a new column id to the table, </div>
<div>=A0</div>
<div>Table test</div>
<div>id,</div>
<div>name,</div>
<div>value</div>
<div>=A0</div>
<div>I am not sure how to insert numbers to my column id (1-500).</div>
<div>=A0</div>
<div>Thanks</div>
<div>=A0</div>
<div>=A0</div>

--0015175ca7be731aa10467b0adb8--