From: Carlos Moreno <moreno_at_mochima_dot_com@mo.com>
To: pgsql-interfaces@postgresql.org
Subject: Getting "copy from" to work from a C++ program
Date: Wed, 03 Apr 2002 23:08:35 -0500
Message-ID: <3CABD1C3.8020606@mo.com> (raw)
Hi,
I'm trying to insert several records into a table in one shot
(from a C++ program, that is).
All my attempts to use "copy from" have failed (well, I
haven't tried copying from an actual file, since I have
the data in memory, and I'd like to avoid the overhead
to write it to a file first). Is it possible?? I've
tried things like:
PgDatabase db(" ..... ");
db.Exec ("copy deleteme from stdin\n1\tName1\n2\tName2");
And similar things (with a ; after stdin, with a \n. or
\n\\. at the end of the string -- they all fail with an
ErrorMessage() indicating a syntax error in the statement.
Help?!! :-(
Will it be necessary that I dump the data into a temporary
file and then do copy deleteme from tmpfile.txt ??
Thanks,
Carlos
--
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: moreno_at_mochima_dot_com@mo.com
Subject: Re: Getting "copy from" to work from a C++ program
In-Reply-To: <3CABD1C3.8020606@mo.com>
* 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