On Nov 14, 2016 12:53, "valeriof" <valerio_farrug...@hotmail.com> wrote: > > Hi, > I'm handling a TimestampTz value inside a plugin to stream WAL changes to a > .NET client application. What I'm trying to do is to return all possible > column changes as binary (don't like to have Postgres handle the conversion > to string as I may need to have access to the bytes at the client level). In > case of a TimestampTz, is it possible to return the 8-bytes long integer and > then from the C# application convert the value to Ticks?
Npgsql supports the binary COPY protocol. Their implementation is here: https://github.com/npgsql/npgsql/blob/dev/src/Npgsql/TypeHandlers/DateTimeHandlers/TimeStampHandler.cs