Re: export a schema / import as new schema

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 -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 wasn't clear.
>>
>> What I have is:
>>
>> [Database 1].[Schema 1]->[Data Set 1]
>> [Database 2].[Schema 1]->[Data Set 2]
>>
>> What I want to do is:
>>
>> Export [Database 1].[Schema 1]->[Data Set 1]
>> Import [Database 2].[Schema 2]->[Data Set 1]
>>
>> Leaving me with
>> [Database 2].[Schema 1]-[Data Set 2]
>>          [Schema 2]-[Data Set 1]
>>
>> So that i can now compare Data Set 1 and Data Set 2
>>
>> Currently, I'm creating the new schema in database 1 and then
>> exporting that data
>> into database 2, but i was hoping there was a better way.
>>
>> Thanks
>>
>> Dave
>>
>>
>