Postgres and Open Source Experts

RPAD() or “right padding” is a built-in function in Postgres which fills a string of a specific length with a substring. It fills/pads the given string from the right side.

In PostgreSQL, the minus operator “-”, the EXTRACT(), and the AGE() functions are used to find the difference between the given timestamps.

PostgreSQL offers a built-in ANY() function that accepts an array as an argument, checks the presence of the given value in the array, and returns a Boolean true or false.

In Postgres, the comma-separated syntax is used in the ORDER BY clause to sort the table’s data based on multiple columns.

To get a month name from a date, specify the date/timestamp as the first and “MONTH” as the second argument to the TO_CHAR() function.

In PostgreSQL, the pg_size_pretty() function retrieves the size of the database object in a human-readable format, such as KB, MB, etc.

LPAD() or “left padding” is a built-in function in Postgres which fills a string of a specific length with a substring. It fills/pads the given string from the left side.

In Postgres, the RANDOM() is an in-built function that generates a random numeric value between “0(inclusive)” and “1(exclusive)” or between a specific range.

To format a timestamp, specify a timestamp and a valid format as arguments to the Postgres TO_CHAR() function.

Postgres allows us to set a TIMESTAMP as the column’s default value. For this purpose, the DEFAULT keyword is used with the column name at the time of table creation.