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?"
