PostgreSQL Function Reference

WITH

Defines a common table expression (CTE).

PostgreSQL 17.5

WITH name_cte AS (subquery)

name_cte

The CTE name

subquery

The subquery

Examples

PostgreSQL 17.5

WITH family_stats AS (
	SELECT STATUS,
		COUNT(*) AS cnt
	FROM FamilyMembers
	GROUP BY STATUS
)
SELECT *
FROM family_stats;