PostgreSQL

WOW,

PostgreSQL is a powerful, open-source relational database management system known for its robustness and SQL compliance.

generated by author with leonardo.ai

1. Basic Database Operations

1.1. Creating a Database

CREATE DATABASE my_database;

1.2. Connecting to a Database

psql -d my_database

1.3. Dropping a Database

DROP DATABASE my_database;

2. Creating and Managing Tables

2.1. Creating a Table

CREATE TABLE employees (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    position VARCHAR(50),
    salary NUMERIC(10, 2),
    hired_date DATE
);

2.2. Altering a Table

Add a New Column:

ALTER TABLE employees ADD COLUMN department VARCHAR(50);

Drop a Column:

ALTER TABLE employees DROP COLUMN department;

Rename a Column:

ALTER TABLE employees RENAME COLUMN position TO job_title;

2.3. Dropping a Table