Thread: 7.3 Beta Schema and pg_dump
I have been playing with schema's under 7.3beta and now I am trying to use pg_dump. Is there a way to just dump 1 of my schema out? Should pg_dump -t "A.*" ... dump out just schema A's objects? Thanks Jim
"Jim Buttafuoco" <jim@contactbda.com> writes:
> I have been playing with schema's under 7.3beta and now I am trying to
> use pg_dump. Is there a way to just dump 1 of my schema out?
Nope; I intended to make that happen, but didn't get around to it.
regards, tom lane
This seems like a "must" have option for pg_dump, looking at the code, it seems that only a couple of queries would need to be changed and a command line option (-N, --namespace=) would need to be added. If I was to create a patch would it make it into 7.3? Thanks Jim > "Jim Buttafuoco" <jim@contactbda.com> writes: > > I have been playing with schema's under 7.3beta and now I am trying to > > use pg_dump. Is there a way to just dump 1 of my schema out? > > Nope; I intended to make that happen, but didn't get around to it. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
"Jim Buttafuoco" <jim@contactbda.com> writes:
> This seems like a "must" have option for pg_dump,
> If I was to create a patch would it make it into 7.3?
I dunno ... I'd like to have it too, but it would break our "no new
features during beta" rule. Comments anyone?
regards, tom lane
On Mon, 16 Sep 2002, Tom Lane wrote: > "Jim Buttafuoco" <jim@contactbda.com> writes: > > This seems like a "must" have option for pg_dump, > > If I was to create a patch would it make it into 7.3? > > I dunno ... I'd like to have it too, but it would break our "no new > features during beta" rule. Comments anyone? > I'd love to have this feature. What's about contrib/ ? > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Tom Lane writes: > "Jim Buttafuoco" <jim@contactbda.com> writes: > > This seems like a "must" have option for pg_dump, > > If I was to create a patch would it make it into 7.3? > > I dunno ... I'd like to have it too, but it would break our "no new > features during beta" rule. Comments anyone? I do not believe Jim's premise that it would only take a couple of changes to a couple of queries. Clearly, it would take at least some change to any query that reads information about schema-aware objects. And it needs to be made backward compatible. And what about cross-schema dependencies? -- Peter Eisentraut peter_e@gmx.net
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> "Jim Buttafuoco" <jim@contactbda.com> writes:
> This seems like a "must" have option for pg_dump,
> If I was to create a patch would it make it into 7.3?
>>
>> I dunno ... I'd like to have it too, but it would break our "no new
>> features during beta" rule. Comments anyone?
> I do not believe Jim's premise that it would only take a couple of changes
> to a couple of queries. Clearly, it would take at least some change to
> any query that reads information about schema-aware objects.
Actually, my vision of this was not to change any queries at all, but
just to modify the pg_dump code to include a "select this schema" option.
The infrastructure is already there in pg_dump to mark individual schemas
as to be dumped or not --- we only need a command-line option that can
mark them.
> And what about cross-schema dependencies?
Given the lack of any dependency tracing in pg_dump at the moment, I
think we just leave that on the user's head for now. It's not any worse
than the behavior of -t, which is perfectly capable of giving you an
incomplete dump.
regards, tom lane
> "Jim Buttafuoco" <jim@contactbda.com> writes: > > This seems like a "must" have option for pg_dump, > > If I was to create a patch would it make it into 7.3? > > I dunno ... I'd like to have it too, but it would break our "no new > features during beta" rule. Comments anyone? I don't see a huge reason to stick to that rule in this instance... Chris
Christopher Kings-Lynne wrote: > > "Jim Buttafuoco" <jim@contactbda.com> writes: > > > This seems like a "must" have option for pg_dump, > > > If I was to create a patch would it make it into 7.3? > > > > I dunno ... I'd like to have it too, but it would break our "no new > > features during beta" rule. Comments anyone? > > I don't see a huge reason to stick to that rule in this instance... Reclassify it as a bug ... problem solved. ;-) Actually, it is sort of a bug because it is something we should have added for schemas but forgot. -- 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, Pennsylvania19073