Postgres Pro
Downloads
Home   >   mailing lists

Re: Using COPY - Mailing list pgsql-general

From Peter Darley
Subject Re: Using COPY
Date
Msg-id NNEAICKPNOGDBHNCEDCPIEKACIAA.pdarley@kinesis-cem.com
Whole thread Raw
In response to Re: Using COPY  ("Joel Burton" <joel@joelburton.com>)
Responses Re: Using COPY
List pgsql-general
Tree view 
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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Joel Burton
Sent: Tuesday, May 14, 2002 9:25 AM
To: Tom Lane; joe@jwebmedia.com
Cc: pgsql-general@postgresql.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.

pgsql-general by date:

Previous
From: Michael Adler
Date:
Subject: tool for comparing databases (?)
Next
From: Andrew Sullivan
Date:
Subject: Re: [JDBC] select * from mytable where myfield=null;