| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why don't dumped files parse in pgAdmin3 query editor? |
| Date: | 2007-03-05 15:35:48 |
| Message-ID: | 45EC38D4.2040204@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 05/03/2007 15:28, dlivesay(at)covad(dot)net wrote:
> Here's something I've always wondered. When you dump a database, the dumped file
> looks like ordinary SQL, but if I load it into a query editor window and try to
> execute it, I always get syntax errors. The specific errors vary, but it always
> makes it impossible to reload the data that way.
That's because theses files contain psql-specific "backslash" commands
as well as ordinary SQL - if you look at what the errors tell you,
you'll probably see that they come from lines containing such commands.
As I understand it, the plain-text output of pg_dump is intended to be
restored via psql.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2007-03-05 15:36:47 | Re: Why don't dumped files parse in pgAdmin3 query editor? |
| Previous Message | Marek | 2007-03-05 15:30:48 | privileges of views and sequences |