Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uJusY-009EX5-DM for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 14:02:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uJusW-008Iaz-SI for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 14:02:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uJusW-008Ial-HP for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 14:02:04 +0000 Received: from mail-pl1-x631.google.com ([2607:f8b0:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uJusT-000NSp-2J for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 14:02:04 +0000 Received: by mail-pl1-x631.google.com with SMTP id d9443c01a7336-234b9dfb842so2484555ad.1 for ; Tue, 27 May 2025 07:02:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748354520; x=1748959320; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=UNieeOEJt1/tBcd6gf0QDhQnbZhxSCGuH+tbW2n9ZRo=; b=kTJYo6lmWYU+vnLTmK2VWOEyd4/T99nAGFIpebMhqND8x/LAUHYq663lkjVth63eFl Aap4DCGWCTePW0iFvZargkgLP0n8UPuxT4eMMC8G1aT75N2CtvA3+Lc0wztzLsqb3t5r 7WCa7TMwCssHEgNKxL/SWvk1MvaICW6Oq8z9NG40GVrZMk7C2t4EtAmM0uGGopPqV1nx zrv7Na5ustZ+SpOtX8yDSThvTXkZ/H0WGXYP7yM8Ed5SAzgYNER8BhPPtIQSWiF/dLHz qcf/QaArbjqp8m9MvjOQhSoAznI75voZQM7PP7BbnJV6hB6as4DOFElwuoLLE+SsaQYO Kgkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748354520; x=1748959320; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=UNieeOEJt1/tBcd6gf0QDhQnbZhxSCGuH+tbW2n9ZRo=; b=IKjKRcTB1j8LTXOqPMxzUEhJl67gC7JwYX6ykMKM10zpAJRo/E+l+9xCOHSjuQWSPJ ktYtF6QN+5fMsIHVmrEfz5zwwXdPChvCAMmkd30D1me+kvsU9jjcNqoTXnwjnt2U2Ekd joWxulLY2bT6MoVWKLw0jf3bd11aB4dZkfRRiDllQTC+BeYLlGAzoCTLrtbAmD00/Weh hUDvYDt6fPczWBJixBpG45ROXLtq7G/9jfqeP1A+vYpiCp9ijpFDcLX4bll5xlmK+Yr2 x4TGyXxxEWe/fcryusEYtpSli5XzKoxSdMXKcPuCqnLKoQQ+EMhZ7EbghxIM3ak+hlds Q83A== X-Gm-Message-State: AOJu0Yy+ZL6YigqIO0VSFtcnhx1NmAdbe6mz4fPKdz2333jcCoaB3hZ4 rohmS7AxvIJPplGEgYGe4Cfha85juXkG3N6VGSZSGLYDYgJ2d/yRXlGeVna869IDg1XqpEHhUuM VF/iLEng/ppD+8I1Q2fRtaP631MXun3qeLcxE X-Gm-Gg: ASbGnctFQBUVFZJmD3r0Cqd7ZCAK4LYft1MM62cAEReaW5tjxX35Kj+ezyz0vePtHox A9H925hPtb4f0nqcTftgejZWlVaZe5EBWT3a5X/TBUdVmOvoY1dL/gDh2Doxi+GQMwFHrC8tcau pBz/2ldoXeNbrc7y0X6KhmykQtSBUIJYFl X-Google-Smtp-Source: AGHT+IF+3auf6h3JjfwgMkpEz0LFidgknSb7XO20/I2co0GQQYmrT05EBD9RHkqPswEnw3YtjgJpGc9TC5O4AvuQ++I= X-Received: by 2002:a17:902:cf4c:b0:211:e812:3948 with SMTP id d9443c01a7336-23414e9fbdfmr200313735ad.0.1748354519675; Tue, 27 May 2025 07:01:59 -0700 (PDT) MIME-Version: 1.0 From: Edwin UY Date: Wed, 28 May 2025 02:01:23 +1200 X-Gm-Features: AX0GCFsSqclaZYfdlP_P43SNUJXUQk3g2WqsXASnSmiBWpswYJ-NhkN9kO2iWQc Message-ID: Subject: Tables in public schema To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000016387206361e82a1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000016387206361e82a1 Content-Type: text/plain; charset="UTF-8" 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 --00000000000016387206361e82a1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

In one = of the PostgreSQL Instances, I just found out that the tables are created i= n the public schema even though there is a user database.
New tab= les are also getting created in the public schema.
There is no no= n-public schema when I run \dn, it only shows public.
I assume th= is is a risk of some sort and want to create a user schema and move them fr= om public to the new schema.
Will I have to redo the grants?

Regards,
Ed
--00000000000016387206361e82a1--