Re: pg_dump -t option doesn't take schema-qualified table names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Curt Sampson <cjs(at)cynic(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump -t option doesn't take schema-qualified table names
Date: 2003-07-01 13:44:17
Message-ID: 2528.1057067057@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Curt Sampson <cjs(at)cynic(dot)net> writes:
> It appears that the command "pgsql -t foo.bar" will not dump the table
> bar in the schema foo. I saw a patch a while back to add schema support
> to pg_dump (with the --namespace option), but I did not see a fix for
> this.

IMO that's not a bug; you should spell it pg_dump -n foo -t bar.
The other way is ambiguous with a table named "foo.bar".

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ian Barwick 2003-07-01 22:27:16 Re: Problem with "z_" in Unicode-DB
Previous Message Wehrle, Daniel 2003-07-01 09:01:32 Problem with "z_" in Unicode-DB