WITH RECURSIVE view_tree(parent_schema, parent_obj, child_schema, child_obj, ind, ord) as 
(
  SELECT vtu_parent.view_schema, vtu_parent.view_name, 
    vtu_parent.table_schema, vtu_parent.table_name, 
    '', ARRAY[row_number() over (ORDER BY view_schema, view_name)]
  FROM information_schema.view_table_usage vtu_parent
  WHERE 
    vtu_parent.table_schema = 'schema_name' AND 
    vtu_parent.table_name = 'table_name'
  UNION ALL
  SELECT vtu_child.view_schema, vtu_child.view_name, 
    vtu_child.table_schema, vtu_child.table_name, 
    vtu_parent.ind || '  ', 
    vtu_parent.ord || (row_number() over (ORDER BY view_schema, view_name))
  FROM view_tree vtu_parent, information_schema.view_table_usage vtu_child
  WHERE vtu_child.view_schema = vtu_parent.child_schema 
  AND vtu_child.view_name = vtu_parent.child_obj
) 
SELECT concat(tree.ind, tree.parent_schema, '.', tree.parent_obj, 
  ' depends on ', tree.child_schema, '.', tree.child_obj) AS txt, 
  tree.ord
FROM view_tree tree
ORDER BY ord;