Home > mailing lists

Tables in public schema - Mailing list pgsql-admin

From	Edwin UY
Subject	Tables in public schema
Date	May 27 17:01:23
Msg-id	CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com Whole thread Raw
Responses	Re: Tables in public schema Re: Tables in public schema
List	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,

From: Dionysios-Charalampos Vythoulkas
Date: 23 May, 11:31:19
Subject: Re: Replication lag

From: "David G. Johnston"
Date: 27 May, 17:11:16
Subject: Re: Tables in public schema