I Think that your problem is: test.mytable() <> test.mytable, why your
table name include --> ()
On Fri, 2007-06-08 at 16:59 +0000, Kevin Neufeld wrote:
> The following bug has been logged online:
>
> Bug reference: 3377
> Logged by: Kevin Neufeld
> Email address: kneufeld@refractions.net
> PostgreSQL version: 8.2.4
> Operating system: Linux Fedora Core 3
> Description: pg_dump: No matching tables were found
> Details:
>
> pg_dump does not seem to use -n to qualify a table dump.
>
> $ psql -U postgres -c "create schema test" postgres
> CREATE SCHEMA
>
> $ psql -U postgres -c "create table test.mytable()" postgres
> CREATE TABLE
>
> $ pg_dump -U postgres -t mytable postgres | less
> pg_dump: No matching tables were found
>
> $ pg_dump -U postgres -n test -t mytable postgres | less
> pg_dump: No matching tables were found
>
> $ psql -U postgres -c "alter user postgres set search_path to test, public"
> postgres
> ALTER ROLE
>
> $ pg_dump -U postgres -n test -t mytable postgres | less
> --
> -- PostgreSQL database dump
> --
>
> SET client_encoding = 'UTF8';
> SET ...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.