SQL Series

Installing PostgreSQL and Dbeaver

Photo by Max Duzij on Unsplash

Go to https://www.postgresql.org/download/. Select the suitable installer and download it.

Select the suitable installer
Then, run the installer and follow the instruction. When it needs password, just put it randomly.

Also, install the Dbeaver through https://dbeaver.io/download/. Follow the instruction to install it.

I select the community edition 7.0.2

For exercise, we will download the sample database named dvdrental in link https://www.postgresqltutorial.com/postgresql-sample-database/. Then, extract it as winrar/tar type. Notice the path we save this file.

We will work on database through Dbeaver that connected to Postgres. To open it up, here are the steps.

Open the SQL Shell. Copy all the words inside bracket. Then, close it.
Now we open the Command Prompt. Write cd C:\Program Files\PostgreSQL\12\bin.
Now, open Dbeaver. Go to New Database Connection.
Select PostgreSQL.
Fill in the field of database according to the name and password.
We would see a folder named dvdrental in left side.
To make a new script, select SQL Editor à SQL Editor
Finally, the screen would be like this.