Топ-100
top of page
Волнистый абстрактный фон
CerebroSQL

Schema domains in PostgreSQL database

Node displays information about domains in schema in PostgreSQL database

PostgreSQL domain list
Domain list

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

bottom of page