Tables in public schema

Поиск
Список
Период
Сортировка
От Edwin UY
Тема Tables in public schema
Дата
Msg-id CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Tables in public schema
Re: Tables in public schema
Список pgsql-admin
Hi,

In one of the PostgreSQL Instances, I just found out that the tables are created in the public schema even though there is a user database.
New tables are also getting created in the public schema.
There is no non-public schema when I run \dn, it only shows public.
I assume this is a risk of some sort and want to create a user schema and move them from public to the new schema.
Will I have to redo the grants?

Regards,
Ed

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