Fwd: Identify system databases

---------- Forwarded message ---------
From: Igor Korot <ikorot01(at)gmail(dot)com>
Date: Tue, Apr 15, 2025 at 11:15 AM
Subject: Re: Identify system databases
To: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>

Hi, David,

On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, April 15, 2025, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
>> Hi, ALL,
>> Is there a field in the pg_databases table which indicates that
>> particular DB is a system one?
>>
>
> What is a system database?
>

I consider system database a database that is created by default when the
server is run for the first time.

Kind of a predefined set of databases…

As an example - there is a database called Postgres. It is created when the
server runs for the first time, whether I as a user like it or not.

Thank you.

> David J.
>
>