PAN Validation Project (PostgreSQL)

This project validates PAN numbers using PostgreSQL functions, regex, and views.

Features

• Cleans raw data (handles nulls, duplicates, spaces, casing)
• Validates PAN format (regex + custom functions)
• Categorizes into Valid and Invalid
• Generates summary report with counts

Technologies

• PostgreSQL 17
• SQL (PL/pgSQL functions, regex, windowing)

How to Run

1. Create database in PostgreSQL
2. Run pan_validation.sql
3. Import dataset into stg_tbl_pan_validation
4. Query the view vw_categorized_pan_numbers