PostgreSQL extensions provide a way to extend the functionality of a database by bundling SQL objects into a package and using them […]
Read More
Generate 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 MoreColumn Level Public-Key Encryption in YSQL
The YugabyteDB YSQL API supports column-level encryption via the Postgres extension called pgcrypto. The pgcrypto module in PostgreSQL is a powerful tool […]
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 More