Turn data from PostgreSQL to JavaScript variables

Question

I have the following code:

    const result = await client.query("select pword from users where username like '" + ln + "';");
    console.log(result.rows)

which sends following to the terminal: [ { pword: '00' } ]

Is there a way for me to extract '00', and store it in a variable? I am using Node JS and Express.

This might help: developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/… — xehpuk
– xehpuk, Commented Dec 2, 2020 at 18:57

infecting · Accepted Answer · 2020-12-02 19:00:55Z

1

The postgres query is returning an array. To access the contents of this array you are going to get the first index by doing result[0]. Next you are going to access the variable in the object nested by the array using dot notation. So your final will be result[0].pword

you can store this in a variable by doing

var foo = result[0].pword

it looks like you could use some information about arrays and how to use them. Here are some relevant docs

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array https://www.w3schools.com/js/js_arrays.asp

answered Dec 2, 2020 at 19:00

infecting

7737 silver badges12 bronze badges

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

Comments

Aalexander · Accepted Answer · 2020-12-02 19:02:27Z

0

You can get it by this

result.rows[0].pword

answered Dec 2, 2020 at 19:02

Aalexander

4,9843 gold badges13 silver badges37 bronze badges

Collectives™ on Stack Overflow

Turn data from PostgreSQL to JavaScript variables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related