Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

WITH

WITH defines named subqueries for use in one larger SQL statement. It can simplify complex queries, support recursion, and include data-changing statements.

Last updated

Syntax

WITH [ RECURSIVE ] with_query [, ...] primary_statement

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • MERGE
  • RETURNING
  • CYCLE
  • SEARCH

Source: PostgreSQL: Documentation: 18: 7.8. WITH Queries (Common Table Expressions). Checked 2026-11-03.