{"id":576,"date":"2024-12-03T08:59:27","date_gmt":"2024-12-03T01:59:27","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=576"},"modified":"2025-01-02T19:53:24","modified_gmt":"2025-01-02T12:53:24","slug":"postgresql-recursive-cte","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-tutorial\/postgresql-recursive-cte\/","title":{"rendered":"PostgreSQL Recursive CTE"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the PostgreSQL recursive CTE to query hierarchical data such as organization charts and category trees.<\/p>\n\n\n\n

Getting Started with the PostgreSQL Recursive CTE #<\/a><\/h2>\n\n\n\n

CTE<\/a> provides a way to define a temporary table within a query. A recursive CTE is a type of CTE that references itself in its CTE query definition.<\/p>\n\n\n\n

In programming, a recursive function is a function that calls itself until it doesn’t. Similarly, a recursive CTE is a CTE that references itself in the CTE query.<\/p>\n\n\n\n

A recursive CTE has two main parts:<\/p>\n\n\n\n