Introduction to PostgreSQL RTRIM() function

TheRTRIM() function allows you to remove specified characters from the end of a string.

Here’s the syntax of theRTRIM() function:

RTRIM(string,character)

In this syntax:

• string is the input string that you want to remove characters
• character specifies the character you want to remove from the end of the string. Thecharacter parameter is optional and defaults to space.

TheRTRIM() function returns the string with all trailing characters removed.

To remove both leading and trailing characters from a string, you use theTRIM() function.

To remove all the leading characters from a string, you use theLTRIM() function.

PostgreSQL RTRIM() function examples

Let’s explore some examples of using theRTRIM() function.

1) Basic PostgreSQL RTRIM() function example

The following example uses theRTRIM() function to remove the character! from the end of the stringpostgres!!!:

SELECT RTRIM('postgres!!!','!');

Output:

rtrim---------- postgres(1 row)

2) Using the PostgreSQL RTRIM() function to remove leading spaces

The following example uses theRTRIM() function to remove all the spaces from the end of the string'PostgreSQL ':

SELECT RTRIM('PostgreSQL   ');

Output:

rtrim------------ PostgreSQL(1 row)

Because the default of the second argument of theRTRIM() function is space, you don’t need to explicitly specify it.

3) Using the RTRIM() function with table data example

First,create a new table calledtweets andinsert some rows into it:

CREATE TABLE tweets(   idSERIAL PRIMARY KEY,   tweetVARCHAR(120)NOT NULL);INSERT INTO tweets(tweet)VALUES   ('PostgreSQL tutorial   '),   ('PostgreSQL RTRIM() function   ')RETURNING*;

Output:

id |             tweet----+--------------------------------  1 | PostgreSQL tutorial  2 | PostgreSQL RTRIM() function(2 rows)INSERT 0 2

Second,update the tweets by removing the trailing spaces using theRTRIM() function:

UPDATE tweetsSET tweet= RTRIM(tweet);

Output:

UPDATE 2

The output indicates that two rows were updated.

Third, verify the updates:

SELECT * FROM tweets;

Output:

id |            tweet----+-----------------------------  1 | PostgreSQL tutorial  2 | PostgreSQL RTRIM() function(2 rows)

Summary

• UseRTRIM() function to remove all specified characters from the end of a string.

Last updated onJanuary 27, 2024

On this page

• Introduction to PostgreSQL RTRIM() function
• PostgreSQL RTRIM() function examples
• Summary