Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C98A79FA383 for ; Mon, 16 Oct 2006 04:07:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97432-09 for ; Mon, 16 Oct 2006 04:07:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web33304.mail.mud.yahoo.com (web33304.mail.mud.yahoo.com [68.142.206.119]) by postgresql.org (Postfix) with SMTP id 5AD8A9FA085 for ; Mon, 16 Oct 2006 04:07:54 -0300 (ADT) Received: (qmail 42938 invoked by uid 60001); 16 Oct 2006 07:07:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=t1t/uCFYxJFAsQpRKy/nsffyQC4/NnHOaxvvHnlvM/9UA/+lFe7EWzYOO6fJXaDhW2J4NdFnUm6qAKz2O4X6Ehjc2DxoeWdMh50rxHEYMlP7PggC4TZSdHArDQgtdD0R6j9Rbfo7Bzr8hYSek9XS4nh+B6c+ARbGcWkU1J6UWeA= ; Message-ID: <20061016070753.42936.qmail@web33304.mail.mud.yahoo.com> Received: from [220.225.70.2] by web33304.mail.mud.yahoo.com via HTTP; Mon, 16 Oct 2006 00:07:53 PDT Date: Mon, 16 Oct 2006 00:07:53 -0700 (PDT) From: Sandeep Khandelwal Subject: Bulk Load and Extract from PostgreSQL To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.646 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FROM_HAS_ULINE_NUMS X-Spam-Level: *** X-Archive-Number: 200610/9 X-Sequence-Number: 6292 Hi All.=0A=0AI 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).=0AI w= ant to handle all the data types supported in the PostgreSQL.=0A=0AThanks,= =0ASandeep=0A=0A