A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read MoreFind All Table Columns Storing Some Value
A long time ago a database developer asked me how she could produce a list of all table columns in the database […]
Read MoreEnforce Uniqueness Across Partitions (Option 2)
In a previous tip we learned that Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables […]
Read MoreDisplay the Source Table for each Row of a Partitioned Table
Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables to improve performance. In the following […]
Read MoreList Installed Postgres Extensions
PostgreSQL extensions provide a way to extend the functionality of a database by bundling SQL objects into a package and using them […]
Read More