I have recursive query to retrieve all children of a given person
WITH RECURSIVE recursetree(id, parent_id) AS ( SELECT id, parent_id FROM tree WHERE parent_id = 0 UNION SELECT t.id, t.parent_id FROM tree t JOIN recursetree rt ON rt.id = t.parent_id ) SELECT * FROM recursetree;
As you can see, I'm specifying list of columns to be retrieved. But I want to use
SELECT * (I have really many columns in real table, and they can be changed in future). Is there some way to get ALL columns without defining each column individually?