Hi
I must copy rows from local database (UNICODE) to remote database SQL_ASCII
(not on local machine) with converting selected columns to iso8859_2 or
iso_8859_5. Can I make it with COPY?
On Sat, 18 Nov 2006 09:42:14 -0500, Travis Whitton wrote
> You can use the postgresql COPY command to dump
Hi
Yes, but I must convert diffrent columns to diffrent iso-codes.
With pg_dump I can only dump all columns from database and these all columns
convert only to one iso-code.
On Fri, 17 Nov 2006 14:11:25 -0500, Travis Whitton wrote
> There might be better ways, but you could dump the data and u
Hi
New database must be in SQL_ASCII. In old database (UNICODE) are for example
2 columns. Rows from first column I must convert to ISO_8859_2 and insert it
to first column in SQL_ASCII database, and rows from second column I must
convert to IS0_8859_5 and insert to second column in SQL_ASCII d
How about pg_dump the data from your old database, then load it into
your new database which is using UTF8?
Drew
On Nov 17, 2006, at 9:09 AM, lms wrote:
Hello
I have 2 databases with same table. First database is in UNICODE,
second in
SQL_ASCII.
4 columns from first database I must conv
Hello
I have 2 databases with same table. First database is in UNICODE, second in
SQL_ASCII.
4 columns from first database I must convert to:
(first column)iso8859-1,
(second column)iso8859-2,
(3-th column)iso8859-1,
(4 column)iso8859-5.
After it I must save these 4 rows in database in SQL_
