Re: COPY FROM file with zero-delimited fields

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "eugene(dot)mindrov(at)gmail(dot)com" <eugene(dot)mindrov(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY FROM file with zero-delimited fields
Date: 2007-04-11 15:42:11
Message-ID: b42b73150704110842o78a5c184r2eb6f3f932168382@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11 Apr 2007 00:25:50 -0700, eugene(dot)mindrov(at)gmail(dot)com
<eugene(dot)mindrov(at)gmail(dot)com> wrote:
> Hi all,
> I wonder if there's a way to use COPY FROM command when dealing with a
> data file containing records whose fields are delimited with zero-
> byte? Or I'd better change the delimiter? :)

you can always run it through tr or similar tools first.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Koterov 2007-04-11 16:08:53 What about SkyTools?
Previous Message Andrew Thompson 2007-04-11 15:01:49 Re: Acces via applets