ysqlsh is the shell for interacting with the YugabyteDB YSQL API. To connect to a database, you need the following information: the […]
Read MoreDon’t forget to upgrade the YSQL system catalog
YugabyteDB stores YSQL system metadata, referred to as the YSQL system catalog, in special tables. The metadata includes information about tables, columns, […]
Read MoreMove Data from One Table to Another Table in One Command
You can move data from one table to another in two SQL commands, an INSERT followed by a DELETE. But it’s possible […]
Read MoreAdd Columns to a View in YSQL
In YSQL, a view is the result set of a stored query, which can be queried in the same manner as a […]
Read MoreTrack User Defined Function Execution Counts and Runtimes
In YSQL we can track function call counts and time used by enabling the track_functions parameter. The default is none, but you can […]
Read More