Re: Tables in public schema

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Tables in public schema
Date: 2025-05-27 14:11:16
Message-ID: CAKFQuwauK-3-gUSj+YVMKYi0+LtmnVBaF69V_RHDem1cqC8_gQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 27, 2025 at 7:02 AM Edwin UY <edwin(dot)uy(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2025-05-27 15:01:17 How to check if a Procedure or FUNCTION EXIST
Previous Message Edwin UY 2025-05-27 14:01:23 Tables in public schema