Re: Using COPY

From: "Peter Darley" <pdarley(at)kinesis-cem(dot)com>
To: "Joel Burton" <joel(at)joelburton(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using COPY
Date: 2002-05-14 19:45:54
Message-ID: NNEAICKPNOGDBHNCEDCPIEKACIAA.pdarley@kinesis-cem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joel,
Just out of curiosity, how would that query to update the marker be
written? It's very similar to something I'd like to do, but have been
unable to work out.
Thanks,
Peter Darley

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Joel Burton
Sent: Tuesday, May 14, 2002 9:25 AM
To: Tom Lane; joe(at)jwebmedia(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Using COPY

Or, if that's tricky for you to do w/the conversion/output tools you have at
your disposal, turn the linebreaks into some unusual marker ("@@~@@") using
any tool (emacs, perl, even Microsoft Word will do), pull the data in using
COPY, and once in pgsql, you can fix this with a query.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-14 19:57:47 Re: [JDBC] select * from mytable where myfield=null;
Previous Message Michael Adler 2002-05-14 19:09:00 tool for comparing databases (?)