Re: pg_dump "all tables" in 7.3.X - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump "all tables" in 7.3.X
Date
Msg-id 1202.1056649588@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump "all tables" in 7.3.X  (Paul Ramsey <pramsey@refractions.net>)
Responses Re: pg_dump "all tables" in 7.3.X  (Paul Ramsey <pramsey@refractions.net>)
List pgsql-general
Paul Ramsey <pramsey@refractions.net> writes:
> We are trying to do an "all tables" dump using the 7.3.3 pg_dump, but
> are getting no love.  The pg_dump command which worked before, in 7.2,
> no longer returns any tables:
>    pg_dump -t "*" dbname
> Is this by design, or by accident?

By design.  Just omit the -t switch if you want all tables.

("*" is a legal table name, if perhaps not a very bright choice, so the
old behavior was really not consistent.)

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: pg_dump "all tables" in 7.3.X
Next
From: Paul Ramsey
Date:
Subject: Re: pg_dump "all tables" in 7.3.X