Postgres Pro
Downloads
Home   >   mailing lists

Re: Bulk Load and Extract from PostgreSQL - Mailing list pgsql-interfaces

From Sean Davis
Subject Re: Bulk Load and Extract from PostgreSQL
Date
Msg-id 200610160634.45848.sdavis2@mail.nih.gov
Whole thread Raw
In response to Bulk Load and Extract from PostgreSQL  (Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com>)
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Sandeep Khandelwal
Date:
Subject: Bulk Load and Extract from PostgreSQL
Next
From: Andro
Date:
Subject: play with current schema