| From: | Erik Price <eprice(at)ptc(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | pg_dump -> \i infile | 
| Date: | 2003-06-11 15:59:54 | 
| Message-ID: | 3EE751FA.9080104@ptc.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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.
Is there a way to get a file dumped from postgres using pg_dump to be
read using the "\i" command?  If not, is there a way to export the
database (schema and data) to a format that can be read from the "\i"
command?
Regards,
Erik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Grant | 2003-06-11 16:10:19 | Re: RE : PostgreSQL coredump : Couldn't find any tables, | 
| Previous Message | Jim C. Nasby | 2003-06-11 15:59:20 | Re: Index not being used in MAX function (7.2.3) |