Fwd: Identify system databases

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

Hi, Adrian,

On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
>