Re: View Filtered Rows technique

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: View Filtered Rows technique
Дата
Msg-id CAKFQuwYc6-9kFJefOxgvJddFnx-hu7gkidhAMZ+qLD2+KT_x5A@mail.gmail.com
обсуждение исходный текст
Ответ на View Filtered Rows technique  (Dale Seaburg <kg5lt@verizon.net>)
Список pgsql-general
Дерево обсуждения
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Dale Seaburg
Дата:
Сообщение: View Filtered Rows technique
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres=# VACUUM FULL pg_statistic => ERROR: missing chunk number 0 for toast value .. in pg_toast_2619