Re: Numeric and CSV under 8.0.1 ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Stef <stef(at)ummon(dot)com>
Cc: Keith Worthington <keithw(at)narrowpathinc(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Numeric and CSV under 8.0.1 ?
Date: 2005-04-08 18:39:39
Message-ID: 20050408183939.GA16288@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Apr 08, 2005 at 02:25:13PM -0400, Stef wrote:
>
> well, I can understand that 3265 appears to be a
> string, but, I was under the impression that -everything-
> in a CSV format file could have ' ' around it? Is this not
> the case ?

See the documentation for COPY -- the default quote character for
CSV is a double quote, but you can change it with QUOTE.

http://www.postgresql.org/docs/8.0/interactive/sql-copy.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-08 18:47:36 Re: Question on triggers and plpgsql
Previous Message Stef 2005-04-08 18:25:13 Re: Numeric and CSV under 8.0.1 ?