Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4hax-006ACe-D5 for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 14:49:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u4hav-00BJxD-ML for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 14:49:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4hav-00BJvO-BB for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 14:49:02 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4hat-000D2p-3A for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 14:49:01 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6ef60e500d7so50799127b3.0 for ; Tue, 15 Apr 2025 07:49:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744728539; x=1745333339; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2BfzjivHeL4XgSu7203+OIu3dmQKh2nAVJ1RnfxCl74=; b=YuMPo+M2GJVcRtyBGsk/Q3tbnEZhi/Ehs50i/zNQjQygE0kMIteBCZsK7/imtGy+XN XvsKQNVEs1XZgehgzpMvv/2K1yruLFkSatPtdpMDGZALwrx+Ep+jgtLoggE014nliDfQ 3hb9iHDbmEEFUa8dAMXR+28iJyyKRCqXlw069dckf3+pK/3WDUxM45WR8CkTI3XzBTN7 4RXoNAiAqHwJBPxKMR5PocsIYpU3XnEQMDlEJQnEmakSnObxcXjuo9G7IxJgfc0eOok2 f9nAzWHgHtd+PfVr5KsFCeDSg0cm4DGs1g8BsYGaUL32wFyVNlQGvUeRHvG2bB+u25YM Ijkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744728539; x=1745333339; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2BfzjivHeL4XgSu7203+OIu3dmQKh2nAVJ1RnfxCl74=; b=Hi5LVInjN76Q51VThwHM+WAQTdcRJrLX9gnFsoYJp43oWT2XoKH+GD1n6G+8ynH4Ra peKVZwINvEw6tEbRMDig855Vy66/EczOE+n9/NYwZqEsw09p85sJGZPYwpNx32cdLQBZ nEUoLFaxzmacNkil69ewpFgkUm3nY8DljoRkygtmjQ1NvT36s7OyeEUt+2AE7D68/Fs7 GfiYSRYnPYTDRQiuOCai0NhqtHqDfh9xfqrZtbu9VXhalZtyKjCMNoZSZIqbn0KggxOb bjg2y5/Fjl2MKtRR5uvuR5PHGinjVasUiU8Z8Slf8Sy9hgmBgKBe3YOB9/kFd8sabrtW 3VPw== X-Gm-Message-State: AOJu0YybYxmLwTApTTHgkb4Y5AprF7kEdOTR47J5yyHVF7ZWdOlqq5Tq Vy3/TW33rUzdhcdQi3Tm74//HRE0ttQYi55OTvVkabCaeliQKh8+l7d6jTaLMMVumbg/NDfDR8B P6iKyETeugSjcnJpHIsbWMCH5g6SgJOr2 X-Gm-Gg: ASbGncuHITVTDZK7P2ACQ7l9yo+NMOvEo086b/EMwSNpBmwH3X19rKOJHcT6bVbcZOs aYbGkEwMhp9wbFOcQ7swuB9fLCnbjbPluHzXedOm2uCsrLbNbl33vYcWnTZZvTCpnHgpN6dfs39 QO8g986sC9Skc+1baz7aM4rjFe58nLQfpijMH3mEivE3MPzwrsZAdSzKdU X-Google-Smtp-Source: AGHT+IG8KxL/hOtim0UK4ixyCTfvytoD5vK4mPTFRGOv78uuEBmtuCcDmz3dMS41LM38DoSUqfv05XZ1Op7TfA7d7Tk= X-Received: by 2002:a05:690c:25c4:b0:6fd:42ed:c90 with SMTP id 00721157ae682-705599c9cc1mr269493117b3.16.1744728539068; Tue, 15 Apr 2025 07:48:59 -0700 (PDT) MIME-Version: 1.0 From: Igor Korot Date: Tue, 15 Apr 2025 09:48:48 -0500 X-Gm-Features: ATxdqUFN99t7CpKkIMK-YxvUkqy5VQGCE3Tfpxy1zQltk1FQC5rtiI970koWZR4 Message-ID: Subject: Identify system databases To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000cd00530632d244e3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cd00530632d244e3 Content-Type: text/plain; charset="UTF-8" Hi, ALL, Is there a field in the pg_databases table which indicates that particular DB is a system one? Or it can be determined ony by name? Thank you. --000000000000cd00530632d244e3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, ALL,
Is there a field in the pg_data= bases table which indicates that particular DB is a system one?

Or it can be determined ony by name= ?

Thank you.

--000000000000cd00530632d244e3--