Hello! Our beginner PostgreSQL administrator series are going on! In this article i am going to cover how to create PostgreSQL database in dbeaver question.

There are other options to create a database in Postgresql, such as using PgAdmin or command line.

PosgreSQL in Dbeaver

In my previous article i am covered how to connect docker database from dbeaver topic, if you need help you can refer to this article.

PgAdmin and Dbeaver are the best free tools to manage PostgreSQL servers, with multiple database support i believe Dbeaver is one step ahead of PgAdmin.

If you haven’t tried dbeaver, i’d like to suggest you to check it out and give it a try.

What is a Database

Database is a separate logical unit in a PostgreSQL installation to separate permissions, data, storage unit and other objects.

Our target is to have at least one database for each project.

Creating PostgreSQL Database in Dbeaver

You can see database navigator pane of the dbeaver above. database navigator pane is used to access, objects, schemas, tablespaces, tables etc of database.

You can see Projects tab on right of the database navigator tab, i am going to cover Projects tab in another article because i find this feature really useful.

You can right click to Database and click to Create New Database or use alt + insert shortcut to create a new database.

Create database dialog is very simple for PostgreSQL. Give a name to database, assign an owner to database.

You can select template database in this dialog and encoding and default tablespace. Click OK to complete dialog.

You created a new PostgreSQL database! Thats all

Sum Up

We covered How to Create PostgreSQL Database in Dbeaver topic. You can prefer other options to create databases, you can use PgAdmin or command line to create a database.