When exporting data to a file in YSQL I avoid using printable characters (commas, new-lines, pipe symbols, etc.) as field/record separators because […]
Read More
Display User Friendly Text for NULL Values
By default YSQL will display NULL as an empty string which makes it impossible to distinguish NULL from a true empty string […]
Read MoreClearing the Screen in YSQL
Lots of old school folks (like myself) use YSQL for administrative tasks. As you enter commands, eventually the command prompt will end […]
Read MoreGenerate a Random Date Between Two Dates
As we learned in several earlier tips, we can create a random integer and a random string in YugabyteDB quite easily. But […]
Read More