Re: Export data from a query ran by pgagent

On Thu, Nov 26, 2020 at 3:46 PM Gonzalo Rubio Casas < gonzalo.rubio.ca...@gmail.com> wrote: > Hi Dave, > > Thanks for your quick response, > > I'm afraid dumping the query results into another table is not possible as > the queried database is a read-only copy of our main database. > > I assume th

Re: Export data from a query ran by pgagent

Hi Dave, Thanks for your quick response, I'm afraid dumping the query results into another table is not possible as the queried database is a read-only copy of our main database. I assume there's no way to schedule remote shell script executions with pgAgent right? I didn't find anything on the

Re: Export data from a query ran by pgagent

Hi On Thu, Nov 26, 2020 at 2:42 PM Gonzalo Rubio Casas < gonzalo.rubio.ca...@gmail.com> wrote: > Hi everyone, > > I hope someone has an idea because I have been stuck with this for a > couple of days. I'm using pgagent to allow some users of my database to > schedule period *remote* queries that