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


Hi, Adrian,

On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver <adrian.kla...@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.kla...@aklaver.com
>
>

Reply via email to