---------- Forwarded message ---------
From: Igor Korot <ikorot01@xxxxxxxxx>
Date: Tue, Apr 15, 2025 at 11:15 AM
Subject: Re: Identify system databases
To: David G. Johnston <david.g.johnston@xxxxxxxxx>
From: Igor Korot <ikorot01@xxxxxxxxx>
Date: Tue, Apr 15, 2025 at 11:15 AM
Subject: Re: Identify system databases
To: David G. Johnston <david.g.johnston@xxxxxxxxx>
Hi, David,
On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tuesday, April 15, 2025, Igor Korot <ikorot01@xxxxxxxxx> 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.
