Albe Laurenz <laurenz.a...@wien.gv.at> wrote: > Dhiraj Gupta wrote: > > I have created a database name '"ofbiz". then the default schema name > > "public " > > created automatically. I want to create schema name ofbiz in the database > > "ofbiz" > > when I create database name "ofbiz" then the schema name "ofbiz" will > >create automatically. > > how it is possible if yes, > > There is no way to automatically create a schema when you create a database. > Connect to the newly created database and create it with CREATE SCHEMA. > You can DROP SCHEMA public if you don't need it.
There is a way to create a so called schema in every new created database: create that schema in the template1, or create a new template database and use this template to create a new database. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
