Kurt Gunderson <kgunders@cbnlottery.com> writes:
> test1=> \copy "k_device" from "/home/kurt/data/sql.device.d" using
> delimiters '|'
> "/home/kurt/data/sql.device.d": No such file or directory
Almost there. Try it with single quotes or no quotes around the
filename --- double quotes are for SQL identifiers, which the filename
is not. I tried
test72=# \copy "z" to "barf" using delimiters '|'
which worked, but what I got was
-rw-r--r-- 1 tgl users 0 Aug 13 17:08 "barf"
regards, tom lane