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

search and replace

From: "Gallamine" <iam(at)gallamine(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: search and replace
Date: 2002-12-13 20:01:35
Message-ID: 007301c2a2e2$7614d2e0$b6e9fea9@anywhere.ncsu.edu (view raw or flat)
Thread:
Lists: pgsql-novice
I have a database with text in it (articles) and in the article I have <img>
tags for pictures in HTML. I want to go through the DB and replace the urls
of the images. How would I go about doing that? I want to grab all the text
from the articles table and replace the string "http://dopey.lulupress.com"
with "http://faramir/".
Any hints?
-William

[ GoRobotics.net | RobotGeeks.com | RobotDirectory.org ]
Amateur robotics for the masses. Enter the world of robotics
------------------------------------------------------------
"...God maintains a delicate balance between keeping his 
existence sufficiently evident so people will know He's there
and yet hiding his presence enough so that people who
want to choose to ignore him can do it "
 - J.P. Moreland PH.D.
----------------------------------------------------------------
Carpe Aeternum - Seize Eternity


Responses

pgsql-novice by date

Next:From: GallamineDate: 2002-12-13 20:03:58
Subject: formatting current_timestamp
Previous:From: Chad ThompsonDate: 2002-12-13 01:08:18
Subject: Re: SQL help

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