Postgres and Open Source Experts

BIGINT is a numeric data type in PostgreSQL that stores the integer values. It stores a value between -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807.

In PostgreSQL, the CASCADE option is used with the DROP TABLE command to drop/delete a table along with its dependent objects.

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.