Name: | domains |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
domain_catalog | sql_identifier | -1 |
|
domain_schema | sql_identifier | -1 |
|
domain_name | sql_identifier | -1 |
|
data_type | character_data | -1 |
|
character_maximum_length | cardinal_number | -1 |
|
character_octet_length | cardinal_number | -1 |
|
character_set_catalog | sql_identifier | -1 |
|
character_set_schema | sql_identifier | -1 |
|
character_set_name | sql_identifier | -1 |
|
collation_catalog | sql_identifier | -1 |
|
collation_schema | sql_identifier | -1 |
|
collation_name | sql_identifier | -1 |
|
numeric_precision | cardinal_number | -1 |
|
numeric_precision_radix | cardinal_number | -1 |
|
numeric_scale | cardinal_number | -1 |
|
datetime_precision | cardinal_number | -1 |
|
interval_type | character_data | -1 |
|
interval_precision | character_data | -1 |
|
domain_default | character_data | -1 |
|
udt_catalog | sql_identifier | -1 |
|
udt_schema | sql_identifier | -1 |
|
udt_name | sql_identifier | -1 |
|
scope_catalog | sql_identifier | -1 |
|
scope_schema | sql_identifier | -1 |
|
scope_name | sql_identifier | -1 |
|
maximum_cardinality | cardinal_number | -1 |
|
dtd_identifier | sql_identifier | -1 |
CREATE VIEW domains AS
SELECT (current_database())::sql_identifier AS domain_catalog, (nt.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(t.typbasetype, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (_pg_char_max_length(t.typbasetype, t.typtypmod))::cardinal_number AS character_maximum_length, (_pg_char_octet_length(t.typbasetype, t.typtypmod))::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (_pg_numeric_precision(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_precision, (_pg_numeric_precision_radix(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_precision_radix, (_pg_numeric_scale(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_scale, (_pg_datetime_precision(t.typbasetype, t.typtypmod))::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (t.typdefault)::character_data AS domain_default, (current_database())::sql_identifier AS udt_catalog, (nbt.nspname)::sql_identifier AS udt_schema, (bt.typname)::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (1)::sql_identifier AS dtd_identifier FROM pg_type t, pg_namespace nt, pg_type bt, pg_namespace nbt WHERE ((((t.typnamespace = nt.oid) AND (t.typbasetype = bt.oid)) AND (bt.typnamespace = nbt.oid)) AND (t.typtype = 'd'::"char"));
ALTER TABLE information_schema.domains OWNER TO postgres;
See Also
List of views