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

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

From
"Wehrle, Daniel"
Date:
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

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

From
Bruce Momjian
Date:
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@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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

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