Hi all,
I am having a stored function in plperlU which is called from php script then. It select data from a table, export them to a file and zips the file. The problem is that it should store this file into temporary table. Then it should return some identificator to php, so that the user can download it via php. Problem is that postgreSQL doesn't supports server-side large object operations for non superuser roles.
Can someone please give me a suggestion how can I solve this problem. I mean if I can import the file some other way or if there are some other usual procedures how to do this?
Thanks in advance,
Lukas Houf