Bill Morrow <wmorrow(at)home(dot)com> writes:
> I have an integer column which holds a time represented
> as the number of seconds since 1970/01/01 00:00 UTC. I want to
> view this table with the time converted to an understandable text string.
Casting to abstime should do it; from there you might want to convert
to timestamp so you can invoke to_char, if you don't like the default
display format.
Next time, try representing the column as a date/time datatype in the
first place ;-)
regards, tom lane