Double quoting as suggested solves the problem and all seems to be working as i expected. In particular i wasn't quoting the schema name, rather i quoted the combined <schema>.<table> string.
Arnaud Lesauvage wrote: > simon.abele@gmail.com a écrit : >> I second this bug - i'm experiencing the same problem trying to backup >> (dump) tables with mixed case names ( e.g. MyTableName). I've installed >> pgAdmin v1.6.3 and attempted to backup (compressed and plain, within >> pgadmin, from cmd line) some tables with mixed case names, so far >> without success. I'm able to dump out all lower case named tables >> (e.g. mytablename) but NOT mixed case named tables. > > So the syntax "-t <table> -n <schema>" used by pgAdmin is not correct > anymore.
Are you sure you're running 1.6.3? I get (not the non default schema, and that both the schema and table names need quoting):
C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -v -f "c:\foo.bak" -t "\"FOO\".\"Role\"" postgres pg_dump: reading schemas pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined conversions pg_dump: reading user-defined tables pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: reading type casts pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding the columns and types of table "Role" pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading indexes for table "Role" pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading dependency data pg_dump: saving encoding = LATIN1 pg_dump: saving standard_conforming_strings = off pg_dump: dumping contents of table Role