Re: Removing terminal period from varchar string in table column

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2025-07-15T17:59:27Z
Lists: pgsql-general
On Tue, 15 Jul 2025, Thom Brown wrote:

> There are various options, but perhaps just use rtrim.
> rtrim(company_name, '.')

Thom,

I looked at rtrim() but didn't see where to specify the table name. Would it
be `select * from table companies rtrim(company_name, '.')'?

Thanks,

Rich