postgres-aws-s3 icon indicating copy to clipboard operation
postgres-aws-s3 copied to clipboard

How to remove the file from S3 after import

Open pguser4ever opened this issue 2 years ago • 0 comments

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

pguser4ever avatar Sep 18 '21 15:09 pguser4ever