From: Sean Davis <sdavis2@mail.nih.gov>
To: pgsql-interfaces@postgresql.org
Cc: Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com>
Subject: Re: Bulk Load and Extract from PostgreSQL
Date: Mon, 16 Oct 2006 06:34:45 -0400
Message-ID: <200610160634.45848.sdavis2@mail.nih.gov> (raw)
In-Reply-To: <20061016070753.42936.qmail@web33304.mail.mud.yahoo.com>
References: <20061016070753.42936.qmail@web33304.mail.mud.yahoo.com>
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
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: sdavis2@mail.nih.gov, sandeep_khandelwal27@yahoo.com
Subject: Re: Bulk Load and Extract from PostgreSQL
In-Reply-To: <200610160634.45848.sdavis2@mail.nih.gov>
* 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