Re: how to preserve \n in select statement - Mailing list pgsql-sql

From Tom Lane
Subject Re: how to preserve \n in select statement
Date
Msg-id 14347.1071895547@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to preserve \n in select statement  ("Matt Van Mater" <nutter_@hotmail.com>)
List pgsql-sql
"Matt Van Mater" <nutter_@hotmail.com> writes:
> I just don't see why pgsql can't return my data exactly as I entered
> it.

Because you are using an input syntax that requires that quotes and
backslashes be escaped.  There are other input methods available that
don't require this, but they have disadvantages of their own.  In
particular, you have to separate data from SQL command if you want a
no-escape-processing behavior for data.

> I think this behavior stems from a security problem psql had a while
> back where escape characters were being interpreted, and this may be
> another instance of that functionality.

Matt, you have no idea what you are talking about.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Matt Van Mater"
Date:
Subject: Re: how to preserve \n in select statement
Next
From: "Matt Van Mater"
Date:
Subject: Re: how to preserve \n in select statement