Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D908A633177 for ; Tue, 11 Aug 2009 01:58:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 05974-02 for ; Tue, 11 Aug 2009 04:58:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f199.google.com (mail-yw0-f199.google.com [209.85.211.199]) by mail.postgresql.org (Postfix) with ESMTP id EB41B6330CA for ; Tue, 11 Aug 2009 01:58:33 -0300 (ADT) Received: by ywh37 with SMTP id 37so5364394ywh.28 for ; Mon, 10 Aug 2009 21:58:33 -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=7jdJ7Td0l5wvCguUAQOSk451yFcF63yD4K5oTh5hLtI=; b=EPcWBlbE+Rrym6ykk1PBVqjOJqm4qc11dx6FMryBOnAp6z4Ac5gsvi6VdmmOCr0fn0 v3vvVgMY2G7p7fdjp1ek3fL3SmcxtbDqsK3ulbKZSXqrB1Ant+9X91oEvUzDfoAAmsOT vnkF733GKRby9DlrWP6hm400t1wZdvzn8+Mfk= 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=Mx6D0X1IOMJ16jLz6oURv7ORygLU2UtoL+U6WwO7+KqgnMhiDX3/BtAGQ8D5TBUpqp fQ4OH4v71YljiJkBh01vz/7kwNXyxE9ebVdJeGyX5893ICJ47dWkyNQr+PMEsb6XG6eA BVhAjBjHvOFRUzHZdfwo3fTB7/D9/tujmMR/U= MIME-Version: 1.0 Received: by 10.90.87.19 with SMTP id k19mr4706575agb.55.1249966713251; Mon, 10 Aug 2009 21:58:33 -0700 (PDT) In-Reply-To: <2852095227642493290@unknownmsgid> References: <-1997739725851209684@unknownmsgid> <2852095227642493290@unknownmsgid> Date: Tue, 11 Aug 2009 14:58:33 +1000 Message-ID: Subject: Re: Import (.CVS File) to postgreSql From: Shoaib Mir To: Premila Devi Cc: sql pgsql Content-Type: multipart/alternative; boundary=0016361e7f80ecaccc0470d68dd7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.308 tagged_above=-10 required=5 tests=AWL=-0.315, BAYES_00=-2.599, DEAR_SOMETHING=1.605, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200908/38 X-Sequence-Number: 32947 --0016361e7f80ecaccc0470d68dd7 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi < premiladevi.dayalan@agbnielsen.com> wrote: > Dear Sir, > > > > I am really don=92t understand Sir. May I have a screenshot on how to mak= e > these configuration sir. > > > > The File is in CVS, as I attached before sir. > > > As I told you before just use the COPY command. You don't need to do any configurations and all.. just use the CSV option with COPY as explained in the manual. Its just like any other SQL statement once you have the databas= e server installed. Please do not post privately to my email as its always better posting it to the list. --=20 Shoaib Mir http://shoaibmir.wordpress.com/ --0016361e7f80ecaccc0470d68dd7 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi <premiladevi.dayalan@agbniels= en.com> wrote:

Dear Sir,

=A0

I am really do= n=92t understand Sir. May I have a screenshot on how to make these configuration sir.

=A0

The File is in= CVS, as I attached before sir.



As I told you before just use the COPY = command. You don't need to do any configurations and all.. just use the= CSV option with COPY as explained in the manual. Its just like any other S= QL statement once you have the database server installed.


Please do not post privately to my email as its always better posti= ng it to the list.

--
Shoaib Mir
http://shoaibmir.wordpress.com/
--0016361e7f80ecaccc0470d68dd7--