Re: how to preserve \n in select statement

"Matt Van Mater" <nutter_(at)hotmail(dot)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