Creating and Deleting a PostgreSQL Database on Ubuntu 16.04

Cpanel/Whm License $3/mo Plesk License $10/mo Cloudlinux License $5/mo

PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language.  In this tutorial, we will be demonstrating some essentials like creating, listing and deleting a database.

If you have already installed PostgreSQL to your Ubuntu 16.04 server using our last tutorial, your next step is to create a database.  You’ll be accomplishing this task by using the default superuser, postgres, to log in.

Creating a PostgreSQL Database

Step 1: Login as the Postgres User

su - postgres

Step 2: Enter the PostgreSQL Environment

psql

With the psql command, you’ll be greeted by its current version and command prompt.

psql (9.5.14)
Type "help" for help.
postgres=#

Step 3: Creating the PostgreSQL Database

Let’s create our first database by typing in the command below.  Replace dbname with the database name of your choice.

CREATE DATABASE dbname;

 

Listing a PostgreSQL Database

Verify Creation of PostgreSQL Database

Using the following command allows us to view the databases in our PostgreSQL instance (you can ignore, delete or utilize the default databases: postgres, template0, template1)

postgres=# list

 

Deleting a PostgreSQL Database

Once you’ve backed up your removing your PostgreSQL database is a cinch!  Its similar to creating a database but we will be using the drop command. In my command line example, the database name is “dbname”. By using the list command in the previous section, you’ll be able to view your databases’ names. Replace dbname with your database’s name in the command below.

DROP DATABASE dbname;

 

Series Navigation

<< Install and Connect to PostgreSQL 10 on Ubuntu 16.04Listing and Switching Databases in PostgreSQL >>

Related posts

Boot Ubuntu Linux into Rescue mode to fix system

SXI ADMIN

Bitcoin’s Price is Inching Back Up Toward its 2016 High

SXI ADMIN

Former NASDAQ Exec Joins Blockchain Startup Concordium

SXI ADMIN

What should we do with stolen bitcoins?

SXI ADMIN

Bitcoin Startup Blockchain Raises $40 Million Series B

SXI ADMIN

Accenture Develops DLT Prototypes for Singapore’s Central Bank

SXI ADMIN

Exim Remove All messages From the Mail Queue

SXI ADMIN

DeVere Group Targets Arbitrage With New Crypto Fund

SXI ADMIN

Bitcoin: A Means for Global Independence

SXI ADMIN

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More