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--
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 |