From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Cristiano <sumariva(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5765: pg_dump fail to find upper case table name |
Date: | 2010-11-24 13:28:02 |
Message-ID: | 4CED12E2.8030902@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-11-24 13:32:21 | Re: BUG #5765: pg_dump fail to find upper case table name |
Previous Message | Cristiano | 2010-11-24 11:34:08 | BUG #5765: pg_dump fail to find upper case table name |