From: Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com>
To: sdavis2@mail.nih.gov
To: pgsql-interfaces@postgresql.org
Subject: Re: Bulk Load and Extract from PostgreSQL
Date: Mon, 16 Oct 2006 22:36:03 -0700 (PDT)
Message-ID: <20061017053603.33289.qmail@web33309.mail.mud.yahoo.com> (raw)
Hi Sean.
Thanks for the reply.
I have one more question. While extracting data using COPT TO command (in TEXT mode) we have an API, PQunescapeBytea, to convert string representation of binary data(bytea) into binary. Similary we need to convert binary data into it's string representation while loading data into PostgreSQL ,using COPY FROM command in TEXT mode, with PQputCopydata. But there is no API to convert binary data into it's string representation. Could you tell me API or I am misinterpreting something.
Thanks in advance,
Sandeep
----- Original Message ----
From: Sean Davis <sdavis2@mail.nih.gov>
To: pgsql-interfaces@postgresql.org
Cc: Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com>
Sent: Monday, October 16, 2006 4:04:45 PM
Subject: Re: [INTERFACES] Bulk Load and Extract from PostgreSQL
On Monday 16 October 2006 03:07, Sandeep Khandelwal wrote:
> Hi All.
>
> I want to extract and Load data from PostgreSQL using Libpq C API. Please
> let me know which approach will be good to load large number of rows into
> PostgreSQL(Insert or COPY FROM) and, which approach will be good to extract
> large number of rows from PostgreSQL (COPY TO or SELECT). I want to handle
> all the data types supported in the PostgreSQL.
copy is the faster way to go for a single table.
Sean
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
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: sandeep_khandelwal27@yahoo.com, sdavis2@mail.nih.gov
Subject: Re: Bulk Load and Extract from PostgreSQL
In-Reply-To: <20061017053603.33289.qmail@web33309.mail.mud.yahoo.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