Re: Tables in public schema

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Tables in public schema
Дата
Msg-id CANzqJaAftAp5m2ucNC_G_sp34QSH5tZ=eEvy0+Mrbv5ow8yK2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tables in public schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
On Tue, May 27, 2025 at 10:12 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, May 27, 2025 at 7:02 AM Edwin UY <edwin.uy@gmail.com> wrote:
Will I have to redo the grants?

If you use "alter table set schema" the table OID will not change and the grants should follow it.  Users would be subject to whatever new permissions apply to the newly created schema rather than the public schema though.

 And he'll either have to SET SEARCH_PATH or manually qualify every CREATE TABLE statement with the correct schema name.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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