| From: | "Dimitrius Weddington" <dimitrius(dot)r(dot)weddington(at)marvell(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | how to covert a column? |
| Date: | 2007-07-02 21:53:47 |
| Message-ID: | AB9FA2A1B69C9740B198A7369F4D1AA10699BDF2@SC-EXCH01.marvell.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Postgres User | 2007-07-02 22:36:20 | General search problem - challenge |
| Previous Message | Simon Riggs | 2007-07-02 20:57:16 | Re: recovery_target_time ignored orrecoveryalwaysrecovers to end of WAL |