From: Jan Klostermann <klostermann@rhf.de>
To: pgsql-interfaces@postgresql.org
Subject: Parameterized queries
Date: Fri, 14 Nov 2003 17:05:46 +0100
Message-ID: <001b01c3aac9$2a7d77c0$f564a8c0@BARCELONA> (raw)
Hello,
I would like to know, if there exists a way in PostgreSQL to insert data
not exclusively via the SQL-query-string but using a direct data
interface, thus avoiding parsing the data into string and then back into
binary data representation (e.g. Double).
What I would like to use is a query like this: INSERT INTO table
(number1, number2) VALUES (?,?)
Before executing the query the command structure would be fill with the
parameters for the 2 values (e.g. 3.33 and 5.555) and then there would
follow the execution, where the query parser would replace the "?" with
the current data of the parameters and execute the appopriate query.
Unfortunately I cannot find anything about query-contructions with
question marks ("?"), therefore I am already wondering if this way of
transfering data exists with PostgreSQL!?
Is there anybody out there, who can help me with this?
Is there another way of efficiently transfering data, avoiding parsing
back and forth?
Jan Klostermann
PS: I tried to do it via the ODBC interface and it did not work. Then I
scanned through the documentation, incl. libpq and did not find anything
related.
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-interfaces@postgresql.org
Cc: klostermann@rhf.de
Subject: Re: Parameterized queries
In-Reply-To: <001b01c3aac9$2a7d77c0$f564a8c0@BARCELONA>
* 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