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 Table Size in YSQL
You can display the size of a YSQL table via the pg_table_size function. Example: yugabyte=# CREATE TABLE test (c1 INT); CREATE TABLE […]
Read MoreGenerate a Random UUID in YSQL
The UUID data type represents Universally Unique Identifiers (UUIDs). A UUID is a sequence of 32 hexadecimal digits separated by hyphens (8 digits […]
Read MoreCreate Tables in YCQL with Distributed Transactions Enabled by Default
The transactions property of the CREATE TABLE command in YCQL specifies if distributed transactions are enabled in the table. This property defaults to […]
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 More