[KLUG Members] Postgres SQL query

[Andrew Eidson]

Ok.. I am stuck. 

I have a Postgres sql database with well over 200 tables. Almost every table
has a datetime field in it. When I pull the data from the old MS SQL
database and import it through a utility that was created for me it shifts
the dates back 1 hour which causes all sorts of havoc.. The people who
developed the utility think it is a jdbc issue but have no idea how to
correct it. Is there a query that can find all the datetime type fields in a
database and then advance that field 1 hour? I can do it table by table but
was wondering if someone has more elegant way to do everything at once in
their memory banks. If not I guess I will be working late the next coupld of
days to get this fixed.. Otherwise thanks in advance. 

Andrew Eidson,Support Analyst
Midwest Educational Group
5466 Holiday Terrace
Kalamazoo, MI 49009
1-888-416-4333
Fax: 1-269-372-4150
Support at meglink.com
 
Visit our website at www.meglink.com