View Filtered Rows technique
I am looking for a convenient way to search a specific table where a
specific column contains a string like this: "\2016\ \" (within the
quote-marks, but not including the quote-marks). I haven't found
anything in the documentation (8.4.5). I am using the View Data | View
Filtered Rows method. I was hoping there might be a 'CONTAINS' clause
that would do the trick. Any clues or help is appreciated.
Dale
On Sat, May 19, 2018 at 9:55 AM, Dale Seaburg <kg5lt@verizon.net> wrote:
I am looking for a convenient way to search a specific table where a
specific column contains a string like this: "\2016\ \" (within the
quote-marks, but not including the quote-marks). I haven't found anything
in the documentation (8.4.5). I am using the View Data | View Filtered
Rows method. I was hoping there might be a 'CONTAINS' clause that would do
the trick. Any clues or help is appreciated.
This sounds like a pgAdmin question and should be addressed to them.
https://www.pgadmin.org/support/list/
You should also be checking the pgAdmin docs, not PostgreSQL proper (the
version you indicate is an ancient and unsupported PostgreSQL release).
Using pure SQL you'd do something like:
col ~ '\\\d{6}\\\s+\\' (regular expression match operator)
depending upon what exactly you mean by "like this"...
David J.