Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 848D59FC10B for ; Fri, 25 May 2007 05:10:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76265-02-2 for ; Fri, 25 May 2007 05:10:13 -0300 (ADT) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id DE26C9FC107 for ; Fri, 25 May 2007 05:10:15 -0300 (ADT) Received: from localhost (unknown [200.46.204.183]) by hub.org (Postfix) with ESMTP id 036E0118AC42 for ; Fri, 25 May 2007 05:10:10 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40745-02; Fri, 25 May 2007 05:10:03 -0300 (ADT) Received: from ganymede.hub.org (blk-89-241-126.eastlink.ca [24.89.241.126]) by hub.org (Postfix) with ESMTP id A0D0A118AC3F; Fri, 25 May 2007 05:09:57 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 6880D3C3D2; Fri, 25 May 2007 05:10:00 -0300 (ADT) Date: Fri, 25 May 2007 05:09:59 -0300 From: "Marc G. Fournier" To: "Khan, Mahmood Ahram" , pgsql-admin@postgresql.org cc: tgl@sss.pgh.pa.us, aroravishal22@hotmail.com, ashish.karalkar@info-spectrum.com Subject: Re: Loader Message-ID: In-Reply-To: References: X-Mailer: Mulberry/4.0.8 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/280 X-Sequence-Number: 25600 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sounds like you want to look at the COPY command ... - --On Friday, May 25, 2007 12:14:17 +0530 "Khan, Mahmood Ahram" wrote: > > > > > Is there any Loader in Postgres like SQL Loader? Through which I can load > data from flat files like (CSV, TXT) directly to Postgres Tables. > > > > Thanks & Regards > > > > M.AHRAM KHAN > > > > > > > > - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQFGVpnY4QvfyHIvDvMRAn4JAKCxqkPwcu14To6C9PpUZsmV8u8OnACglYoO o5RxLYeu6gsCHFOIfnBJViM= =caS4 -----END PGP SIGNATURE-----