Shell scripting is a powerful and versatile tool for working with databases and SQL. It can help you automate tasks, manipulate data, […]
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 MoreGenerate a Random Timestamp Between Two Timestamps (Faster Method)
In the previous tip GENERATE A RANDOM TIMESTAMP BETWEEN TWO TIMESTAMPS, we learned how to create a function to do just that. […]
Read MoreGENERATE 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 More