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

Re: Find and Replace All

From: chelsea boot <scx6148(at)yahoo(dot)co(dot)uk>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Find and Replace All
Date: 2006-03-17 13:25:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Thanks - I've used PGAdmin to update the tables before but as there is a few of them I wanted to save time.  I was looking at the UPDATE command but didn't know how to (1) select only part of a field to update eg. update d:\upkeep\jones to r:\upkeep\jones and (2) search all columns and all tables.  Am I looking at the right command?
  My postgres crash problem is on Win2K.  Any ideas?

operationsengineer1(at)yahoo(dot)com wrote:
  > Hi
> Is there a way to update multiple tables with the
> same information? A kind of MS "find and replace
> all" utility. I want to change the drive letter of
> a filepath that is listed in one or more columns of
> several tables.
> Thanks

i'm no expert, but i'll bite. yes, you could do that
if you set up a program to run the SQL on all the

it would probably be easier to just run the SQL on the
individual tables, though. i'd use pgadminIII.

do you need help with the SQL?

ps - is your pgsql crash problem on winxp?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 

To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.

In response to


pgsql-novice by date

Next:From: Sean DavisDate: 2006-03-17 13:31:36
Subject: Re: Find and Replace All
Previous:From: Tom LaneDate: 2006-03-17 05:40:15
Subject: Re: Alter View foo?

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