select 'ALTER TABLE ' || table_name || ' ALTER ' || column_name || ' TYPE TIMESTAMP WITH TIME ZONE;' As command from information_schema.columns where table_schema ='public' and data_type ='timestamp without time zone';
