psqlrc-file to clearly indicate difference between the staging and production postgres cluster instance

.psqlrc

-- psqlrc to clearly indicate difference between the staging and production postgres cluster instance

SHOW cluster_name
\gset

SELECT
  :'cluster_name' LIKE '%production%' AS is_production,
  :'cluster_name' LIKE '%staging%' AS is_staging
\gset

\if :is_production
    \set PROMPT1 '%[%033[1;93;41m%]%:cluster_name:%[%033[0m%] %n@%/%R%# '
\elif :is_staging
    \set PROMPT1 '%[%033[1;97;44m%]%:cluster_name:%[%033[0m%] %n@%/%R%# '
\else
    \set PROMPT1 '%:cluster_name: %n@%/%R%# '
\endif