Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997


Professional Postgres and Open Source support

Command Prompt, Inc., is the oldest Postgres Company in North America and one of the oldest Open Source firms still operating today. We serve our clients with best in class expertise and professionalism. You can read more about support and services here:

You have landed at the largest single source of Postgres education blogs in the world. At Command Prompt, we believe deeply that the education of the community is critical to the continued success of Postgres and related technologies. We hope you find content you are looking for and don't hesitate to Contact us today for all your Postgres and Open Source consulting and support needs.


In Postgres, the CURRENT_TIMESTAMP retrieves the date and time along with the time zone, while the LOCALTIMESTAMP function retrieves the date and time without the time zone.

PostgreSQL TO_TIMESTAMP() Function With Examples

In PostgreSQL, the TO_TIMESTAMP() is a built-in function that accepts a string and a format and converts the given string to a TIMESTAMP based on the specified format.

PostgreSQL INTERSECT Operator With Examples

In PostgreSQL, the INTERSECT operator combines the result set of at least two queries. The INTERSECT operator retrieves only common records from the targeted tables.

Export a PostgreSQL Table to a CSV File

In PostgreSQL, there are multiple ways to export a table into a CSV file, such as the COPY statement or the \COPY command.

PostgreSQL IF Statement With Examples

If statement executes only those expressions that satisfy the specified condition. Otherwise the control will be moved to the next statement.

PostgreSQL UNNEST() Function With Examples

PostgreSQL provides a built-in function named UNNEST() that accepts an array as an argument and expands the given array into a set of rows.

PostgreSQL UNIQUE Constraint With Examples

Sometimes we have to store the unique records in a table, such as an email address, employee id, etc. To achieve this purpose, the “UNIQUE” constraint is used in PostgreSQL. The UNIQUE constraint allows us to store the unique rows/records in a table.

This post will explain the working of the UNIQUE constraint through practical examples. So, let’s begin.

How Does UNIQUE Constraint Work in PostgreSQL?

Each time when you …

PostgreSQL CAST Operator- How to Convert One Data Type to Another

PostgreSQL offers a CAST operator that takes an expression and a data type and converts the given expression into the specified data type.

PostgreSQL Drop if Exists VS Drop

The DROP command throws an error if a table to be dropped doesn’t exist while “DROP IF EXISTS” shows a notice instead of throwing an error.

Understanding PostgreSQL Arrays

PostgreSQL allows us to define a table’s column as an array of any built-in data type, user-defined data type, or enumerated data type.