On 4 November 2013 19:18, Victor Tan <victortcs@xxxxxxxxx> wrote: > BI tools all generate SQL with varying levels of optimization. However, do > any of you know of any BI tools that are more PostgreSQL aware in that they > can generate queries that take advantage of extensions like hstore, arrays > etc? > > Hstore and JSON data types use non-standard syntax within PostgreSQL - not > that I know of anything in the SQL standards that say how to handle KV types > in the style of hstore. > Which BI tools, if any, either are aware of PostgreSQL in this way or at > least minimize hindrances to using these types of data types or extensions? Probably the same number as support SQLSwerver sparse columns, MiSQL equivalents and Mogno BSON. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
