Does PostgreSQL have a built in option for converting multi-line text to single line?
I need to store multiline text as Name=Value pairs, basically line .ini files, but need to convert Value back to its original form. Value might contain some escape sequences etc.
The multiline text is not that short and could be upto 65K in length.
Postgres does is capable of exporting multi-line text as single lines when it backups a table in
plain format without using SQL inserts. It is the type of text passed to the
COPY tablename (column1, column2, columnxx)from stdin when the plain text backup is views.
Is the function that does the conversion standalone?
quote_literal but it didn't come out the way I want.