Hi, check documentation Populate a database <https://www.postgresql.org/docs/10/static/populate.html>
this explains how to create a dummy table, load it using COPY command, and then INSERT / UPDATE target tables (using ON CONFLICT if needed) You can also investigate: - file_fdw <https://www.postgresql.org/docs/current/static/file-fdw.html> extension (that permits to use text files as tables) - pg_bulkload <https://github.com/ossc-db/pg_bulkload/> extension (that permits to load data like Oracle loader do) Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
