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