nodejs connect postgresql database

nodejspostgresql

To connect to a PostgreSQL database from a Node.js application, you will need to install the pg module and then use it to create a client for connecting to the database.

Here is an example of how you can do this:

const { Client } = require('pg');

const client = new Client({
  host: 'localhost',
  port: 5432,
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

client.connect((error) => {
  if (error) {
    console.error(error);
    return;
  }

  console.log('Connected to the database');
});

Once you have connected to the database, you can use the client to execute SQL queries and perform other database operations.