TRIM

Removes the given characters (spaces by default) from the start, the end or both ends of a string.

PostgreSQL 17.9

TRIM([LEADING | TRAILING | BOTH] [characters] FROM string)

LEADING | TRAILING | BOTH: Side to remove the characters from, BOTH by default
KeywordOptional
LEADINGTRAILINGBOTH
characters: Set of characters to remove, a space by default
textOptional
FROM string: Source string
text

Return value

A string without the characters from characters on the chosen side

PostgreSQL 17.9

SELECT TRIM(
		BOTH 'x'
		FROM 'xTomx'
	);

btrim
Tom

PostgreSQL 17.9

SELECT TRIM(
		LEADING '0'
		FROM '000123'
	);

ltrim
123

PostgreSQL 17.9

SELECT '[' || TRIM('  SQL  ') || ']' AS trimmed;

trimmed
[SQL]

Characters are removed until a character outside the set is reached.