Tag: search-path

Truncate if exists in psql function and call function

plpgsql postgresql search-path sql truncate

I have the following code to create a function that truncates all rows from the table web_channel2 if the table is not empty: create or replace function truncate_if_exists(tablename text) returns void …

How to use % operator from the extension pg_trgm?

pattern-matching postgresql search-path sql

I have my pg_trgm module installed. The schema set is extensions. To use it I have to run something like this select: I’m trying to run a statement using the % operator and got the following message. What is necessary to run % or <-> operators? Answer Most probably the problem is with the search_p…