Skip site navigation (1) Skip section navigation (2)

Re: copy from multi-line text problem

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: Igor Velkov <iav(at)saules(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: copy from multi-line text problem
Date: 2001-04-08 17:37:46
Message-ID: 3AD0A1EA.FB4F70B3@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
Igor Velkov wrote:
> 
> Can I use copy from command for bulk insertion to table with multi-line
> text fields?
> In past< with MySQL i do it with configure "," serarated fields, quotes
> and "|" separated lines.
> With Postgres it can't parse more-that-1-line text field.
> 
> Can I import tis file somehow?

I have a perl script which I use to parse comma-separated files like
this.  It is 'sort-of' generic, but you would need to customise it a
little for your situation.

E-mail me if you would like a copy.

Cheers,
					Andrew.
-- 
_____________________________________________________________________
           Andrew McMillan, e-mail: Andrew(at)catalyst(dot)net(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

In response to

Responses

pgsql-novice by date

Next:From: Joel BurtonDate: 2001-04-08 18:44:53
Subject: Re: table version history
Previous:From: Tom StricklandDate: 2001-04-08 16:09:40
Subject: table version history

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group