Postgres and Open Source Experts

Execute the “sudo systemctl status postgresql” command to check the PostgreSQL service status on your Linux (Ubuntu) operating system.

Run the “\s” command from psql to get query history. To check the query history using pgAdmin, open the “query tool” and navigate to the “Query History” tab.

Postgres offers different built-in array functions that are used with the UPDATE command to modify an array, such as ARRAY_PREPEND(), ARRAY_REMOVE(), ARRAY_CAT(), etc.

In PostgreSQL, the INNER JOIN is used to get the matching results from two or more tables based on a specific join condition.

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.

In Postgres, the VERSION(), CURRENT_DATABASE(), CURRENT_SCHEMA, and CURRENT_USER, functions are used to get the current version, database, schema, and 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”.

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

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.

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