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@sss.pgh.pa.us]
Gesendet: Dienstag, 1. Juli 2003 15:44
An: Curt Sampson
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] pg_dump -t option doesn't take schema-qualified
table names
Curt Sampson <cjs@cynic.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