Postgres Pro
Downloads
Home   >   mailing lists

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 17818.1071945326@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
Tree view 
"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

pgsql-sql by date:

Previous
From: "Matt Van Mater"
Date:
Subject: Re: how to preserve \n in select statement
Next
From: Daniel Lau
Date:
Subject: Get x from point?