Re: how to preserve \n in select statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matt Van Mater" <nutter_(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to preserve \n in select statement
Date: 2003-12-20 18:35:26
Message-ID: 17818.1071945326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Lau 2003-12-22 08:54:01 Get x from point?
Previous Message Matt Van Mater 2003-12-20 17:58:39 Re: how to preserve \n in select statement