A developer on a client’s team opened two terminal tabs, one for staging and one for production. He meant to clean up an old test copy, typed the command in the wrong tab, and pressed Enter. Within a second, a production database with eight months of order history was gone. The team had backups, but … Read more >>

A new analyst needs a PostgreSQL login, an app password is due for rotation, or nobody remembers the postgres password. Each case comes down to how you set a user password, and it’s one statement. Quick answer: run ALTER ROLE user_name WITH PASSWORD ‘new_password’; as a superuser or a CREATEROLE role. To create the user … Read more >>

In this PostgreSQL tutorial, we will learn about “PostgreSQL Installation on Linux” with how to solve the error when installing PostgreSQL. Additionally, we will delve into the steps to create a new user, and database, and grant privileges within PostgreSQL. Step 1: Update the System Packages Before installing any new software, it’s essential to update … Read more >>

In this PostgreSQL tutorial, we are diving into the realm of database management by demonstrating how to install PostgreSQL on a Windows operating system. Download and Install PostgreSQL on Windows To download and install PostgreSQL on Windows, follow the below steps. Step 1: Download PostgreSQL From the official PostgreSQL website, first download the Windows installer. … Read more >>

You connect to a PostgreSQL database by giving psql four details: the host, the port, a user name and the database name. On my Windows machine that’s psql -h localhost -p 5432 -U postgres -d dfq_pgconnect, and you’re in. In this tutorial, I’ll set up one working login and reuse it every way you’ll need … Read more >>

In this PostgreSQL tutorial, we will study the usage of the PostgreSQL subquery that will allow us to create queries within the query. And we are going to discuss the following list of topics. PostgreSQL subquery In PostgreSQL, A query is a question or a request for information expressed. A subquery is a query within … Read more >>

Need PostgreSQL to repeat a step for each number in a range, each row of a query or each item in an array? A FOR loop does that, but it lives in PL/pgSQL, so it runs inside a DO block, a function or a procedure. Plain SQL doesn’t have a loop statement, which trips up … Read more >>