Databases are destroyed with the command DROP DATABASE:
In order to create a database, the PostgreSQL server must be up and running (see
Recall from Chapter 19 that the PostgreSQL server provides a large number of run-time configuration variables. You can set database-specific
Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects
CREATE DATABASE actually works by copying an existing database. By default, it copies the standard system database named template1
A database is a named collection of SQL objects ("database objects"). Generally, every database object (tables