The following bug has been logged online:
Bug reference: 5765
Logged by: Cristiano
Email address: sumariva@gmail.com
PostgreSQL version: 8.4.4
Operating system: Linux
Description: pg_dump fail to find upper case table name
Details:
The following command line did not worked.
Using a table with lower case chars( no quoting ) works.
Also happen on pg_dump windows version.
Tested on 8.4.4 and 8.4.3
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"