Pivoting a the rows of a query’s result set into columns is magically simple using YSQLSH, YugabyteDB’s YSQL command line interface. The […]
Read More
Wildcard Search to Display YSQL Run-Time Control Parameters
YSQL configuration parameters play an important role in optimizing and enhancing database performance. The YSQL SHOW command allows inspection of the current […]
Read MoreYSQL Function to Determine Data Type of Text
YSQL inherits from Postgres the built-in function pg_typeof function which returns the OID of the data type of the value that is […]
Read MoreRepeatedly Run a Query Every X Seconds
The YSQLSH client includes a watch meta-command that repeatedly executes a query every n seconds. This is a handy feature if you […]
Read MoreUsing an Emoji in Place of NULL in YSQL
The pset meta-command in ysqlsh can be used to display an alternative value for NULL, which shows up as blank by default. […]
Read More