Do you have experience working with PostgreSQL database management system?

Yes, I have experience working with PostgreSQL. I have used this DBMS for storing and processing data in several projects.

For example, I created tables using SQL queries, wrote complex queries with JOINs and aggregations, and also used indexes to optimize performance.

Additionally, I am familiar with setting up connections to PostgreSQL from Node.js using the pg library:

const { Client } = require('pg');
const client = new Client({
  user: 'user',
  host: 'localhost',
  database: 'mydb',
  password: 'password',
  port: 5432,
});

client.connect();

client.query('SELECT * FROM users;', (err, res) => {
  if (err) {
    console.error(err);
  } else {
    console.log(res.rows);
  }
  client.end();
});

I am also familiar with the basics of transactions and access rights management in PostgreSQL.