Re: Database schema

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Database schema
Дата
Msg-id A737B7A37273E048B164557ADEF4A58BA67E@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Database schema  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-general
Andreas Kretschmer wrote:
> Albe Laurenz <laurenz.albe@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.

Technically you are right, but from the original question I assumed
that the schema should have the same name as the database.

Yours,
Laurenz Albe


В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: how do I grant select to one user for all tables in a DB?
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: Permission denied in file_fdw (Windows)