Skip site navigation (1) Skip section navigation (2)

Re: Finding and replacing text within records

From: Andrew Chambers <andychambers2002(at)yahoo(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Finding and replacing text within records
Date: 2006-01-18 00:41:52
Message-ID: 20060118004152.GA25166@yapgi (view raw or flat)
Thread:
Lists: pgsql-novice
On 17:09 Tue 17 Jan     , Lynna Landstreet wrote:
> Hello,
> 
> I'm wondering if there is a way in SQL to find and replace a specific string
> within various database records, the way you might across a text document.
> Not to replace the entire value of the fields in which the string is found,
> but just that specific string.

http://www.postgresql.org/docs/8.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP

[snip]

> So is there a way to search out all occurrences of, say,
> the string "testsite.mydomain.com" within a specific column and change
> it to "www.theirdomain.com" wherever it's found?

regexp_replace(field, 'testsite\.mydomain\.com', 'www\.theirdomain\.com' [,flags])

Regards,
Andy

In response to

pgsql-novice by date

Next:From: s anwarDate: 2006-01-18 01:23:56
Subject: Re: alter table set tablespace over nfs getting stuck
Previous:From: Tom LaneDate: 2006-01-17 22:53:52
Subject: Re: alter table set tablespace over nfs getting stuck

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group