Connect with NodeJS

This example connects to PostgreSQL® service from NodeJS, making use of the pg package.

Variables

These are the placeholders you will need to replace in the code sample:

Variable	Description
USER	PostgreSQL username, from the service overview page
PASSWORD	PostgreSQL password, from the service overview page
HOST	Hostname for PostgreSQL connection, from the service overview page
PORT	Port for PostgreSQL connection, from the service overview page
DATABASE	Database Name for PostgreSQL connection, from the service overview page

Pre-requisites

For this example you will need:

• The npm pg package:

  npm install pg --save
  

• Download CA certificates from the service overview page, this example assumes it is in a local file called ca.pem.

Code

Add the following to index.js and replace the connection parameters with the ones from the service overview page:

const fs = require("fs");
const pg = require("pg");

const config = {
  user: "USER",
  password: "PASSWORD",
  host: "HOST",
  port: "PORT",
  database: "DATABASE",
  ssl: {
    rejectUnauthorized: true,
    ca: fs.readFileSync("./ca.pem").toString(),
  },
};

const client = new pg.Client(config);
client.connect(function (err) {
  if (err) throw err;
  client.query("SELECT VERSION()", [], function (err, result) {
    if (err) throw err;

    console.log(result.rows[0]);
    client.end(function (err) {
      if (err) throw err;
    });
  });
});

This code creates a PostgreSQL client and opens a connection to the database. Then runs a query checking the database version and prints the response.

To run the code:

node index.js

If the script runs successfully, the outputs should be the PostgreSQL version running in your service like:

PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc, a 68c5366192 p 6520304dc1, 64-bit