Re: pg_dump -> \i infile

Erik Price <eprice(at)ptc(dot)com> writes:
> I am doing some unit testing of my application code, which requires me
> to often reset my Postgres 7.3.2 (Cygwin) development database to
> certain known data. The problem that I am running into seems to be
> this: if I try to load a database (schema and data) using the
> "\i filename" command in psql, it fails. However, it works fine when I
> try to load the exact same file from outside of the psql client (i.e.,
> my bash shell in Cygwin) using the "psql -d databasename -f filename"
> command.

I do that all the time, and it works fine for me. I suspect some
Cygwin-specific problem (or, perhaps, pilot error?). What failure are
you seeing, exactly?

regards, tom lane