Fwd: Identify system databases - Mailing list pgsql-general

From Igor Korot
Subject Fwd: Identify system databases
Date
Msg-id CA+FnnTwFpzxQmTGi8_2jrFB5z_=d8H+PJuWVpfYXqY7G74-kMA@mail.gmail.com
Whole thread Raw
In response to Identify system databases  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general


---------- Forwarded message ---------
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, Apr 15, 2025 at 11:16 AM
Subject: Re: Identify system databases
To: Adrian Klaver <adrian.klaver@aklaver.com>


Hi, Adrian,

On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 4/15/25 07:48, Igor Korot wrote:
> Hi, ALL,
> Is there a field in the pg_databases table which indicates that
> particular DB is a system one?

No there is not. As a practical matter they are no different then any
user created database, other then template0 is created with datallowconn
  set to false.

Understood. Will filter by name…

Thank you.



>
> Or it can be determined ony by name?
>
> Thank you.
>

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Fwd: Identify system databases
Next
From: Tom Lane
Date:
Subject: Re: Identify system databases