---------- Forwarded message ---------
From: Igor Korot <ikorot01@xxxxxxxxx>
Date: Tue, Apr 15, 2025 at 11:16 AM
Subject: Re: Identify system databases
To: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
From: Igor Korot <ikorot01@xxxxxxxxx>
Date: Tue, Apr 15, 2025 at 11:16 AM
Subject: Re: Identify system databases
To: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Hi, Adrian,
On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
