On 8/24/06, Sumeet <[EMAIL PROTECTED]> wrote:
Hi Folks,sorry if this is a duplicate post, i've been tryin to find a solution of importing data into postgres from a csv file. The problem is, I have a database which consists of columns which contain newline characters (mac and unix). now when i expor
On Thu, Aug 24, 2006 at 08:19:58PM -0400, Scot P. Floess wrote:
> Well, being that there isn't a RFC for CSV...other than "defacto"
> definitions...I am pretty sure that is widely agreed upon ;)
RFC 4180
Common Format and MIME Type for Comma-Separated Values (CSV) Files
ftp://ftp.rfc-editor.org/i
better
light! J
Cheers,
-p
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Scot P. Floess
Sent: Friday, 25
August 2006 10:00
To:
[EMAIL PROTECTED]
Cc: Phillip Smith;
pgsql-sql@postgresql.org
Subject: Re: [SQL]
Importing data
from csv
: [EMAIL PROTECTED]
Cc: Phillip Smith;
pgsql-sql@postgresql.org
Subject: Re: [SQL] Importing data
from csv
And if its contained with
quotes...its considered a field
Scot P. Floess wrote:
A newline in CSV parlance
denotes the end of a recordunless that newline is contained with quotes...
Phillip
And if its contained with quotes...its considered a field
Scot P. Floess wrote:
A newline in CSV parlance denotes the end of a recordunless that
newline is contained with quotes...
Phillip Smith wrote:
I recently
did this by parsing the data
through a VB p
A newline in CSV parlance denotes the end of a recordunless that
newline is contained with quotes...
Phillip Smith wrote:
I recently
did this by parsing the data
through a VB program that appended a “\” in front of any Char(10)
and/or Char(13) characters which tells Postgres
I recently did this by parsing the data
through a VB program that appended a “\” in front of any Char(10)
and/or Char(13) characters which tells Postgres to accept the next character as
a literal part of the column value I believe – must do because it worked!
I also quoted the whole column
