select "ns"."nspname" as "schema", "cls"."relname" as "name", (select coalesce(json_agg(agg), '[]') from (select "att"."attname" as "name", "fk_att"."attname" as "fk_column", "fk_cls"."relname" as "fk_table", "fk_ns"."nspname" as "fk_schema", "tns"."nspname" as "datatype_schema", "typ"."typname" as "datatype", ("att"."attidentity" != '' or ("def"."adbin" is not null and pg_get_expr("def"."adbin", "def"."adrelid") like 'nextval(%')) as "autoinc", "att"."attgenerated" != '' as "computed", pg_get_expr("def"."adbin", "def"."adrelid") as "default", "att"."attnotnull" != true as "nullable", coalesce((select json_agg("enm"."enumlabel") as "o" from "pg_catalog"."pg_enum" as "enm" where "enm"."enumtypid" = "typ"."oid"), '[]') as "options", array_position("pk_con"."conkey", "att"."attnum") as "pk" from "pg_catalog"."pg_attribute" as "att" inner join "pg_catalog"."pg_type" as "typ" on "typ"."oid" = "att"."atttypid" inner join "pg_catalog"."pg_namespace" as "tns" on "tns"."oid" = "typ"."typnamespace" left join "pg_catalog"."pg_constraint" as "pk_con" on "pk_con"."contype" = 'p' and "pk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("pk_con"."conkey") left join "pg_catalog"."pg_constraint" as "fk_con" on "fk_con"."contype" = 'f' and "fk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("fk_con"."conkey") left join "pg_catalog"."pg_class" as "fk_cls" on "fk_cls"."oid" = "fk_con"."confrelid" left join "pg_cata
select "ns"."nspname" as "schema", "cls"."relname" as "name", (select coalesce(json_agg(agg), '[]') from (select "att"."attname" as "name", "fk_att"."attname" as "fk_column", "fk_cls"."relname" as "fk_table", "fk_ns"."nspname" as "fk_schema", "tns"."nspname" as "datatype_schema", "typ"."typname" as "datatype", ("att"."attidentity" != '' or ("def"."adbin" is not null and pg_get_expr("def"."adbin", "def"."adrelid") like 'nextval(%')) as "autoinc", "att"."attgenerated" != '' as "computed", pg_get_expr("def"."adbin", "def"."adrelid") as "default", "att"."attnotnull" != true as "nullable", coalesce((select json_agg("enm"."enumlabel") as "o" from "pg_catalog"."pg_enum" as "enm" where "enm"."enumtypid" = "typ"."oid"), '[]') as "options", array_position("pk_con"."conkey", "att"."attnum") as "pk" from "pg_catalog"."pg_attribute" as "att" inner join "pg_catalog"."pg_type" as "typ" on "typ"."oid" = "att"."atttypid" inner join "pg_catalog"."pg_namespace" as "tns" on "tns"."oid" = "typ"."typnamespace" left join "pg_catalog"."pg_constraint" as "pk_con" on "pk_con"."contype" = 'p' and "pk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("pk_con"."conkey") left join "pg_catalog"."pg_constraint" as "fk_con" on "fk_con"."contype" = 'f' and "fk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("fk_con"."conkey") left join "pg_catalog"."pg_class" as "fk_cls" on "fk_cls"."oid" = "fk_con"."confrelid" left join "pg_cata