By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,835 Members | 2,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,835 IT Pros & Developers. It's quick & easy.

COPY FROM STDIN

P: n/a
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
Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.