Re: copy command... - Mailing list pgsql-novice

From Tom Lane
Subject Re: copy command...
Date
Msg-id 27789.1004124483@sss.pgh.pa.us
Whole thread Raw
In response to copy command...  ("Peter Tan" <kaihua@cs.stanford.edu>)
List pgsql-novice
"Peter Tan" <kaihua@cs.stanford.edu> writes:
> When using the copy command to bulk load data, could I specify the string of
> "end of record", insted of using newline? If the answer is no, is there any
> alternative way?

Make a sed or awk script that changes newlines to backslash-newline,
except for the ones you want to treat as end of record.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Peter Tan"
Date:
Subject: copy command...
Next
From: "Josh Berkus"
Date:
Subject: Re: Too much postmaster prozesses / CPU near 100%