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
willbe 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