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.
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
pgsql-novice by date
|Next:||From: Joel Burton||Date: 2001-04-08 18:44:53|
|Subject: Re: table version history|
|Previous:||From: Tom Strickland||Date: 2001-04-08 16:09:40|
|Subject: table version history|