Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group