| 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: | Whole Thread | Raw Message | 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.
| 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 |