Re: how to preserve \n in select statement

"Matt Van Mater" <nutter_@hotmail.com> writes:
>> In particular, you have to separate data from SQL command if you want a
>> no-escape-processing behavior for data.

> right, I was looking for the alternate input methods that you allude to.  I 
> have been unable to find an example of exactly how to do this.

The best way at the moment is to use the parameterized-statement
features that are new in 7.4.  If using libpq, see PQexecParams()
and siblings.
        regards, tom lane