Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicated tables of certain columns - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: Duplicated tables of certain columns
Date
Msg-id 4F3E2293-BEDB-4417-AD54-0049A64D8CD4@enterprisedb.com
Whole thread Raw
In response to Duplicated tables of certain columns  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List pgsql-general
Tree view 
On Feb 21, 2011, at 1:39 PM, Yan Cheng CHEOK wrote:

> INSERT INTO backup_table SELECT * FROM unit_11 WHERE status = 1;



You can try something like,
INSERT INTO backup_table select unit_id, 99, status, value from unit_11 where status=1;


Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Cell: +91-932-568-2279
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Yan Cheng CHEOK
Date:
Subject: Duplicated tables of certain columns
Next
From: Vibhor Kumar
Date:
Subject: Re: Schema Archive cant find table