PostgreSQL SQL Formatter

Format PostgreSQL queries with dialect-aware keyword handling. Runs entirely in your browser.

Indent

Case

Input

select u.user_id, u.email, count(o.order_id) as total_orders from users u left join orders o on u.user_id = o.user_id where u.status = 'active' group by 1, 2 order by 3 desc;

Formatted OutputWaiting…

Key Differences

•Supports DISTINCT ON, JSONB operators, and :: type casts.
•Preserves generated always columns and partitioning DDL.
•Double-quoted identifiers retained.