 | |
Re: [BUGS] pg_dump -t option doesn't take schema-qualified table
mailing.database.pgsql-bugs mailing.database.pgsql-bugs
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: [BUGS] pg_dump -t option doesn't take schema-qualified table -
07-06-2003
, 02:03 PM
|
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". |
an unambiguous way to specify a specific table in a database if you
don't know your search path? Would that be "foo"."bar" (table bar in
schema foo) as opposed to "foo.bar" (table foo.bar in current schema, if
extant)? If so, then pg_dump -t '"foo"."bar"' would do the right thing,
I'd hope.
If there's no way to unambiguously specify a table name, that rather
worries me....
cjs
--
Curt Sampson <cjs (AT) cynic (DOT) net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
#2
| |||
| |||
|
|
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.pa.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.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.