PostgreSQL: execute plpgsql block

do
$$
begin
raise notice 'merde';
end
$$;

PostgreSQL: any (values) syntax

select ht_sim_profile_mno.*
from resource_db.ht_sim_profile_mno join resource_db.dt_host_mno using (host_mno_id)
where host_mno_name = any (values ('MBQT'), ('ORANGE'));

PostgreSQL: setup pgbouncer on CentOS

https://opensourcedbms.com/dbms/setup-pgbouncer-connection-pooling-for-postgresql-on-centosredhatfedora/

PostgreSQL: Materialized View Strategies

https://hashrocket.com/blog/posts/materialized-view-strategies-using-postgresql

PostgreSQL: Pattern matching with LIKE, SIMILAR TO or regular expressions

http://dba.stackexchange.com/questions/10694/pattern-matching-with-like-similar-to-or-regular-expressions-in-postgresql