wariosantos/postgres_aws_s3 repository overview

CREATE EXTENSION plpython3u;
CREATE EXTENSION aws_s3;

CREATE TABLE public.download_file (
    id          serial primary key,
    code        varchar,
    name        varchar,
    status      varchar,
);

SET aws_s3.endpoint_url TO 'http://minio:9000';

SELECT aws_s3.table_import_from_s3(
               'download_file',
               'code,name,status',
               '(FORMAT CSV, DELIMITER ",", HEADER true)',
               ('database_name', 'sample.csv', ''),
               ('ACESSKEY', 'SECRETKEY', '')
       );