PostgreSQL is a powerful open-source relational database management system that offers a wide range of features for managing data. This guide provides an overview of the common database operations in PostgreSQL.
To create a database in PostgreSQL, you can use the CREATE DATABASE command followed by the name of the database you want to create. Here’s the syntax:
CREATE DATABASE database_name;
Example:
CREATE DATABASE mydatabase;
To select a database for performing operations, you need to establish a connection to that database. In PostgreSQL, you can use the CONNECT command or the SET command to set the current database. Here are the examples:
Using CONNECT:
\c database_name;
Example:
\c mydatabase;
Alternatively, you can also use the SET command to set the current database. Here’s the syntax:
SET DATABASE = database_name;
To drop or delete a database, you can use the DROP DATABASE command followed by the name of the database. However, be cautious as dropping a database will permanently delete all data and cannot be undone. Here’s the syntax:
DROP DATABASE database_name;
Example:
DROP DATABASE mydatabase;
Please note that creating, selecting, or dropping a database might require appropriate privileges and permissions based on the user executing the commands.
It’s essential to exercise caution while performing database operations, especially when dropping a database, as it permanently removes all data associated with it.