Move data between two databases SQL-ASCII to UTF8

Поиск
Список
Период
Сортировка
От MargaretGillon@chromalloy.com
Тема Move data between two databases SQL-ASCII to UTF8
Дата
Msg-id OF9C7EE291.C0FB731C-ON8825727D.00001C28-8825727D.0000AEE9@CHROMALLOY.COM
обсуждение исходный текст
Ответы Re: Move data between two databases SQL-ASCII to UTF8  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Следующее
От: Clodoaldo
Дата:
Сообщение: Re: Move data between two databases SQL-ASCII to UTF8