DBeaver / ProgreSQL – Array Datatype

Background In our last post spoke of a little issue we experienced issuing a query against a PostgreSQL Instance. Issue The Issue is that our result set included an array column. array_agg Documentation Link SQL Output Troubleshooting Dbeaver Support Visited dbeaver support website @ Github. Here is the URL ( https://github.com/dbeaver/dbeaver/issues ) [ Link ] … Continue reading DBeaver / ProgreSQL – Array Datatype

PostgreSQL – SQL – Aggregate Functions – Day 01

Background Let us take a quick look at a couple of Aggregate functions available in PostgreSQL. DDL Region State DML Region State Query array_agg Code Output Output.DBeaver Output.Azure Data Studio array_to_string Code Output Output.DBeaver Output.Azure Data Studio Error Dbeaver Exception java.lang.NullPointerException Summary PostgreSQL offers solid tooling for SQL data aggregation. Unfortunate, Dbeaver throws an exception … Continue reading PostgreSQL – SQL – Aggregate Functions – Day 01