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
> development environments when you're making schema changes or updating a
> lot of data. You can mess up schema A and load a backup into schema B
> and fix the data (or whatever).
>
> Thanks
>
> Dave
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering