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 MoreGlobal Variables in YSQL
There are a lot of configuration parameters in YSQL that affect the behavior of the Yugabyte database system. The SHOW command in […]
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 MoreColumn Level Public-Key Encryption in YSQL
The YugabyteDB YSQL API supports column-level encryption via the Postgres extension called pgcrypto. The pgcrypto module in PostgreSQL is a powerful tool […]
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