In the YugabyteDB’s YCQL API, DDL security statements are instructions for managing and restricting operations on the database objects. Examples: Create, grant, […]
Read MoreReduce a Table’s VARCHAR Size in YSQL
There might come a time where you’ll want to shrink the size of a VARCHAR field in a table. Example: yugabyte=# d […]
Read MoreStore Key-Value Pairs in a Single Value with HSTORE
The Postgres extension hstore implements a new data type (HSTORE) for storing key-value pairs in a single value. The hstore data type […]
Read MoreAccess Data In An External File Like a Database Table
If you have some data sitting in an external file and would like to use it in your database queries, you can […]
Read MoreSimplify String Literals with Dollar-Quoted String Literals in YSQL
The standard syntax for specifying string literals can be difficult to understand. To allow more readable queries in such situations, YugabyteDB’s YSQL […]
Read More