Need help with bytea data type from PostgreSQL.

[rikki cattermole via Digitalmars-d-learn]

On 12/04/2016 11:48 PM, Suliman wrote:
>
> I am still trying to get work any of PostgreSQL drivers. For last few
> day I had test all of drivers. All of them are _very_ buggy!
> Just few of them have support of `bytea` data type, that use for binary
> blobs. But support does not mean that it's work.
>
> Now I am trying to get https://github.com/IrenejMarc/dpq work.
>
> ```
> import std.stdio;
> import dpq.connection;
> import dpq.query;
> import dpq.attributes;
> import dpq.result;
> import dpq.value;
>
> void main()
> {
>
>      auto conn = Connection("host=localhost dbname=test01 user=postgres
> password='Infinity8'");
>
>      string myq = `SELECT userblob FROM "USERS"`;
>      auto q = Query(myq);
>      Result r = q.run();
>
>      ubyte [] x;
>
>      foreach(row; r)
>      {
>          //x = row[0];
>          writeln(row[0]); // need as!binary or so.
>          readln;
>      }
> }
> ````
>
> By docs binary data type should work, but I can't find way to set it's
> type. For examples for strings its doing like: .as!string
>
> But what about binary? I have read sources and found place that can be
> sutable for it, but I do not know how to use it.
> https://github.com/IrenejMarc/dpq/blob/6a5acc805a891b5cdab3f333fbae692aca042f5a/source/dpq/value.d#L237
>
>
> But I have not ideas how to use it.

Have you tried .as!(ubyte[]); ?