Default DATABSES IN POSTGRES - Postgres, Template0, Template 1

Postgres, Template0, Template 1 :
A database is an ordered collection of data that has been arranged for effective management, retrieval, and storage. It is made up of tables, each of which has data rows arranged into columns and may also contain additional objects like views, functions, indexes, and more.

Through a variety of capabilities and restrictions, PostgreSQL databases offer a foundation for managing transactions, storing, and organizing data, as well as enabling secure access and data integrity enforcement. PostgreSQL is a strong and adaptable relational database management system since each database runs independently, enabling the isolation and separation of data and capabilities.

In PostgreSQL, a database is a collection of schemas, tables, functions, and other objects. It's a structured set of data organized for easy access, retrieval, and management.

When you first install the database server, there are typically three default databases created:

postgres :
This is the default administrative database. It is created automatically when PostgreSQL is installed. It's used for managing the PostgreSQL server itself and is typically not used for storing application data.

template0 :
This database serves as a template for creating new databases. It's essentially a "clean" template that can be copied to create other databases. You usually shouldn't modify this database directly.

template1 :
This database is similar to template0 but can be modified. It's often used as a template for creating new databases with customizations or additional extensions already installed.


(Database creation from bash)