Node DOMAINS for PostgreSQL
[EN]
The node displays information about domains in a schema in a PostgreSQL database
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
[RU]
Узел отображает информацию о доменах в схеме в базе данных PostgreSQL
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_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