Columns that have a SERIAL data type are auto-incremented. YugabyteDB supports SMALLSERIAL, SERIAL, and BIGSERIAL which are short notation for sequences of […]
Read More
Display Query Results in a Crosstab-like Representation in YSQLSH
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 MoreWildcard 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 More