The following bug has been logged online: Bug reference: 5765 Logged by: Cristiano Email address: sumar...@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" -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
