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.

SYSDATE Equivalent in PostgreSQL

In PostgreSQL, there is no SYSDATE function. However, PostgreSQL provides different functions that are equivalent to the SYSDATE function.

How to Uninstall PostgreSQL From Ubuntu

To uninstall Postgres from your Ubuntu operating system, open the terminal and run the “sudo apt remove postgresql postgresql-contrib” command.

How to Check Column Types in PostgreSQL

In PostgreSQL, the SELECT statement, information_schema, \d command, and pg_typeof() function are used to check the data type of a column.

How to Add or Drop NOT NULL Constraints in PostgreSQL

In PostgreSQL, a table column created with a NOT NULL constraint accepts only non-null values. It can be added when creating a new or altering an existing table.

How to Change Database OWNER in PostgreSQL

In PostgreSQL, the ALTER DATABASE command is used with the collaboration of the OWNER TO clause to change the database owner.

How to Install PostgreSQL on macOS

Postgres is becoming increasingly popular every day due to its stunning features. This post explained how to download, install, and use Postgres on macOS.

How to Install PostgreSQL Database on Ubuntu

To install PostgreSQL on your Ubuntu operating system, run the “sudo apt install postgresql postgresql -contrib” command.

How to Insert or Delete Multiple Rows in PostgreSQL

Use the INSERT query with comma-separated syntax to insert multiple rows into a Postgres table. To delete multiple rows, use the DELETE statement with IN clause.

psycopg: PostgreSQL Python Connector

psycopg is a Postgres Python connector that allows Python programs to access Postgres databases. It is used to perform various operations on Postgres database via python.

What Does ILIKE Operator Do in PostgreSQL?

In PostgreSQL, the “ILIKE” operator is used to fetch/query the data based on pattern matching. The ILIKE operator queries the data case-insensitively.