Re: Tables in public schema - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Tables in public schema
Date
Msg-id CANzqJaAftAp5m2ucNC_G_sp34QSH5tZ=eEvy0+Mrbv5ow8yK2g@mail.gmail.com
Whole thread Raw
In response to Re: Tables in public schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Tables in public schema
Next
From: "David G. Johnston"
Date:
Subject: Re: How to check if a Procedure or FUNCTION EXIST