postgres-aws-s3
postgres-aws-s3 copied to clipboard
How to remove the file from S3 after import
Hi have a question, don't know could be something i missed but anyway
like to use postgres copy command to export/import data to RDS from outside RDS so aws-s3 extension looks great
so let's say we on a regular bases call a job using aws-s3 export function to export data from a number of tables in csv format to s3 storage (using federated dblinks outside RDS ) then import csv files using aws-s3 import function.
Fine but how to clean up s3 storage and remove the csv files from s3 after file import?
kind of missing a delete function to remove the file from s3 after import to RDS
We have a similar setup today using a plsh function to make OS calls and works great but guess not supported in RDS