Re: Identify system databases

2025-04-15 Thread Tom Lane
Adrian Klaver writes: > On 4/15/25 07:48, Igor Korot wrote: >> 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

Re: Identify system databases

2025-04-15 Thread Adrian Klaver
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 f

Re: Identify system databases

2025-04-15 Thread David G. Johnston
On Tuesday, April 15, 2025, Igor Korot 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? David J.