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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Gallamine 2002-12-13 20:03:58 formatting current_timestamp
Previous Message Chad Thompson 2002-12-13 01:08:18 Re: SQL help