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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
