UPDATE "file_id" SET "download_filename" = '-'and so on. It took two mornings to finish.
WHERE "filename" ~~ 'SV_MS%'
AND "filename" not like '%MSANTAN%'
UPDATE "file_id" SET "download_filename" =
REPLACE(download_filename,'_RAVI_', '_')
WHERE "filename" ~~ 'MBV%RAVI%'
and filename not like '%ARAVIND%'
and filename not like '%KULA%'
Mostly work related stuff which I would've entered into my "Log book". Instead of hosting it on an intranet site, outsourcing the hosting to blogger!
Wednesday, October 10, 2007
sql queries for find-replace
Running some sql queries on our pgsql db like
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment