
November 22nd, 2012, 02:00 PM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 2
Time spent in forums: 33 m 13 sec
Reputation Power: 0
|
|
|
Changing Dates in entire DB
Anybody have a method to change all the Dates in an entire Postgres database?
I have a DB full of data for some demo software. It contains a year's worth of data. I have to manually go thru each year and find every date column and add a year to all dates to keep the demo data current.
Is there an automated way to just check all the tables for any date fields and then add 1 year to every date?
|