# PostgreSQL node Queue value

**URL:** <https://discourse.nodered.org/t/postgresql-node-queue-value/79792>\
**Category:** General\
**Tags:** database\
**Created:** [13 July 2023 13:38 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792 "2023-07-13T13:38:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samokomo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/samokomo/32/63918_2.png) [@Samokomo](https://discourse.nodered.org/u/Samokomo)\
**Post date:** [13 July 2023 13:38 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792/1 "2023-07-13T13:38:20Z")

</div>

Hello guys, how to access value of Queue of postgres node?  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/b/1b9dba719ff601865929af680cc12e9e3fc8e375.png)

Or maybe a better question, how to batch import the data into postgres in nodered (array of objects) ?

Thanks!

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [13 July 2023 13:59 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792/2 "2023-07-13T13:59:10Z")

</div>

Have you tried the status node, it may pick it up.

---

<div class="post-metadata">

**Author:** ![Samokomo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/samokomo/32/63918_2.png) [@Samokomo](https://discourse.nodered.org/u/Samokomo)\
**Post date:** [14 July 2023 08:28 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792/3 "2023-07-14T08:28:20Z")

</div>

Thanks for advice,  
I solved the problem via going into:

/home/ubuntu/.node-red/node\_modules/node-red-contrib-postgresql  
Open file postgresql.js  
and before the line  
send(msg);

I added:  
msg.queue = nbQueue;

Now every postgresSQL gives desired info in msg.queue.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [14 July 2023 08:43 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792/4 "2023-07-14T08:43:42Z")

</div>

Or, instead of hacking the code (which you will lose if the node is ever updated), you could use a `status` node (like @E1cid suggested)?

Better still, you could raise a pull request against the repository so that everyone benefits?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [12 September 2023 08:43 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792/5 "2023-09-12T08:43:44Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.