10 ways to load data into Postgres

Date: 2018-09-06
Time: 14:30 - 15:20
Room: Stockton
Level: Beginner

Postgres is one of the easiest databases to get data into and out of.

We'll cover 10 ways of loading various kinds of data into Postgres. Data formats will include other postgres data, delimited, fixed width, spreadsheets, other relational databases, and other formats (including spatial formats) you may come across.

We'll demonstrate loading data using SQL, psql \copy, pg_dump/pg_restore, various extensions including FDWs, and other open source command-line tools.

We'll also demonstrate features introduced in PostgreSQL 10 that provide new ways of loading data.


Leo Hsu and Regina Obe