Fwd: Identify system databases

Поиск
Список
Период
Сортировка
От Igor Korot
Тема Fwd: Identify system databases
Дата
Msg-id CA+FnnTyWMXPEVAwNNDnCVDfmTFNHdDfffiF5vLioxyTv8Jmq0A@mail.gmail.com
обсуждение исходный текст
Ответ на Identify system databases  (Igor Korot <ikorot01@gmail.com>)
Ответы Re: Fwd: Identify system databases
Список pgsql-general


---------- 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 по дате отправления: