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

Sorry, the -n option will only be available in PostgreSQL 7.4.

---------------------------------------------------------------------------

Wehrle, Daniel wrote:
> Hi Tom,
>
> where can i find the -n option in pg_dump. Is there any special version?
> I have 7.3.3.
>
> Regards,
>
> Daniel
>
> -----Ursprungliche Nachricht-----
> Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Gesendet: Dienstag, 1. Juli 2003 15:44
> An: Curt Sampson
> Cc: pgsql-bugs(at)postgresql(dot)org
> Betreff: Re: [BUGS] pg_dump -t option doesn't take schema-qualified
> table names
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073