View Filtered Rows technique

From: Dale Seaburg <kg5lt(at)verizon(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: View Filtered Rows technique
Date: 2018-05-19 16:55:36
Message-ID: 1f5606e9-c3e7-2d19-98b7-45171017ea9e@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-05-19 17:01:18 Re: View Filtered Rows technique
Previous Message Justin Pryzby 2018-05-19 16:35:28 Re: postgres=# VACUUM FULL pg_statistic => ERROR: missing chunk number 0 for toast value .. in pg_toast_2619