To display an up to date “current” row count of a table, we can run the classic SELECT COUNT(*) statement. Example: yugabyte=# […]
Read More
Enable Oracle’s Compatibility Functions and Packages in YSQL
Are you migrating from Oracle to YugabyteDB? If so, Orafce is a very useful PostgreSQL Extension that allows you to implement some […]
Read MoreTurn Your Table Data into JSON
We learned in a previous tip how to export data into a file. Now let’s see how we can first convert the […]
Read MoreDisplay Node Start Times
The pg_postmaster_start_time() function returns the start time of the server where you execute it. Example: But your YugabyteDB database is most likely […]
Read MoreGenerate a Random Date Between Two Dates
As we learned in several earlier tips, we can create a random integer and a random string in YugabyteDB quite easily. But […]
Read More