Re: psql reading from stdin

Eric Rosenquist wrote:

>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.
>
>
>  
>

This is probably the problem that we patched a couple of days ago. 
Please see if converting the dump file to have unix line endings (NL 
instead of CRNL) makes any difference. Alternatively, if you can compile 
yourself, try with cvs tip.

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings