Postgres and Open Source Experts

TO_NUMBER() is used to convert a character string to a number. The TO_NUMBER() function accepts two parameters, a “string” and a “format”.

In PostgreSQL, the BOOLEAN or BOOL data type takes only 1 byte to store a value in a database, and it returns one of two probable values: True or False.

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.