Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump.exe - quotation marks in schema names

pg_dump.exe - quotation marks in schema names

From
Date:
Hello
"pg_dump" seems to have an issue with schema names containing quotation marks ("). The values do not get passed to the
toolproperly. 
From Pgadmin:
C:\Program Files\pgAdmin III\1.10\pg_dump.exe --host localhost --port 5432 --username xxx --format plain --schema-only
--verbose--file "C:\schema.sql" --schema "ACCOUNTING" postgres 
pg_dump: No matching schemas were found
pg_dump: *** aborted because of error
Process returned exit code 1.

From the command line:
"C:\Program Files\pgAdmin III\1.10\pg_dump.exe" --host localhost --port 5432 --username ccc --format plain
--schema-only--verbose --file "C:\schema.sql" --schema "\"ACCOUNTING\"" postgres 
Not sure this is a Windows or reqular expression issue but it is annoying for us as all our schemas has double quotes.
Maybe there is a quick remedy...
Cheers
B.

Re: pg_dump.exe - quotation marks in schema names

From
Guillaume Lelarge
Date:
On Mon, 2012-02-27 at 16:22 +0000, sbremal@hotmail.com wrote:
> Hello
>  
> "pg_dump" seems to have an issue with schema names containing quotation marks ("). The values do not get passed to
thetool properly.
 
>  
> From Pgadmin:
>  
> C:\Program Files\pgAdmin III\1.10\pg_dump.exe --host localhost --port 5432 --username xxx --format plain
--schema-only--verbose --file "C:\schema.sql" --schema "ACCOUNTING" postgres
 
> pg_dump: No matching schemas were found
> pg_dump: *** aborted because of error
> Process returned exit code 1.
> 
> From the command line:
>  
> "C:\Program Files\pgAdmin III\1.10\pg_dump.exe" --host localhost --port 5432 --username ccc --format plain
--schema-only--verbose --file "C:\schema.sql" --schema "\"ACCOUNTING\"" postgres
 
>  
> Not sure this is a Windows or reqular expression issue but it is annoying for us as all our schemas has double
quotes.
>  
> Maybe there is a quick remedy...
>  

Update to 1.14 (latest is out today), and check if it works for you (it
does for me, but I'm on Linux and cannot test it on Windows now).


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

Re: pg_dump.exe - quotation marks in schema names

From
Date:
Work like a charm! Thanks.


B.

> Subject: Re: [pgadmin-support] pg_dump.exe - quotation marks in schema names
> From: guillaume@lelarge.info
> To: sbremal@hotmail.com
> CC: pgadmin-support@postgresql.org
> Date: Mon, 27 Feb 2012 22:23:03 +0100
>
> On Mon, 2012-02-27 at 16:22 +0000, sbremal@hotmail.com wrote:
> > Hello
> >
> > "pg_dump" seems to have an issue with schema names containing quotation marks ("). The values do not get passed to
thetool properly. 
> >
> > From Pgadmin:
> >
> > C:\Program Files\pgAdmin III\1.10\pg_dump.exe --host localhost --port 5432 --username xxx --format plain
--schema-only--verbose --file "C:\schema.sql" --schema "ACCOUNTING" postgres 
> > pg_dump: No matching schemas were found
> > pg_dump: *** aborted because of error
> > Process returned exit code 1.
> >
> > From the command line:
> >
> > "C:\Program Files\pgAdmin III\1.10\pg_dump.exe" --host localhost --port 5432 --username ccc --format plain
--schema-only--verbose --file "C:\schema.sql" --schema "\"ACCOUNTING\"" postgres 
> >
> > Not sure this is a Windows or reqular expression issue but it is annoying for us as all our schemas has double
quotes.
> >
> > Maybe there is a quick remedy...
> >
>
> Update to 1.14 (latest is out today), and check if it works for you (it
> does for me, but I'm on Linux and cannot test it on Windows now).
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support