#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    4
    Rep 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?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    4
    Rep Power
    0
    How about an automated way to go thru each table to find the date fields, regardless of table name or field name?

IMN logo majestic logo threadwatch logo seochat tools logo