PostgreSQL: Create a Database

From Glitchdata
Jump to navigation Jump to search

Command/s to create databases in PostgreSQL server.


PSQL Command Line

postgres=#\h CREATE DATABASE;
postgres=#CREATE DATABASE db_name;

Shell Command Line

A database can be created directly from the shell using "createdb" binary.

$creatdb testdb

pgAdmin

  • Right click on Database and select "New Database"


Links


Related Usage