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