Experts in Postgres and Open Source Infrastructure

Welcome back to our Citus blog series! Previously, we introduced Citus, reviewed use cases, reviewed Citus structure, and installed Citus alongside PostgreSQL 14. This post will focus on configuring settings to make sure Citus is communicating between all instances.

To extract the day name from a specific date, you need to pass the date/timestamp as a first argument and a valid day format as the second argument to the “TO_CHAR()” function.

In PostgreSQL, the ORDER BY clause is used with the RANDOM() function to get the random data from large tables.

The ARRAY_AGG() function in Postgres is an aggregate function that takes a column as input and returns an array of values from all the rows in the specified group.

In Postgres, a time zone represents a region of the earth with a uniform standard time. Time zones allow us to convert local time to UTC or vice versa.

In Postgres, the NOW() and CURRENT_TIMESTAMP functions are used to fetch the current date and time with the time zone offset.

Postgres offers a DateTime function named LOCALTIME that retrieves the current time without a timezone. It may or may not accept an optional argument named “precision”.

In Postgres, the ILIKE operator performs the case-insensitive pattern matching on a string. Two wildcards are used to specify a pattern in ILIKE operator: an underscore “_” and a percent sign “%”.

PostgreSQL provides a Date function named CURRENT_DATE, which retrieves the current/today’s date. It retrieves the date in “YYYY-MM-DD” format.

PostgreSQL provides a built-in DateTime function named CURRENT_TIME that retrieves the current time with time zone offset.