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
@postgresql.org
Subject: [SQL]
Importing data from
csv
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
.
Cheers,
-p
-Original
Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sumeet
Sent: Friday, 25
August 2006 00:48
To:
pgsql-sql@postgresql.org
Subject: [SQL]
Importing data from
csv
Hi
Folks,
sorry if this is a duplicate post, i've been try
00:48
To: pgsql-sql@postgresql.org
Subject: [SQL] Importing data from
csv
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 chara
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 export these files to a csv format, there are some
