Using 'pgcrypt' inside node.js application

Question

Im wondering how i can use the pgcrypt extension inside my Node.js application to hash my passwords when i insert a user into the database. Might be a simple solution, but i cant figure out how to use theese PG extensions inside applications...

As an example this is my query to create an admin table, and insert an admin to the table. Now i would like to hash the password.

function createAdmin(){
    var usertypeid = null;
    const type = "adm";
    pool.query(`INSERT INTO usertype(type) VALUES ($1) RETURNING userTypeId;`, [type], function (error, results) {
        if (error){
            throw error;
        } else{
            usertypeid = results.rows[0].usertypeid;
            console.log(usertypeid);
            insertAdmin();
        }
    });

    function insertAdmin(){
        pool.query(`
                    INSERT INTO users(
                    usertypeid, userName, email, password)
                    VALUES($1, 'admin', '[email protected]', crypt('admin'), gen_salt('bf'));`, [usertypeid]);
    }
}

jjanes · Accepted Answer · 2020-04-21 15:04:58Z

1

VALUES($1, 'admin', '[email protected]', crypt('admin'), gen_salt('bf'))

It would be nice if you give us the error message.

crypt takes two arguments. You are calling with one, then passing the salt as an extra 5th column to an INSERT which needs exactly 4 columns. Adjust your parentheses.

VALUES($1, 'admin', '[email protected]', crypt('admin', gen_salt('bf')))

Also, using the default work factor for bf is probably too low, but that would be a separate issue.

answered Apr 21, 2020 at 15:04

jjanes

45k5 gold badges39 silver badges48 bronze badges

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

1 Comment

Lee Goddard Over a year ago

It would be nice if you told us why your final assertion holds true.

Collectives™ on Stack Overflow

Using 'pgcrypt' inside node.js application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related