Error encyclopedia

Breaking SQL

Paste a PostgreSQL query. We expand short table aliases, pretty-print, and list assumed indexes guessed from the SQL — not from your database. The dialect menu is an output hint for those indexes and guessed DDL. Paste an error below for a matching article.

This site uses a session cookie so this browser can remember your plan and Terms agreement. It does not use advertising, analytics, or tracking cookies, so the extra cookie-consent rules that cover those do not apply. You can still record that you are fine with the session cookie.

Rewrite a query

Input is PostgreSQL. Dialect is an output hint for assumed indexes and guessed DDL. Rewrite SQL stays PostgreSQL-shaped. One- and two-character aliases become the table name unless the same table is joined to itself or the alias is a longer clarity name.

Look up an error

Paste the first line of the error. Browse all articles.