aws_s3

pig build pkg aws_s3;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install aws_s3;		# install via package name, for the active PG version

pig install aws_s3 -v 18;   # install for PG 18
pig install aws_s3 -v 17;   # install for PG 17
pig install aws_s3 -v 16;   # install for PG 16
pig install aws_s3 -v 15;   # install for PG 15
pig install aws_s3 -v 14;   # install for PG 14

CREATE EXTENSION aws_s3;

SET aws_s3.access_key_id TO 'your_access_key';
SET aws_s3.secret_key TO 'your_secret_key';
SET aws_s3.session_token TO 'optional_session_token';  -- if using temporary credentials

SET aws_s3.endpoint_url TO 'http://localhost:4566';

CREATE EXTENSION aws_s3;

CREATE TABLE animals (
  name text,
  age int
);

SELECT aws_s3.table_import_from_s3(
  'animals',
  '',
  '(FORMAT CSV, DELIMITER '','', HEADER true)',
  'my-bucket',
  'animals.csv',
  'us-east-1'
);

SELECT * FROM animals;

SELECT * FROM aws_s3.query_export_to_s3(
  'SELECT * FROM animals',
  'my-bucket',
  'export/animals.csv',
  'us-east-1',
  options := 'FORMAT CSV, HEADER true'
);