Executes an arbitrary query and return the row results

Execute an arbitrary query on a PostgreSQL resource, more at: https://www.windmill.dev/docs/getting_started/scripts_quickstart/sql

Execute an arbitrary query on a PostgreSQL resource, more at: https://www.windmill.dev/docs/getting_started/scripts_quickstart/sql

example on how to run a sql against a database that needs a ca certificate

Connect to a postgresql database using parameters you specify within the script. Print the results of the query to the console.

This script uses pg_dumpall to dump your database into a single .sql file, gzip it and send to a S3 bucket. It also performs backup rotation to keep at least n latest versions of your choice.