Postgresql – Set DOMAIN for existing column
I have an existing table like this: CREATE TABLE public.data ( id integer, name text, sell_value real) ); and I define a domain as: CREATE DOMAIN dataDomain AS TEXT CHECK(name = ANY ('{joe, john, jack}'::text[])); How can I apply the…