Creating a PostgreSQL database

 

Overview

SQL stands for Structured Query Language. SQL is an international standard in querying and retrieving information from databases. PostgreSQL is essentially an SQL server - it responds to requests for information that are written in SQL. To use a PostgreSQL database, you must first create it, and then add one or more users to it.

 

 

Steps

1 To access the Postgres Account Maintenance Menu, click on the    icon above the words PostgreSQL Databases on the main screen of your cPanel interface.

2 Enter the name of the new database in the blank field next to Db:

3 Click on Add Db to create the database.

 

Troubleshooting

You need to create at least one database user and grant that user permission to use the new database. Refer to Creating a PostgreSQL user and Grant a user's permissions to a PostgreSQL database for more information.