PostgreSQL: rtrim Function

In this PostgreSQL post explains how to use the PostgreSQL rtrim function with syntax and examples.

Description

The PostgreSQL rtrim function removes all specified characters from the right-hand side of a string.

Syntax

The syntax for the rtrim function in PostgreSQL is:

rtrim( string, trim_character )

Parameters or Arguments

string

The string to trim from the right-hand side.

trim_character

The set of characters that will be removed from the right-hand side of string. If this parameter is omitted, the rtrim function will remove space characters from the right-hand side of string.

Applies To

The rtrim function can be used in the following versions of PostgreSQL:

• PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4

Example

Let's look at some PostgreSQL rtrim function examples and explore how to use the rtrim function in PostgreSQL.

For example:

(Please note that for each of the example results below, we have included single quotes around the result to demonstrate what the rtrim function returns in PostgreSQL. If you ran these commands yourself, you would not see the single quotes in the result):

postgres=# SELECT rtrim('  AODBA.com  ', ' ');
       rtrim
----------------------

 '  AODBA.com'
(1 row)


postgres=# SELECT rtrim('AODBA.com    ');
      rtrim
--------------------

 'AODBA.com'
(1 row)

postgres=# SELECT rtrim('123000', '0');
 rtrim
-------

 '123'
(1 row)