In PostgreSQL—and by extension, YugabyteDB—there’s no native trigger that fires on SELECT statements. This means we can’t use a traditional AFTER SELECT […]
Read More
Tracking Last Login Time in YSQL
The log_connections parameter in YugabyteDB is a logging configuration option that records every connection attempt to the server to the PostgreSQL log file. […]
Read MoreKeep Track of Who Created a Table and When…
When a table is created in YSQL, the catalog does not store information about the user who created it or the time […]
Read MoreDisplay YSQL Database Size
The Postgres pg_database_size(name) built-in system function retunrs the disk space used by the database with the specified name. Although YugabyteDB is Postgres […]
Read MoreAudit Only a Particular User in YSQL
YugabyteDB YSQL has many cool built-in audit logging features. You can read about them on this doc page: Audit Logging For today’s tip […]
Read More