In the previous tip GENERATE A RANDOM TIMESTAMP BETWEEN TWO TIMESTAMPS, we learned how to create a function to do just that. […]
Read More
GENERATE A RANDOM STRING (FASTER METHOD)
In the previous tip GENERATE A RANDOM STRING, we learned how to create a function to do just that. In that version […]
Read MoreSet a Default Tablespace for a Database
In PostgreSQL, tablespaces allow administrators to specify where on a disk specific tables and indexes should reside based on how users want […]
Read MoreLimit Access to Table Columns
In YugabyteDB’s YSQL api, securing columns from users or providing access to only a limited set of columns can be implemented via […]
Read MoreAdd a Unique Key to a Materialized View
Materialized views in YSQL are relations that persist the results of a query. They can be created using the CREATE MATERIALIZED VIEW […]
Read More