Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F02F19F95CE for ; Tue, 28 Aug 2007 12:38:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 15924-06 for ; Tue, 28 Aug 2007 12:38:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 545779F95CC for ; Tue, 28 Aug 2007 12:38:35 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so1428815nfh for ; Tue, 28 Aug 2007 08:38:34 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=XKtc+twyJykKln/FAZt4nk8sPdftl5tqzwhOYjHhiKUls20ISJsGsmicYlBdHJhzsNNp1Z1Qp0H+qk7M3r/NFQ0oE/yhygeQSpXt4TeblKUTjx3IFnZhYvHjekJuuwJSTEfvhgdhaKOvBALxvYVLBVgXRz77cxgENavZPdm6dvY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=kkC6PTfVJT4eonIxdiODzbKFb55Wm5jUtF3dv/l5CjmSPNQY3IjNbAyBMO2Gb2ajQMpLzfdgCT/Sr++CQI/JiDWivUsHCGcdmlHX+FObn6xrrjPyA05GbsFcLfyzF1/9FzR92pOhtQ/Hd+9IphuqEqPtzINApOjX37m1MRD6aoE= Received: by 10.78.205.7 with SMTP id c7mr4980163hug.1188315512787; Tue, 28 Aug 2007 08:38:32 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Tue, 28 Aug 2007 08:38:32 -0700 (PDT) Message-ID: <1d219a6f0708280838q1312632fg7cbd971cec7cf5ee@mail.gmail.com> Date: Tue, 28 Aug 2007 11:38:32 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: How to import CSV file? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_83981_31812663.1188315512764" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/349 X-Sequence-Number: 26680 ------=_Part_83981_31812663.1188315512764 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I need some help importing a csv file. I have been given a csv file full of data that is delimited by a comma, and the strings are delimited by a single quote. How do you write the copy statement to use a single quote delimiter? I have tried several things, but so far, no joy. Thanks for any help, Chris ------=_Part_83981_31812663.1188315512764 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I need some help importing a csv file.  I have been given a csv file full of data that is delimited by a comma, and the strings are delimited by a single quote.  How do you write the copy statement to use a single quote delimiter?  I have tried several things, but so far, no joy.

Thanks for any help,

Chris
------=_Part_83981_31812663.1188315512764--