何かをホゲるためのSQL

メモメモ。しかしどういう仕組みになってるのか全然わかんないよー。

CREATE TEMP SEQUENCE sl_table_seq;
SELECT 'set add table ( set id = 1, origin = 1, id = ' ||
       nextval('sl_table_seq') ||
       ',\n   fully qualified name = ' ||
       quote_literal(n.nspname || '.' || r.relname) ||
       ', comment = ' ||
       quote_literal(COALESCE(d.description, '')) ||
       ')'
  FROM pg_class r
       LEFT JOIN pg_description d ON (r.oid = d.objoid)
     , pg_namespace n
 WHERE r.relnamespace = n.oid
   AND r.relkind = 'r'
   AND n.nspname NOT IN ('information_schema', 'pg_catalog', 'pg_toast');
DROP SEQUENCE sl_table_seq;