Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E6134633FF1 for ; Tue, 11 Aug 2009 01:22:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46772-06 for ; Tue, 11 Aug 2009 04:22:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f217.google.com (mail-gx0-f217.google.com [209.85.217.217]) by mail.postgresql.org (Postfix) with ESMTP id DAF0A633FC7 for ; Tue, 11 Aug 2009 01:22:10 -0300 (ADT) Received: by gxk17 with SMTP id 17so4209931gxk.19 for ; Mon, 10 Aug 2009 21:22:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=824ZZu8azEQCPCKU+yohl/kllBg9CFa3EGtBUCAF7VE=; b=pCBOxyxYrYJzrlV6NLX0v0uz/lOrn/6Vh4AtcaClbZGyvLtQ0fMhDyKBEoWGlBI/B2 5wy+/+9YIhJA1Qt+BPhLDM+2iB3M5iZPVkDVJDZqf+3eknyu/tZi73eW+gWNa74f6FD8 yehiOdAnopWCx53zwjHu9UcqSyaznmiuoYLwI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=dR/WK1SiJMRklEbZuaWch+mAAxg7qN1MWB8gJ9fIkrg1fXZV1yIQIBtUjQtHPDB2a9 C5zP5UD2x3mE0Emh5vsJdmEBAFHDDUSNEWIQQX+P9xEP9KdAKZCP7Eqz6D/PI/IOcMsE dEwyjMZyHUcx/QlMwbhc6oxRyxigtcgibBH6c= MIME-Version: 1.0 Received: by 10.90.90.6 with SMTP id n6mr4736023agb.60.1249964530272; Mon, 10 Aug 2009 21:22:10 -0700 (PDT) In-Reply-To: <-1997739725851209684@unknownmsgid> References: <-1997739725851209684@unknownmsgid> Date: Tue, 11 Aug 2009 14:22:10 +1000 Message-ID: Subject: Re: Import (.CVS File) to postgreSql From: Shoaib Mir To: Premila Devi Cc: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=0016364ed0d0cf0a640470d60b41 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200908/37 X-Sequence-Number: 32946 --0016364ed0d0cf0a640470d60b41 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi < premiladevi.dayalan@agbnielsen.com> wrote: > Dear All, > > > > I like to import (.CVS File) to postgreSql.Could anyone help me. May I > know, what the requirement. > > > COPY command should be your friend in that case --> http://www.postgresql.org/docs/8.3/static/sql-copy.html -- Shoaib Mir http://shoaibmir.wordpress.com/ --0016364ed0d0cf0a640470d60b41 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi <premiladevi.dayalan@agbniels= en.com> wrote:

Dear All,

=A0

I like to import (.CVS File) to postgreSql.Could anyone help me. May I know, what the requirement.

=A0

<= div>
COPY command should be your friend in that case --> http://www.postgres= ql.org/docs/8.3/static/sql-copy.html
=A0
--
Shoaib Mir
http://shoaibmir.wordpress.com/
--0016364ed0d0cf0a640470d60b41--