Re: pg_dump -> \i infile - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump -> \i infile
Date
Msg-id 23406.1055361330@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump -> \i infile  (Erik Price <eprice@ptc.com>)
Responses Re: pg_dump -> \i infile  (Erik Price <eprice@ptc.com>)
List pgsql-general
Erik Price <eprice@ptc.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

pgsql-general by date:

Previous
From: Kaarel
Date:
Subject: Re: Postgres performance comments from a MySQL user
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: libpsqlodbc.so