Tables in public schema

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Tables in public schema
Date: 2025-05-27 14:01:23
Message-ID: CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-05-27 14:11:16 Re: Tables in public schema
Previous Message Laurenz Albe 2025-05-23 09:46:48 Re: Replication lag