PostgreSQL installs two default
template
databases. Upon creation, a new database is
cloned
from one of these templates. They are template0, and
template1. Of these, you may only connect to template1.
This is because the template0 database exists as an empty template, while
template1 may be modified to include commonly used languages, functions, and
even database objects, such as tables, views, or sequences. Neither of the template databases may be removed from the
system.
The following sections cover creating and removing databases from PostgreSQL.
