postgres=# -- btrim(s [, t]): Returns character string s, trimmed on the left and right
of any substrings consisting solely of letters in character string t
(or whitespace, if t is not specified)
postgres=#
postgres=# SELECT btrim(' whitespace example ') AS trim_blanks;
trim_blanks
--------------------
whitespace example
(1 row)
postgres=#
postgres=#