ng.
You can try pg_trgm extension [1].
Also we have a little demo web-site [2]. It uses pg_trgm. You can look at its
code [3].
1 - https://www.postgresql.org/docs/current/static/pgtrgm.html#idm4642863576
2 -
http://tsdemo.postgrespro.ru/search?pattern=Galaksy&order=rank&rank_func=ts_rank
3 - https
audit records this
> verbatim which runs afoul of our HIPAA requirement. Prepared statements are
> not an issue since pgaudit provides a way to suppress values.
>
I doubt that. But I'm not sure that I understood you correctly. What do
you mean by "mask"? Some additional examp
BLE or a VIEW with the tri-grams so that there is no need to
> create them each time the query runs?
>
As far as I know you can't do it nowadays. You can't create an trigram
column, as you can do it for FTS, you can create an tsvector column.
--
Arthur Zakirov
Postgres Profession
pgaudit/pgaudit#format
2 -
https://www.postgresql.org/docs/10/static/runtime-config-logging.html#guc-log-line-prefix
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
ways need to use operators instead. You can try <% operator and
pg_trgm.word_similarity_threshold variable:
=# SET pg_trgm.word_similarity_threshold TO 0.1;
=# SELECT name, popularity
FROM temp.items3_v
,(values ('some phrase'::text)) consts(input)
WHERE input <% name
On Wed, Sep 13, 2017 at 02:42:18PM +, Troy Hardin wrote:
> Putting either of these two lines in the .conf file cause it to fail to start.
Can you show error messages from logs?
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pg
search I
> can't find that file.
>
> Can someone please help?
You can execute the query:
=# select setting from pg_settings where name = 'hba_file';
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general m
chieve this?
>
Did you try pgaudit extension?
https://github.com/pgaudit/pgaudit
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mmand line. I debug them using dbg, but you can do it also from QtCreator.
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
