Re: View Filtered Rows technique

On Sat, May 19, 2018 at 9:55 AM, Dale Seaburg <kg5lt(at)verizon(dot)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.