Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997


This is the Education section of the Command Prompt Website. Here you will find blogs specifically about how to use Postgres and related technologies.

Contact us today for all your Postgres and Open Source consulting and support needs.

A Comprehensive Guide on PostgreSQL SCHEMA

Postgres offers various built-in commands, such as CREATE SCHEMA, ALTER SCHEMA, and DROP SCHEMA, to create, modify, and drop the Postgres schemas.

How to Reset Forgotten Password For postgres User

To reset a forgotten password for a “postgres” user > open the “pg_hba.config” file located at “C:\Program Files\PostgreSQL\15\data”, and replace the local connections with “trust”.

How to Create User, Create Database, Grant Privileges in PostgreSQL

Execute the “GRANT ALL PRIVILEGES” command to grant all the database privileges to the user, such as creating a database, dropping a database, etc.

How to Update an Array in PostgreSQL

PostgreSQL allows us to update an already existing array using the “UPDATE SET” statement. Specify the array index with the array name to update only a specific element of an array.

How to Uninstall PostgreSQL From Windows

To uninstall Postgres from windows, open control panel > go to programs and features > locate PostgreSQL > Uninstall the PostgreSQL.

How to Subtract Minutes From a Time in PostgreSQL

In PostgreSQL, the “-” operator is used to subtract minutes from the current or specific DateTime values. Where the DateTime value can be a date, interval, time, or timestamp.

How to Use RPAD() Function in PostgreSQL

RPAD() or “right padding” is a built-in function in Postgres which fills a string of a specific length with a substring. It fills/pads the given string from the right side.

How to Find Difference Between Two TIMESTAMPS in PostgreSQL

In PostgreSQL, the minus operator “-”, the EXTRACT(), and the AGE() functions are used to find the difference between the given timestamps.

How to Check if PostgreSQL Array Contains a Value

PostgreSQL offers a built-in ANY() function that accepts an array as an argument, checks the presence of the given value in the array, and returns a Boolean true or false.

How to Sort Multiple Columns Using ORDER BY Clause in PostgreSQL

In Postgres, the comma-separated syntax is used in the ORDER BY clause to sort the table’s data based on multiple columns.