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.
Yours,
Laurenz Albe