Postgres and Open Source Experts

24x7x365 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.

Check Database Size and Table Size in PostgreSQL Using pgAdmin

In PostgreSQL, built-in functions like pg_relation_size(), pg_database_size(), pg_size_pretty(), etc. are used to get the size of the table or database.

How to Check Current Version, Database, Schema, and User in PostgreSQL

In Postgres, the VERSION(), CURRENT_DATABASE(), CURRENT_SCHEMA, and CURRENT_USER, functions are used to get the current version, database, schema, and user.

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.