List the tables that a view depends on.

inf_view_dependencies.sql

-- List the tables that a view depends on.
-- Usage: select * from inf_view_dependencies(SOME_VIEW);
-- Thanks to Dave: http://stackoverflow.com/questions/4229468/getting-a-list-of-tables-that-a-view-table-depends-on-in-postgresql
create function inf_view_dependencies(v text)
returns table (kind text, name text) as $$
SELECT     cl_d.relkind::text as kind
        ,  cl_d.relname::text AS name
FROM pg_rewrite AS r
JOIN pg_class AS cl_r ON r.ev_class=cl_r.oid
JOIN pg_depend AS d ON r.oid=d.objid
JOIN pg_class AS cl_d ON d.refobjid=cl_d.oid
WHERE cl_d.relkind IN ('r','v','m') AND cl_r.relname=$1 and cl_d.relname!=$1
GROUP BY cl_d.relname, cl_d.relkind
ORDER BY cl_d.relname;
$$ language SQL;