Relative Content

Tag Archive for regexdatabasepostgresql

end of string not working with regexp_matches() in PostgreSQL

I have a table in a PostgreSQL DB and I am trying to extract a substring with a certain pattern from a string as a result of extracting specific data from a jsonb column. The string of interest is extracted by using the following command (I include all the details in case of some side-effect that I didn’t notice):