PostgreSQL extension functionality allows for bundling multiple SQL objects together in a single package that can be loaded or removed from your database. […]
Read More
Add a Record to the Begining of an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal format. […]
Read MoreAppend a Record to an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal […]
Read MoreDiscover Data Types for Columns in a Result Set
After executing a query in YSQL it’s not obvious what are the underlying data types of the columns returned in the result […]
Read More