Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Tables in public schema
Date
Msg-id CAKFQuwauK-3-gUSj+YVMKYi0+LtmnVBaF69V_RHDem1cqC8_gQ@mail.gmail.com
Whole thread Raw
In response to Tables in public schema  (Edwin UY <edwin.uy@gmail.com>)
Responses Re: Tables in public schema
List pgsql-admin
Tree view
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.

David J.

pgsql-admin by date:

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