Return a table from a function

From: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Return a table from a function
Date: 2021-04-06 16:52:21
Message-ID: b6uFTyH937VOq3XGPT7xAS9Po7-3kwphF834W8eNTl4od008FNoSKn7HPlQnUooaVdk0t1ATa3b6PxJFh3pqF87VTLNJ82VTUXhMkjEqsAs=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I've written a function that returns a table. It works fine and I get the expected results. The only problem is that in Node.js which is the client the table data is a string rather than a list of variables. Is there some way to change the return data so it is still like a table but in something like JSON? Or even better is there a way to return it as the individual rows so that each column can be easily accessed? I'm using pg-promise to access PostgreSQL from a Node.js web application.

Simon.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2021-04-07 08:44:08 Re: Return a table from a function
Previous Message Peter Wright 2021-04-02 19:24:16 Restricting certain users from accessing PUBLIC resources