
The following is a simple example, which will create testdb in your PostgreSQL schema. PostgreSQL command line executable createdb is a wrapper around the SQL command CREATE DATABASE. I assume you’re familiar with the command line and have a rough idea about what database administration tasks, but aren’t familiar with how to use psql to do the basics.
The PostgreSQL documentation is incredibly well written and through, but frankly, I didn’t know where to start reading. Step 2) Press enter five times to connect to the DB. How to create a database from shell. If set, the name of the database to create , unless overridden on the command line.
PGHOST PGPORT PGUSER. Default connection parameters. PGUSER also determines the name of the database to create , if it is not specified on the command line or by PGDATABASE.
Using the command line , you can create a MySQL database while logged in as root. View all databases when complete. Read this Liquid Web tutorial. Set Up a PostgreSQL Database on Windows. To use Media Server with a PostgreSQL database , you must download and install a PostgreSQL server and ODBC driver, and configure Media Server to connect to the database through the driver.
The procedure describes setting up the database server using the psql command - line tool.

