Hi Arni, Seems like a bug, kindly raise a bug here - https://redmine.postgresql.org/projects/pgadmin4/issues/new
On Fri, Aug 9, 2019 at 3:26 PM Arni Kromić <[email protected]> wrote: > We've found a problem backing up some of our schemas from pgAdmin4. After > some investigation, we've found the problem being the schema names need > ident quoting - apparently because they contain capital letters. > > For example, pgAdmin generated this code which fails: > > $ /usr/bin/pg_dump --file "testera" --host "/var/run/postgresql" --port > "5432" --username "postgres" --no-password --verbose --format=c --blobs > --schema "HR00000000001-2019" "nubes" > pg_dump: last built-in OID is 16383 > pg_dump: no matching schemas were found > > However, if I quote the schema name by adding a pair of single quotes... > > $ /usr/bin/pg_dump --file "testera" --host "/var/run/postgresql" --port > "5432" --username "postgres" --no-password --verbose --format=c --blobs > --schema '"HR00000000001-2019"' "nubes" > pg_dump: last built-in OID is 16383 > pg_dump: reading extensions > pg_dump: identifying extension members > pg_dump: reading schemas > pg_dump: reading user-defined tables > pg_dump: reading user-defined functions > pg_dump: reading user-defined types > ... > > ...it works fine. So it seems schema names should be automatically quoted > (similar to quote_ident()) for backup to work properly. I guess this is a > bug in pgAdmin4 (version I have is 4.11). > > -- > Srdačan pozdrav / Kind regards > ----------------------------------------------- > Arni Kromić > [ IT system engineer ] > [email protected] > Tel: +385 21 490 599 > Mob: +385 95 659 5 659 > ---------------------------------------------- > > Mažuranićevo šet. 14 > 21000 Split, Croatia > Tel: +385 21 344 349 > Fax: +358 21 490 599 > http://podrska.bios-ict.hr > http://www.bios-ict.hr > ---------------------------------------------- > > -- Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
