PostgreSQL Create Database

The PostgreSQL Create Database Tool allows users to visually create databases for PostgreSQL.

Options on the tool include the following:

Database Name (the name of the database to be created)
Owner (the owner of the database)
Template (the template to use for the database)
Encoding (the character encoding to use for the database)
Tablespace (the tablespace to use for the database)
Connection Limit (the maximum number of connections allowed to connect to the database)

Listed below is an example create database SQL statement generated by the Create Database tool for PostgreSQL

CREATE DATABASE testdatabase
OWNER testuser
TEMPLATE template0
ENCODING 'WIN1252'
TABLESPACE pg_default
CONNECTION LIMIT 5

PostgreSQL Create Database