Hello.
I have a database created with -E UTF-8. I need to transfer it to
pg8.1.2.
First I dumped the database:
pg_dump -v -E UTF-8 the_database > the_database.psql
Then I created the database on pg8.1.2
createdb the_database -E UTF-8
Then, I wanted to insert the dump:
psql -f the_database.ps
run this coversion command
time iconv -c -f UTF8 -t UTF8 -o newdump.sql olddump.sql
Josh O'Brien
Mario Splivalo wrote:
Hello.
I have a database created with -E UTF-8. I need to transfer it to
pg8.1.2.
First I dumped the database:
pg_dump -v -E UTF-8 the_database > the_database.psql
Then I
Mario Splivalo <[EMAIL PROTECTED]> writes:
> psql:the_database.psql:86: ERROR: invalid UTF-8 byte sequence detected
> near byte 0x8d
> CONTEXT: COPY _netsms, line 1367, column text: "Padamo u pozu 69.uz
> \umas mog macana u usta.a ja tvoju ljepu picu"
7.4's checking for valid UTF8 code seque