Postgres and Open Source Experts

To alter column’s type in PostgreSQL, use the “SET DATA TYPE” or “TYPE” keyword with the ALTER TABLE and ALTER COLUMN commands.

DATE_PART() function in PostgreSQL is used to extract/retrieve a specific part(like a month, year, hour, minutes, etc.) from a TIMESTAMP/Source.

In PostgreSQL, the NOW() and CURRENT_DATE functions are used with the collaboration of the TO_CHAR() function to get the current date in a specific format.

PostgreSQL supports the DATE data type that stores the date values in YYYY-MM-DD format. PostgreSQL utilizes 4 bytes to store a date value in the storage.

In PostgreSQL, the CURRENT_DATE function is used to fetch the current date. To get the current date minus 1 day, we must subtract “1” from the CURRENT_DATE

In PostgreSQL, built-in functions like pg_database_size(), and pg_relation_size() are used to get the database and table size respectively.

PostgreSQL offers multiple functions to get the current date and time with or without the time zone, such as NOW(), CURRENT_TIMESTAMP, LOCALTIMESTAMP, etc.

PostgreSQL provides two wildcards: percent % and underscore _ that are used with the aid of the LIKE operator to perform pattern matching.

In PostgreSQL, the DATE_TRUNC() function trims unnecessary values from the date and time and returns a result with specific precision.

The REPLACE() is a very convenient function that is used to search and replace all the appearances of a string with a new substring/text.