No description
Find a file
Frederic Aidouni 6a73d324bc readme
2020-05-04 11:45:50 +02:00
s3_csv_multicorn limit removed 2020-05-04 10:41:31 +02:00
README.md readme 2020-05-04 11:45:50 +02:00
setup.py 1.0 2020-05-04 10:34:02 +02:00

postgres=# create extension multicorn;                                                                                                                                            
CREATE EXTENSION
postgres=# create server csv_source foreign data wrapper multicorn options (wrapper 's3_csv_multicorn.S3CSV');
CREATE SERVER
postgres=# create user mapping for fred server csv_source options (access_key 'minioadmin',secret_key 'minioadmin', endpoint '127.0.0.1:9000');
CREATE USER MAPPING
postgres=# create foreign table test (f1 character varying, f2 character varying, f3 float) server csv_source options(bucket 'turin', glob '.*csv', delimiter ',');
CREATE FOREIGN TABLE
postgres=# select count(*) from test;
 count  
--------
 991893
(1 row)