Re: [PATCH] Implement motd for PostgreSQL

On Fri, Apr 2, 2021, at 22:59, Chapman Flack wrote:

Thanks for the bug report.

Fixed by properly escaping backslackes:

ALTER SYSTEM SET motd TO E'\u001B[94m'

'\n   ____  ______  ___  '

'\n  /    )/      \\/   \\ '

'\n (     / __    _\\    )'

'\n  \\    (/ o)  ( o)   )'

'\n   \\_  (_  )   \\ )  / '

'\n     \\  /\\_/    \\)_/  '

'\n      \\/  //|  |\\\\    '

'\n          v |  | v    '

'\n            \\__/      '

'\u001b[0m';

I've deployed the fix to production:

$ psql -U brad -h pit.org motd

NOTICE:

   ____  ______  ___

  /    )/      \/   \

(     / __    _\    )

  \    (/ o)  ( o)   )

   \_  (_  )   \ )  /

     \  /\_/    \)_/

      \/  //|  |\\

          v |  | v

            \__/

psql (14devel)

SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)

Type "help" for help.

motd=> \q

/Joel