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