How to execute sql query in nodejs and output result to file?

Question

PostgreSQL

Good time of the day. I have a SQL file available which, when executed in pgadmin, produces the result as a CSV. In the file, before executing the request, I replace two variables date_start and date_end and execute it, as a result I get data that is saved to a csv file. How can you make it so that when you open the page and enter the start and end dates there, and by pressing the execute button, the user receives the desired file with the result of the request?

Answer 1

You need to display the data on the page) Well, how to do this, there are enough options. Through web sockets for example.