pg 8.11.3

Pg, or node-postgres, is a non-blocking PostgreSQL client for Node.js. It provides pure JavaScript and optional native libpq bindings, enabling developers to create efficient, low-latency applications. The pg package is built with key features like connection pooling, extensible JavaScript to PostgreSQL data-type coercion, and support for notable PostgreSQL features such as parameterized queries, named statements with query plan caching, asynchronous notifications with 'LISTEN/NOTIFY', and bulk import and export with 'COPY TO/COPY FROM'.

To use pg in your Node.js application, start by installing it from npm using the command npm install pg. Once the package is installed, you can use it to connect to your PostgreSQL database and perform various operations. Here is a simple example of connecting to a PostgreSQL database and running a query:

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

const client = new Client({
  user: 'db_user',
  host: 'database_server',
  database: 'database_name',
  password: 'db_password',
  port: 5432,
});

client.connect()
  .then(() => console.log('Connected'))
  .then(() => client.query('SELECT * FROM my_table'))
  .then(results => console.table(results.rows))
  .catch(e => console.log(e))
  .finally(() => client.end())

Remember to replace 'db_user', 'database_server', 'database_name', and 'db_password' with your actual database credentials.

The complete and detailed documentation for node-postgres can be found at the official website https://node-postgres.com. This documentation provides a comprehensive guide on the pg package's API, different supported features, usage examples, and troubleshooting guides. You can also find additional resources on the project's GitHub wiki.