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 MoreThe 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 MoreNeed to insert a bunch of rows? No problem, you can do it in a single INSERT SQL statement in YugabyteDB! yugabyte=# […]
Read MoreWe can use the RETURNING clause to return values from the rows that were deleted using a bulk-delete statement! yugabyte=# CREATE TABLE […]
Read MoreWhen exporting data to a file in YSQL I avoid using printable characters (commas, new-lines, pipe symbols, etc.) as field/record separators because […]
Read MoreBy default YSQL will display NULL as an empty string which makes it impossible to distinguish NULL from a true empty string […]
Read More