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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
