HI All,
I have a dataset (90GBs worth) that contains 3 columns of unix timestamps in seconds. Ideally, I want to use copy to load the data into the DB (the disk i/o of trying to process this volume of data vi perl takes a couple of days). I was hoping to convert the unix timestamps inside the DB to pg timestamp creating a view or create table as… however no success so far. The “to_timestamp()” function works fine to convert the data but for some reason I can’t get it to work in creating a view with the fields that are timestamps instead of INT.
Thoughts?
Thx!
-dimitrius
"Without passion ... what's the point?"