Re: psql reading from stdin

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Eric Rosenquist <rosenquist(at)mail(dot)utexas(dot)edu>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: psql reading from stdin
Date: 2004-08-16 14:59:35
Message-ID: 4120CBD7.10307@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2004-08-16 16:34:03 Re: [pgsql-www] Win32 PostgreSQL 8.0 Beta 1 Installer available
Previous Message Rodrigo Moreno 2004-08-16 12:19:04 RES: REPOST: InitDB Failure on install