Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Identify system databases - Mailing list pgsql-general

From Igor Korot
Subject Fwd: Identify system databases
Date
Msg-id CA+FnnTyWMXPEVAwNNDnCVDfmTFNHdDfffiF5vLioxyTv8Jmq0A@mail.gmail.com
Whole thread Raw
In response to Identify system databases  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Fwd: Identify system databases
List pgsql-general
Tree view


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


Hi, David,

On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, April 15, 2025, Igor Korot <ikorot01@gmail.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.
 

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Help with PhD Dissertation
Next
From: Igor Korot
Date:
Subject: Fwd: Identify system databases