Re: Importing data w/ Unix timestamp - Mailing list pgsql-general

> 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