How to get TRUE only in case of complete match of regular expression?

Question

PostgreSQL

`1111234325` ~ '\d' returns TRUE if there is at least one digit on the left side of the string

How can I make `1111234325` ~ (reg) return TRUE only if the string matches the regular expression completely, not partially? Ie

`1111234325` ~ '\d' -- FALSE
`1111234325` ~ '\d*' -- TRUE

How to wrap the regular expression for this behavior?

Answer 1

Specify the beginning and end of a string'/^\d$/'