Обсуждение: 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,=20
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