PostgreSQL :- Datatypes

Background Datatypes is one of key building blocks of a database system. Common Ones Here are the some of the common ones in PostgreSQL. Bool Values true false Character pg_catalog::name Internal Type for Object Names 64 bytes Character information_schema::sql_identifier ANSI Compatible Char Fixed Length Varchar Variable Length text Variable Length unlimited in size Datetime Date … Continue reading PostgreSQL :- Datatypes

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