How can I use several pgsql queries in the aws_s3.query_export_to_s3 function?

edit

You can use the awss3.queryexporttos3 function to execute several pgsql queries by concatenating them using the ';' separator.

For example, if you want to execute two queries, you can do it as follows:

SELECT * FROM table1; SELECT * FROM table2;

The above query will first execute the SELECT statement on table1 and then execute the SELECT statement on table2. Both these query outputs will be exported to the S3 bucket specified in the queryexportto_s3 function.