Postgres Pro
Downloads
Home   >   mailing lists

View Filtered Rows technique - Mailing list pgsql-general

From Dale Seaburg
Subject View Filtered Rows technique
Date
Msg-id 1f5606e9-c3e7-2d19-98b7-45171017ea9e@verizon.net
Whole thread Raw
Responses Re: View Filtered Rows technique  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: postgres=# VACUUM FULL pg_statistic => ERROR: missing chunknumber 0 for toast value .. in pg_toast_2619
Next
From: "David G. Johnston"
Date:
Subject: Re: View Filtered Rows technique