btrim(s [, t]): Returns character string s : btrim « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. btrim

btrim(s [, t]): Returns character string s


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=#








Related examples in the same category

1.Remove the longest string consisting only of bytes in bytes from the start and
2.btrim('123example 332', '123')