Re: Bulk Insert/Update Scenario - Mailing list pgsql-general

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