Menu

#451 Export is adding duplicate carriage return and new line characters into TEXT field

5.1
open
nobody
Export (1)
5
2015-04-06
2015-04-06
Mark
No

NOTE: I am a new user, so if I haven't provided the proper information or have not followed the proper protocols, please let me know.

In a table field of type TEXT, I have created an entry with a carriage return/newline, as follows:

text
text


In the above, the carriage return/newline shows as ASCII 13 and 10, one each.

If I export the table using phpPgAdmin and dump the existing table, and then reimport the exported SQL file, it appears that the carriage return/newline get duplicated in the export process, changing the entry to the following:

text

text

If I run the export using pg_dump from a command line, and import with phpPgAdmin, this issue does not happen.

This is changing the original data in the database table, which to me seems to be a big no-no.

Discussion


Log in to post a comment.