1 2 3 4CREATE DOMAIN public.colordomain 5 AS text 6 COLLATE pg_catalog."default" 7 CONSTRAINT domainconstraint CHECK (VALUE = ANY (ARRAY['red'::text, 'green'::text, 'blue'::text])); 8 9CREATE DOMAIN qgis_test.colordomain 10 AS text 11 COLLATE pg_catalog."default" 12 CONSTRAINT domainconstraint CHECK (VALUE = ANY (ARRAY['yellow'::text, 'cyan'::text, 'magenta'::text])); 13 14CREATE DOMAIN qgis_test.flowerdomain 15 AS text 16 COLLATE pg_catalog."default" 17 CONSTRAINT domainconstraint CHECK (VALUE = ANY (ARRAY['Alchemilla'::text, 'Alstroemeria'::text, 'Alyssum'::text])); 18 19CREATE TABLE qgis_test.colors 20( 21id SERIAL NOT NULL, 22color_public colordomain, 23color_qgis qgis_test.colordomain, 24flower qgis_test.flowerdomain 25) 26