PostgreSQL›String Functions›BTRIM
←TRIM

BTRIMString Functions

REPLACE→

Removes specified characters from both ends of a string.

Syntax

BTRIM(str [, chars])

Example

Enter values below to update the example in real time.

trimmed→
SELECT BTRIM('   hello   ') AS trimmed;