Re: [GENERAL] export a schema / import as new schema

2009-08-30 Thread Jasen Betts
On 2009-08-21, David Kerr wrote: > On Fri, Aug 21, 2009 at 12:00:11PM -0700, Joshua D. Drake wrote: > - On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote: > - > Is there an easy way, that I'm missing, where I can export a schema from > - > database A and then rename it on load into database B?

Re: [GENERAL] export a schema / import as new schema

2009-08-21 Thread David Kerr
Thanks. Yeah, if it's not free i'll just write my own if it becomes too much of a pain =) Dave Boyd, Craig wrote: Look here: http://sqlmanager.net/en/products/postgresql They aren't cheap, but they seem to work well. Thanks, Craig Boyd David Kerr wrote: On Fri, Aug 21, 2009 at 12:00:11PM

Re: [GENERAL] export a schema / import as new schema

2009-08-21 Thread Boyd, Craig
Look here: http://sqlmanager.net/en/products/postgresql They aren't cheap, but they seem to work well. Thanks, Craig Boyd David Kerr wrote: On Fri, Aug 21, 2009 at 12:00:11PM -0700, Joshua D. Drake wrote: - On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote: - > Is there an easy way, that I'm

Re: [GENERAL] export a schema / import as new schema

2009-08-21 Thread David Kerr
On Fri, Aug 21, 2009 at 12:00:11PM -0700, Joshua D. Drake wrote: - On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote: - > Is there an easy way, that I'm missing, where I can export a schema from - > database A and then rename it on load into database B? - - pg_dump -s foo|psql bar Sorry, I was

Re: [GENERAL] export a schema / import as new schema

2009-08-21 Thread Joshua D. Drake
On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote: > Is there an easy way, that I'm missing, where I can export a schema from > database A and then rename it on load into database B? pg_dump -s foo|psql bar > > I use similar functionality in oracle all the time and it's great for > developme

[GENERAL] export a schema / import as new schema

2009-08-21 Thread David Kerr
Is there an easy way, that I'm missing, where I can export a schema from database A and then rename it on load into database B? I use similar functionality in oracle all the time and it's great for development environments when you're making schema changes or updating a lot of data. You can me