> insert into RealTable select uname, timestamp(abstime(timeinAsInt4)), > duration, etc from TempTable; Another side comment: afaik an explicit conversion to abstime is not required to go from Unix time to timestamp. So insert into RealTable select uname, timestamp(timeinAsInt4), duration, etc from TempTable; should be equivalent. - Thomas
- [GENERAL] Importing data w/ Unix timestamp brianb-pggeneral
- Re: [GENERAL] Importing data w/ Unix timestamp brianb-pggeneral
- Re: [GENERAL] Importing data w/ Unix timestamp Tom Lane
- Thomas Lockhart