In PostgreSQL-compatible databases like YugabyteDB, object resolution—whether for functions, tables, or types—relies on the search_path setting. If an object (like a function) […]
Read More
Lists Functions Created by an Extension
We learned in a previous tip that we can ENABLE ORACLE’S COMPATIBILITY FUNCTIONS AND PACKAGES IN YSQL. That’s awesome! But what are […]
Read MoreAutomatically Create PG Extensions in all new Databases
PostgreSQL extensions provide a way to extend the functionality of a database by bundling SQL objects into a package and using them […]
Read MoreLoad pg_stat_monitor when YugabyteDB starts
pg_stat_monitor is a Query Performance Monitoring tool for PostgreSQL and supported in YugabyteDB. It collects performance statistics and provides query performance insights […]
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