psql reading from stdin

"Eric Rosenquist" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <003101c4836d$839b1830$0800a8c0@crown>
Hi

I was trying to populate the database in Windows by doing psql -f dumpfile.
It creates the tables just fine and executes the SET commands in the file,
but it ignores all the data given as COPY xxxx (xxx,xxx,xxx) FROM stdin;
commands.

\i dumpfile at the psql prompt also doesn't work.

To work around this, the dump file can be generated with pg_dump -D, meaning
store the data as INSERT commands rather than COPY.  But something is
apparently wrong with the stdin of psql in Windows.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.