Re: BUG #5765: pg_dump fail to find upper case table name

On 24.11.2010 13:34, Cristiano wrote:
> pg_dump --host www --port 5432 --username postgres --format plain
> --column-inserts --verbose --file "streetTypes.sql" --table
> public."streetTypes" "geocoding-dev"
> Password:
> pg_dump: No matching tables were found
> pg_dump: *** aborted because of error
>
> Test case: just create an table that need quoting.
> CREATE TABLE "Test"() WITH ( OIDS=FALSE );
>
> Call pg_dump to export.
>
> pg_dump --host localhost --port 5432 --username postgres --format plain
> --column-inserts --verbose --file "test.sql" --table public."Test" "test-db"

Manual says (at the bottom of
http://www.postgresql.org/docs/8.4/static/app-pgdump.html)

> To specify an upper-case or mixed-case name in -t and related switches, you need to double-quote the name; else it will be folded to lower case (see Patterns). But double quotes are special to the shell, so in turn they must be quoted. Thus, to dump a single table with a mixed-case name, you need something like
>
> $ pg_dump -t '"MixedCaseName"' mydb > mytab.sql

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com