PostgreSQL create and drop database commands

1. Create a new database

Syntax:

CREATE DATABASE [IF NOT EXISTS] db_name;

Example:

CREATE DATABASE mydb;

Here mydb is the name of the database.

2. Drop a database permanently

Syntax:

DROP DATABASE [IF EXISTS] db_name;

Example:

DROP DATABASE mydb;

References

https://www.javaguides.net/2020/02/psql-commands-postgresql-commands-cheat.html

Free Spring Boot Tutorial - 5 Hours Full Course

---

Watch this course on YouTube at Spring Boot Tutorial | Fee 5 Hours Full Course