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 MoreInsert Multiple Rows In One Statement
Need to insert a bunch of rows? No problem, you can do it in a single INSERT SQL statement in YugabyteDB! yugabyte=# […]
Read MoreDelete and Return Deleted Information
We can use the RETURNING clause to return values from the rows that were deleted using a bulk-delete statement! yugabyte=# CREATE TABLE […]
Read More