Re: Bulk Load and Extract from PostgreSQL

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com>
Subject: Re: Bulk Load and Extract from PostgreSQL
Date: 2006-10-16 10:34:45
Message-ID: 200610160634.45848.sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Andro 2006-10-16 15:58:21 play with current schema
Previous Message Sandeep Khandelwal 2006-10-16 07:07:53 Bulk Load and Extract from PostgreSQL