postgres-aws-s3
postgres-aws-s3 copied to clipboard
Error while export using aws_s3.query_export_to_s3 function.
Hello! I'm just trying to use your aws_s3 extention.
When runing this query
SELECT * FROM aws_s3.query_export_to_s3(
query => '
select
json_agg(post_main_approved)
from asmo.post_main_approved
limit 10 ;
',
bucket => 'arn:aws:s3:::asmo-ij-json',
file_path => 'test.json',
region => 'eu-central-1a',
access_key => '<access_key>',
secret_key => '<secret_key>'
);
then get this error:
error fetching next item from iterator. spiexceptions.SyntaxError: syntax error at or near ";"
Can you help to deal with this issue? Thanks!