Re: using COPY table FROM STDIN within script run as psql

Kevin Murphy <murphy@genome.chop.edu> writes:
> I can reproduce the problem with this command:

> psql -U egenome_test -P pager=off -f
> /Users/murphy/cvs/egora/sql/data_build/junk.sql < ./junk.dat

> with junk.sql and junk.dat as follows:

> COPY import_sts_tmp FROM STDIN WITH NULL AS '';

This command says to copy from the SQL script file.  You can use
psql's \copy command to get the effect you are after.

            regards, tom lane