Re: Patch for pg_dump: Multiple -t options and new -T option - Mailing list pgsql-patches

From Tom Lane
Subject Re: Patch for pg_dump: Multiple -t options and new -T option
Date
Msg-id 7462.1090325928@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch for pg_dump: Multiple -t options and new -T option  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Patch for pg_dump: Multiple -t options and new -T
List pgsql-patches
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> One problem with this patch is that there's no way to dump multiple
> tables in different schemas.  Does this matter?  It's a bit
> non-orthogonal...

Yeah.  With the combination of -n and -t you can pull a specific table,
but as soon as you allow either switch to be multiple you've got an
inexact tool.

I had thought of allowing -t to be schema.table but I'm worried about
backwards-compatibility issues.  In particular, since we don't support
SQL-style quoting in -t arguments, how could one then select a table
name that actually contains a dot?  Or should we just write off that
case as "stupidity is its own reward"?  It would also be good to not
foreclose the possibility of wild-card matching patterns in these
switches in future.

(BTW, does the patch handle multiple -n switches?)

            regards, tom lane

pgsql-patches by date:

Previous
From: Jason Tishler
Date:
Subject: FAQ_MSWIN patch
Next
From: "David F. Skoll"
Date:
Subject: Re: Patch for pg_dump: Multiple -t options and new -T