Create Database Uses Template1
postgres
Written July 09, 2020
Whenever you use the create
database
query, unless otherwise specified, it will create it by cloning template1 by
default.
You can view, inspect, and even modify this database template by connecting to it.
\c template1
Every Postgres cluster starts with two templates.
select datname from pg_database where datistemplate = true;
datname
-----------
template1
template0
(2 rows)
You cannot however connect to and modify template0. It is a fallback clone of
template1 that you can utilize if you ever modify template1 and need to
restore it.