list_table.sql 541 B

12345678910111213
  1. create view list_table(table_name, table_comment, create_time, update_time) as
  2. SELECT c.relname AS table_name,
  3. obj_description(c.oid) AS table_comment,
  4. CURRENT_TIMESTAMP AS create_time,
  5. CURRENT_TIMESTAMP AS update_time
  6. FROM pg_class c
  7. LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
  8. WHERE (c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"]))
  9. AND c.relname !~~ 'spatial_%'::text AND n.nspname = 'public'::name AND n.nspname <> ''::name;
  10. alter table list_table
  11. owner to postgres;