Tablespaces in YugabyteDB provide a way to control how and where data is stored across a distributed cluster. By defining tablespaces with […]
Read More
Audit Selects on a Table to an Audit Table Using RLS
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 MoreTracking 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 More