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

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