Re: Find and Replace All - Mailing list pgsql-novice

From
Subject Re: Find and Replace All
Date
Msg-id 20060316211002.81736.qmail@web33309.mail.mud.yahoo.com
Whole thread Raw
In response to Find and Replace All  (chelsea boot <scx6148@yahoo.co.uk>)
Responses Re: Find and Replace All  (chelsea boot <scx6148@yahoo.co.uk>)
List pgsql-novice
> 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
tables.

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
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: chelsea boot
Date:
Subject: Find and Replace All
Next
From: Michael Guerin
Date:
Subject: Re: ESTERROR