Unformat.online
More tools
Clean Text
Strip smart quotes, zero-width characters, non-breaking spaces, and invisible Unicode from any pasted text.
Format JSON
Prettify or minify JSON. Auto-fixes single quotes, trailing commas, and unquoted keys.
Format SQL
Format SQL for MySQL, PostgreSQL, BigQuery, T-SQL, and more — uppercase keywords, proper indentation.
Format YAML
Format and validate YAML. Catches indentation errors in Kubernetes, Docker Compose, and GitHub Actions files.
Format XML
Indent and pretty-print XML. Works with SOAP, RSS, Maven POM, Android manifests, and SVG.
Markdown Viewer
Live split-view editor and renderer — edit on the left, preview on the right.
FileSQL
Drop a CSV or JSON file and query it with SQL instantly — no upload, no server.
Shredder
Remove EXIF, GPS, and author metadata from images and PDFs. Redact secrets from text and log files.
CronScope
Paste a cron schedule and see every run on a 12-month calendar. Never misread a cron expression again.
JWT Debugger
Decode JWTs instantly — view all claims, check expiry, and see the algorithm. Token never leaves your browser.
Base64
Encode text or files to Base64, or decode Base64 strings and preview images inline.
URL Encode / Decode
Encode URLs or decode percent-encoded strings like %20, %3D, %26 — instantly.
UUID Generator
Bulk-generate cryptographically random v4 UUIDs using crypto.randomUUID(). Copy one or all at once.

Format PostgreSQL Online

Beautify PostgreSQL queries with proper indentation and keyword formatting. Paste your Postgres SQL and get clean, readable output instantly — 100% client-side.

Rules:Smart QuotesConverts curly quotes (“” ‘’) to straight quotes. Always active.Non-Breaking SpacesReplaces non-breaking spaces (U+00A0) with regular spaces. Always active.Line EndingsNormalizes CRLF → LF and trims trailing whitespace per line. Always active.Removes invisible zero-width characters (U+200B, U+200C, U+200D) that silently break string comparisons.Strips the Byte Order Mark (U+FEFF) that causes “invalid character” errors in parsers and editors.Removes soft hyphens (U+00AD) from PDFs that show as garbled characters in code editors.Converts mixed tabs/spaces to a consistent indent width. Click to pick a size.Collapses all line breaks into one continuous paragraph. Great for reflowing PDF or email text.Control blank line density. Click to pick Keep 1 or Remove all.Text never leaves your browser
0 characters

PostgreSQL SQL formatting

PostgreSQL has an expressive SQL dialect with features not found in the SQL standard: window functions, RETURNING clauses, WITH (CTE) support, JSONB operators, and double-quoted identifiers. Using the PostgreSQL dialect ensures these constructs are formatted correctly.

This formatter handles PostgreSQL-specific syntax including ILIKE, SIMILAR TO, :: cast syntax, LATERAL joins, and array expressions. Standard SQL formatters may produce incorrect results for these constructs.

How to format PostgreSQL queries

  1. Paste your PostgreSQL query into the text area above.
  2. The formatter is pre-set to PostgreSQL dialect. Toggle keyword casing as needed.
  3. Copy the formatted output with the Copy button or Ctrl+K.

Other SQL formatters