pg_dump error when dumping mixed-case name tables
Hello!
I dump only one table which has mixed case name. But it doesn't work.
It results in the following error:
pg_dump.exe -h localhost -p 5433 -U postgres -i -F p -t '"T10441"' -v -f "test.sql" test
pg_dump: No matching tables were found
pg_dump: *** aborted because of error
Is that a bug or am I doing anything wrong?
Thank you in advance.
Best Regards,
Vladimir Prischepa.
"Prischepa Vladimir" <vlpri@ems.ru> writes:
I dump only one table which has mixed case name. But it doesn't work.
It results in the following error:
pg_dump.exe -h localhost -p 5433 -U postgres -i -F p -t '"T10441"' -v -f "test.sql" test
pg_dump: No matching tables were found
Which PG version are you using?
The '"FOO"' bit works in pg_dump 8.2 and later. In older versions, try
just FOO.
regards, tom lane