Re: List user databases - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: List user databases
Date
Msg-id CAB8KJ=hhVTwj4eF3GnnQ0eYLqzakc6xj9mdn1AjSiAfWTA0s9A@mail.gmail.com
Whole thread Raw
In response to List user databases  (Igor Korot <ikorot01@gmail.com>)
Responses Re: List user databases  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
2022年11月10日(木) 13:41 Igor Korot <ikorot01@gmail.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



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: List user databases
Next
From: Adrian Klaver
Date:
Subject: Re: List user databases