gistfile1.txt

CREATE OR REPLACE FUNCTION meta_find_references(tablename text)
RETURNS TABLE (type text, name text)
AS $$
  SELECT 'View', table_name FROM information_schema.views WHERE view_definition ~* $1
  UNION
  SELECT 'Function', routine_name FROM information_schema.routines WHERE routine_definition ~* $1
  ORDER BY 1, 2
$$
LANGUAGE SQL;