Explain PostgreSQL inheritance and its use cases.

Table inheritance allows tables to inherit columns and constraints from parent tables.

Use Cases:
• Partitioning large tables
• Common column structures
• Hierarchical data modeling

Example:

CREATE TABLE vehicles (
    id SERIAL PRIMARY KEY,
    brand VARCHAR(50)
);

CREATE TABLE cars (
    doors INT
) INHERITS (vehicles);

-- Query all vehicles (including cars)
SELECT * FROM vehicles;

Benefits:
• Code reuse
• Simplified queries
• Automatic partitioning