Re: Identify system databases - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Identify system databases
Date
Msg-id ef83fd38-f11d-491b-9d02-86e0f2ccc575@aklaver.com
Whole thread Raw
In response to Identify system databases  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Identify system databases
List pgsql-general
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.

> 
> Or it can be determined ony by name?
> 
> Thank you.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Identify system databases
Next
From: Karsten Hilbert
Date:
Subject: Re: Help with PhD Dissertation