[Libpqxx-general] [libpqxx-general] using tablewriter with binary data

[JT Olds]

Peter, Jeroen,
 Last year there was some discussion of getting tablewriters to be able
to write BYTEA data, but it sounds like this effort didn't ever happen.
As far as I can tell, discussion centered around that the current
tablewriter API was insufficient for dealing with the BYTEA/VARCHAR
escaping distinction.

Did anything happen here? I totally need this feature.

Thanks
-JT


> > Was this issue resolved?
> 
> Not yet, due to lazyness or lack of time on my part, depending on
> your 
> definition.
>
> The fundamental problem is that, as far as I can tell, there is just
> no way to 
> escape data in a way which will work for both binary data in a bytea
> column 
> AND for data in a varchar (and other types of) columns.
>
> Either I am missing something (I'll ask on -hackers or some such
> eventually), 
> or pqxx will need some API to distinguish between non-binary and
> binary 
> column types with the tablewriter.
> I promised to come up with something here, and I still intend to, but
> I 
> haven't gotten to it yet.