I need to transfer a microsecond timestamp into a table by using the COPY command.
My approach using a normal INSERT, where
X is a timestamp (since 1.1.1970) in microseconds, looked like this:
TO_TIMESTAMP( X ::double precision / 100000)
X of 1484579365136360 would translate to
1/16/2017, 4:09:25.136360 PM.
How could I do the same with the COPY command?
I expect I need to convert the timestamp before issuing the COPY command, but in what format?