restore

From: Dinesh Bhandary <dbhandary(at)iii(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: restore
Date: 2010-10-05 18:08:11
Message-ID: 4CAB698B.4040402@iii.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

Is there an easy way to restore to a new table where the column name
have been changed but data remains the same?
For example I am trying to restore from existing system, table1(col1)
to table1(col2) and it is erroring out on the new column name even
though it is a data only restore. I was just wondering if there is a
quick way to bypass this. Let me know.

Thanks.

Dinesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-10-05 18:15:32 Re: restore
Previous Message A J 2010-10-05 17:51:18 Re: ECPG: AUTOCOMMIT and CURSORs