Postgres and Open Source Experts

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.

In PostgreSQL, the LENGTH() function is used to find the length of a string. It takes a string as a parameter and returns the total number of characters.

PostgreSQL provides several ways to describe a table. For example, the “\d” command, “\dt” command, and information_schema.

In PostgreSQL, the DELETE statement is used with the collaboration of the WHERE clause and IN operator to delete multiple rows from a table.

The INSERT INTO statement is used to insert single or multiple rows into a table. To insert multiple rows in a table, the comma-separated syntax is used.

PostgreSQL provides a FETCH clause that is used to fetch/retrieve a part of rows returned by any query. It performs the same functionality as the LIMIT clause.

PostgreSQL provides several methods for truncating a specific table. The TRUNCATE TABLE command is one of them. It can be executed from the psql and pgAdmin.