| 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: | Whole Thread | Raw Message | 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 |