Recursive query in postgres to fetch the whole tree in one go

[krtschmr]

Is it possible to create recursive postgres queries to fetch the tree structure in one go?
i tried to google a bit around but didn't find much. if somebody could give me a starting point, that would be great