psql reading from stdin

From: "Eric Rosenquist" <rosenquist(at)mail(dot)utexas(dot)edu>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: psql reading from stdin
Date: 2004-08-16 08:46:24
Message-ID: 003101c4836d$839b1830$0800a8c0@crown
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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.

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Wolfgang Teschner 2004-08-16 08:53:25 Re: [Pginstaller-devel] Re: Win32 PostgreSQ
Previous Message rodrigo.miguel 2004-08-16 00:37:38 Re: REPOST: InitDB Failure on install