In PostgreSQL, tablespaces allow administrators to specify where on a disk specific tables and indexes should reside based on how users want […]
Read More
Limit 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 MoreUpdate Current Rows When Adding a Column with a Default
A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read More