Re: Database schema - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Database schema
Date
Msg-id A737B7A37273E048B164557ADEF4A58BA1D5@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Database schema  (Dhiraj Gupta <dhiraj.g@nic.in>)
Responses Re: Database schema  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: RE: [GENERAL] Strange Connection Problem….
Next
From: Greg Williamson
Date:
Subject: Re: Database schema