Re: pg_dump --table=* dumps nothing?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dwalter(at)syr(dot)edu
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump --table=* dumps nothing?
Date: 2003-10-02 15:33:42
Message-ID: 27591.1065108822@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

David Walter <dwalter(at)syr(dot)edu> writes:
> Using pg_dump version 7.3.4 with the following options
> no table data is dumped.

> pg_dump -i --table=* --schema-only db

Current sources interpret this as asking to dump a table named "*".
There was never any support for wildcards in the table parameter,
except for a mistaken comment in pg_dump --help.

I would not mind seeing support for actual pattern matching
(eg "--table=foo*" to select all tables beginning with "foo"),
but I don't see much value in supporting just table=*. You can
get that result by leaving off the --table switch.

regards, tom lane

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Darko Prenosil 2003-10-03 14:10:08 /src/interfaces/libpq/po/hr.po
Previous Message Peter Eisentraut 2003-10-02 14:58:48 Re: pg_dump --table=* dumps nothing?