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