Re: Tables in public schema

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Tables in public schema
Date: 2025-05-27 15:31:43
Message-ID: CANzqJaAuDpnjJw44n+XeO-FhFsw03XmynHojaBO593_pxKbfyA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 27, 2025 at 10:02 AM Edwin UY <edwin(dot)uy(at)gmail(dot)com> wrote:

> Hi,
>
> the tables are created in the public schema *even though there is a user
> database.*
>

schemata are subsidiary to databases. Every table *must* be created in
*some* schema.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-05-27 15:33:17 Re: Tables in public schema
Previous Message David Okeamah 2025-05-27 15:09:16 Re: How to check if a Procedure or FUNCTION EXIST