After executing a query in YSQL it’s not obvious what are the underlying data types of the columns returned in the result […]
Read MoreComposite Data Types
A composite type represents the structure of a row or record; it is essentially just a list of field names and their data […]
Read MoreExtract Array Elements Into Rows
YugabyteDB allows columns of a table to be defined as variable-length multidimensional arrays. The UNNEST() function can be used later to expand […]
Read MoreGet an Estimated Table Row Count
To display an up to date “current” row count of a table, we can run the classic SELECT COUNT(*) statement. Example: yugabyte=# […]
Read MoreEnable Oracle’s Compatibility Functions and Packages in YSQL
Are you migrating from Oracle to YugabyteDB? If so, Orafce is a very useful PostgreSQL Extension that allows you to implement some […]
Read More