| From: | "Andrus" <eetasoft(at)online(dot)ee> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to make a copy of schema |
| Date: | 2006-11-24 09:11:09 |
| Message-ID: | ek6daa$1pn1$2@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>> In need to add some routine to my application which can create schema
>> copy ?
>
> You can make a pg_dump with option -n Company5, replace in the dump
> Company5 with Company6 and restore this.
I dont have suffix like _schema in my company schema names.
So "Company5" string may be used in places other than schema names so this
does not work.
> Or, make the dump, rename schema Company5 to Company6 and restore then
> the dump.
> Be careful with things like sequences!
Will
ALTER SCHEMA name RENAME TO newname
rename schema names in used in foreign key constaints and triggers and all
other places also ?
Documentation does not describe this.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | surabhi.ahuja | 2006-11-24 09:12:30 | IN clause |
| Previous Message | Andrus | 2006-11-24 09:04:19 | How to clone a table so that primay and foreign keys remain |