Postgres Pro
Downloads
Home   >   mailing lists

Re: Export and import from one postgres server to another - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Export and import from one postgres server to another
Date
Msg-id CAF-3MvPnm0Ssdx0a7K+8bsOC5XFK0-jmxRS=FqbZ-WRw++bx2Q@mail.gmail.com
Whole thread Raw
In response to Re: Export and import from one postgres server to another  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
On 29 May 2012 14:58, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> Q: Why can't I reload the SQL script I dumped in the SQL window?
>
> A: The following limitations currently exist in SQL script execution:
>
>        * 'psql' commands such as '\connect' will not work at all.

Wait a minute! They use the pg_dump utility to create the dump file
(there are \connect statements and such in it, after all), but they
don't use psql/pg_restore to restore?

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Grant Allen
Date:
Subject: Re: PG vs MSSQL language comparison ?
Next
From: Merlin Moncure
Date:
Subject: Re: Export and import from one postgres server to another