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]