Marc Munro writes:
> but retrieving the constraint definition using pg_get_constraintdef(oid)
> gives me this:
> CHECK (((VALUE ~ '^\\d{4}$'::text) OR (VALUE ~ '^\\d{5}-\\d{4}$'::text)))
> How can I get the constraint definition with proper escaping from the
> catalog? Is there another functi
I am trying to recreate a domain definition from information in
pg_catalog and getting the following warnings:
WARNING: nonstandard use of \\ in a string literal
LINE 3: CHECK (((VALUE ~ '^\\d{4}$'::text) OR (VALUE ~ '^\\d{5}-\\...
^
HINT: Use the escape strin
