export/import from one schema to another?

From: "Les Carter" <les(dot)carter(at)help-me(dot)to>
To: pgsql-novice(at)postgresql(dot)org
Subject: export/import from one schema to another?
Date: 2005-02-14 06:54:51
Message-ID: 1108364091.4918@workhorse.newkinetics.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

This is a multi-part message in MIME format.

--bound1108364091
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit

I've seen the pg_dump utility which backs up a database with which you can then use psql to restore but I was wondering how do you go about doing an import/export (like you can do with Oracle) where you can export info from one schema and use that as a reference point and import that data into other schemas to make replicas.

Hopefully someone can cast some light on this that would be a little cleaner than having to search/replace in the dump file for the schema name.

Cheers,

L

--bound1108364091--

Browse pgsql-novice by date

  From Date Subject
Next Message Kjetil Haaland 2005-02-14 09:08:43 Re: function returning a row
Previous Message Elinor 2005-02-13 15:41:18 Re: find close (duplicate) points + create index