Node.js - TypeError: Client is not a constructor

Question

I am trying the following:

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

  console.log(Client);

  const client = new Client({
      user: 'Username censored',
      host: 'Host censored',
      database: 'gisuebung',
      password: 'Passworded censored',
      port: 5432,
  });
  
  client.connect();

When I run this however, I get the following Error: Error in v-on handler: "TypeError: Client is not a constructor"

I wrote this after a snippet I found online and it seems everywhere I look people did the exact same thing. Can anyone tell me what I am doing wrong?

Not enough informaiton. It can be a number of different things though, the likeliest would be a version issue i.e., pg dependency. Look into the version your using, as this seems to be a common issue version 2.0 ~ — TheoNeUpKID
– TheoNeUpKID, Commented Oct 23, 2020 at 17:03
It worked well for me so try to check your dependencies or change your const name from client to something like pgClient to check if is not an issue with the destructuring — RamiroP
– RamiroP, Commented Oct 23, 2020 at 17:11

Sebastian · Accepted Answer · 2024-11-13 15:33:38Z

12

This is a JS error:

Try this, it worked for me:

const { Client } = require('pg'); 
// or
const Client = require('pg').Client;

-- ES module:

import pg from 'pg';
const Client = pg.Client;

edited Nov 13, 2024 at 15:33

Sebastian

1,56515 silver badges23 bronze badges

answered Nov 23, 2021 at 14:36

rawa08

1351 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Drazisil Over a year ago

The missing piece here is the ESM part.

Schlueter Over a year ago

These aren't equivalent, the first sets Client twice.

Sandre · Accepted Answer · 2022-11-19 08:45:38Z

1

Your code fine for CommonJS. But for ESM this error will raise.

Correct way to run in ESM:

import pg from 'pg'

const client = new pg.Client(config.dbConfig)

answered Nov 19, 2022 at 8:45

Sandre

8361 gold badge10 silver badges13 bronze badges

Comments

Leandro Laurindo · Accepted Answer · 2022-05-20 01:09:46Z

-1

Try this, it worked for me:

const { Client } = require('pg');
const client = new Client({
 user: "postgres",
 database: "databasename",
 port: 5432,
 host: "localhost",
 password: "yourpassword",
 ssl: false
});


client.connect();
client.query("select * from cad_client")
     .then(results => {
         const result = results.rows
         console.log(result)
     })
     .finally(() => client.end())

answered May 20, 2022 at 1:09

Leandro Laurindo

1

Collectives™ on Stack Overflow

Node.js - TypeError: Client is not a constructor

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related