Thread: pg_dump trunc some rows

pg_dump trunc some rows

From
"Mendola Gaetano"
Date:
Hi all,
I have a DB with encoding SQL_ASCII and in some field I have strange
character:

# \encoding
SQL_ASCII
# select city, id_country from user_data where id_user = 4146;          city            | id_country
---------------------------+------------Serra de Outes - A Coruña |         61
(1 row)


now if I do a dump the line relative to this row is truncated and
after the field city  field id_country is not dumped!!!

Any Idea?


Gaetano
Mendola