Thread: COPY FROM STDIN

COPY FROM STDIN

From
"ezra epstein"
Date:
I'm struggling using COPY FROM.

COPY ... FROM STDIN

expects stdin to be whatever file is being processed,

so:
   $  cat data_file.txt | psql -f load_script.sql MyDB

Does not do what one would expect (and hope).

So we try the psql command:

\copy ... FROM 'data_file.txt'

and get:

psql:load_sricpt.sql:34: ERROR:  literal newline found in data
HINT:  Use "\n" to represent newline.

which gives a CONTEXT: of the last line of data --- hmmm, is that psql bug?

So we have to resort to:

\c - a_superuser
COPY ... FROM 'full_non_portable_path_to_our_data_file' ....

Which we would much rather avoid.

So,
   (a) is there a way to indicate a different input stream for COPY STDIN ?
   (b) is \copy broken on NT (cygwin) ?

== Ezra Epstein