We can use the RETURNING clause to return values from the rows that were deleted using a bulk-delete statement! yugabyte=# CREATE TABLE […]
Read MoreExport Data to a File Using YSQL (the Safe Way)
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 MoreList Docker Containers Used by Yugabyte Platform
Yugabyte Platform is a containerized application that is installed and managed using Replicated for mission-critical environments (for example, production, performance, or failure mode testing). […]
Read MoreDisplay 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 More