Move data between two databases SQL-ASCII to UTF8

From: MargaretGillon(at)chromalloy(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Move data between two databases SQL-ASCII to UTF8
Date: 2007-02-09 00:07:29
Message-ID: OF9C7EE291.C0FB731C-ON8825727D.00001C28-8825727D.0000AEE9@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to convert my database to UTF8. Is there a way to do a SELECT ...
INSERT from the old database table to the new one? Would the INSERT
correct data errors between the two data types? I only have 10 tables and
the biggest has < 8000 rows.

Running Version 8.1.4 on Redhat 9
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the
intended recipient(s) and may contain proprietary and/or confidential
information which may be privileged or otherwise protected from
disclosure. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of
the message as well as any attachment(s) to the original message.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo 2007-02-09 00:42:47 Re: Move data between two databases SQL-ASCII to UTF8
Previous Message Merlin Moncure 2007-02-08 23:59:08 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9