Re: List user databases

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: List user databases
Date: 2022-11-10 04:57:53
Message-ID: CAB8KJ=hhVTwj4eF3GnnQ0eYLqzakc6xj9mdn1AjSiAfWTA0s9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2022年11月10日(木) 13:41 Igor Korot <ikorot01(at)gmail(dot)com>:
>
> Hi, ALL,
> According to https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-postgresql-using-psql/,
> there are generally 3 system DBs.
>
> However I'm confused with the word general.
> How many system databases can be made on a PG server?

template0 and template1 are the mandatory system databases which
cannot be dropped.

"postgres" is created by default for operational convenience, but is
not essential and can
be removed if you really want to.

Regards

Ian Barwick

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-11-10 05:16:40 Re: List user databases
Previous Message Igor Korot 2022-11-10 04:40:49 List user databases