Retrieve inserted row using pg-promise npm module in Express.js

Question

I am inserting a user row into Postgres from Express.js like as follows:

db.none("INSERT INTO users (email, password) VALUES (${incoming.email}, crypt(${incoming.password}, gen_salt('bf')))",{
    incoming: { email: qemail, password: qpwd}
  }
).then(function (data) {
  // data is null
});

The email and password come from the query parameters on the React.js frontend. I use this query for the signup action on my application and wanted to know if I could get this newly added user back from this same query. I just felt that making another get request right after the signup to get the user info was inefficient, which I do for my login action. Thanks in advance.

vitaly-t · Accepted Answer · 2020-04-17 21:55:39Z

1

Append RETURNING * to your query, and replace none with method one.

const row = await db.one("INSERT INTO users(email, password) VALUES(${incoming.email}, 
                          crypt(${incoming.password}, gen_salt('bf'))) RETURNING *",
    {
        incoming: { email: qemail, password: qpwd}
    }
);

// row = the newly inserted row

answered Apr 17, 2020 at 21:55

vitaly-t

26.1k17 gold badges129 silver badges151 bronze badges

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

1 Comment

Sanjiv Pradhanang Over a year ago

Thank you! Worked like a charm!

Benz Stevox · Accepted Answer · 2020-04-17 21:28:29Z

1

At the end of the query add RETURNING *. This should return the newly added query. (postgresql docs).

In your query:

"INSERT INTO users (
    email, password
  ) VALUES (
    ${incoming.email}, crypt(${incoming.password}, gen_salt('bf'))
  ) RETURNING *"

answered Apr 17, 2020 at 21:28

Benz Stevox

1621 silver badge9 bronze badges

1 Comment

Sanjiv Pradhanang Over a year ago

Thanks. Sorry I had to pick the other one as the answer due to more detail! I appreciate it!

Collectives™ on Stack Overflow

Retrieve inserted row using pg-promise npm module in Express.js

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related