Get all ancestors

gistfile1.txt

WITH RECURSIVE ancestors(id, name) AS (
    SELECT entity.id, entity.name
    FROM t_directory as entity
    WHERE entity.parentDirectory = '201'
  UNION ALL
    SELECT next.id, next.name 
    FROM t_directory as next, ancestors
    WHERE next.parentDirectory = ancestors.id
)
SELECT * FROM ancestors