The Primary Key constraint is a means to uniquely identify a specific row in a table via one or more columns. To […]
Read More
Add a Record to the Begining of an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal format. […]
Read MoreAppend a Record to an Array in a JSONB Column
YSQL supports the JSONB data type which stores a parsed representation of a JavaScript Object Notation (JSON) document hierarchy of subvalues in an appropriate internal […]
Read MoreInsert Multiple Rows In One Statement
Need to insert a bunch of rows? No problem, you can do it in a single INSERT SQL statement in YugabyteDB! yugabyte=# […]
Read MoreDelete and Return Deleted Information
We can use the RETURNING clause to return values from the rows that were deleted using a bulk-delete statement! yugabyte=# CREATE TABLE […]
Read More