Conexión de NestJS a Postgres con Node Postgres

npm i pg 
npm i @types/pg -D

// src/app.module.ts

import { Client } from 'pg';

const client = new Client({
  user: 'root',
  host: 'localhost',
  database: 'my_db',
  password: '123456',
  port: 5432,
});

client.connect();
client.query('SELECT * FROM tasks', (err, res) => {
  console.error(err);
  console.log(res.rows);
});