Топ-100
 
CerebroSQL

Schema domains in PostgreSQL database

Node displays information about domains in schema in PostgreSQL database

PostgreSQL domain list.jpg
Domain list
Pane

select d.domain_name,
       d.data_type,
       d.character_maximum_length,
       d.character_octet_length,
       d.character_set_catalog,
       d.character_set_schema,
       d.character_set_name,
       d.collation_catalog,
       d.collation_schema,
       d.collation_name,
       d.numeric_precision,
       d.numeric_precision_radix,
       d.numeric_scale,
       d.datetime_precision,
       d.interval_type,
       d.interval_precision,
       d.domain_default,
       d.udt_catalog,
       d.udt_schema,
       d.udt_name,
       d.scope_catalog,
       d.scope_schema,
       d.scope_name,
       d.maximum_cardinality,
       d.dtd_identifier
  from information_schema.domains d
where d.domain_schema = $$SCHEMANAME