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