From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matt Van Mater <nutter_@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to preserve \n in select statement
Date: Sat, 20 Dec 2003 13:35:26 -0500
Message-ID: <17818.1071945326@sss.pgh.pa.us> (raw)
In-Reply-To: <BAY9-F42t0CI76rOJhK00098f93@hotmail.com>
References: <BAY9-F42t0CI76rOJhK00098f93@hotmail.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, nutter_@hotmail.com
Subject: Re: how to preserve \n in select statement
In-Reply-To: <17818.1071945326@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox