Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group