Try
Home   >   mailing lists

Re: Removing terminal period from varchar string in table column - Mailing list pgsql-general

From Rich Shepard
Subject Re: Removing terminal period from varchar string in table column
Date
Msg-id 512c9d0-442d-5bb4-bd26-6b7d222c8235@appl-ecosys.com
Whole thread Raw
In response to Re: Removing terminal period from varchar string in table column  (Jeff Ross <jross@openvistas.net>)
List pgsql-general
Tree view 
On Tue, 15 Jul 2025, Jeff Ross wrote:

> How about
>
> test:
>     select company_name, replace(company_name,'.','') from companies;
>
> update:
>     update companies set company_name = replace(company_name,'.','') where 
> company_name like '%.';

Jeff,

These contain the table and column names I didn't see in web page examples.
Using update looks better to me.

Many thanks,

Rich

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Removing terminal period from varchar string in table column
Next
From: "DINESH NAIR"
Date:
Subject: Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication