PostgreSQL›String Functions›TRIM
←LOWER

TRIMString Functions

BTRIM→

Removes leading and trailing spaces (or specified characters).

Syntax

TRIM([{BOTH|LEADING|TRAILING} c FROM] str)

Example

Enter values below to update the example in real time.

employees→
name→
UPDATE employees SET name = TRIM(name);