The EXPLAIN statement allows you to obtain the query execution plan generated by YSQL for a given SQL statement. The EXPLAIN command has a […]
Read MoreMove data from one table to another table in a single step
If you need to move data rows from one table to another table, you’d probably immediately consider an INSERT followed by a […]
Read MoreGenerate a Random String
Whenever you are populating table columns with dummy data you’ll probably need to generate some random strings. This is very easy in […]
Read MoreGenerate a Random Integer
In YSQL there is the familiar built-in function named RANDOM which generates a random value between 0 (inclusive) and 1 (exclusive). Although […]
Read MoreDisplay YugabyteDB version
When running a plethora of YugabyteDB universes, you might forget which version of YugabyteDB is running on the particular cluster on which […]
Read More