public inbox for [email protected]  

help / color / mirror / Atom feed

From: Edwin UY <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Tables in public schema
Date: Wed, 28 May 2025 02:01:23 +1200
Message-ID: <CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Tables in public schema
  In-Reply-To: <CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox