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;
\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.
pgsql-hackers-win32 by date
|Next:||From: Wolfgang Teschner||Date: 2004-08-16 08:53:25|
|Subject: Re: [Pginstaller-devel] Re: Win32 PostgreSQ|
|Previous:||From: rodrigo.miguel||Date: 2004-08-16 00:37:38|
|Subject: Re: REPOST: InitDB Failure on install|