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