Loading data into PostgreSQL
Regina Obe is a world-renowned PostGIS spatial database expert and connoisseur of all things PostgreSQL. She has over 20 years professional experience in various programming languages and database systems. She is a member of the PostGIS project steering committee, the PostGIS core development team, pgRouting development team, and Geometry Open Source Library (GEOS) development and project steering committees.
She is a co-author of several PostgreSQL related books with her husband, Leo Hsu:
- PostGIS in Action (2nd edition, 3rd edition in the works), published by Manning Publications,
- PostgreSQL: Up and Running, (now in 3rd Edition), published by O'Reilly Media,
- pgRouting: A Practical Guide (publisher, LocatePress).
She and Leo are currently working on an upcoming PostgreSQL book (publisher: No Starch Press).
No video of the event yet, sorry!
PostgreSQL is one of the easiest databases to get data into and out of. In addition there are tons of free useful data sources to munch on.
We'll cover various ways of loading various kinds of data into PostgreSQL. Data formats will include other postgres data, delimited, fixed width, spreadsheets, other relational databases, and other formats (including spatial formats) you may come across, and even Web services.
We'll demonstrate loading data using SQL, psql \copy, pg_dump/pg_restore, various extensions including FDWs, and other open source command-line tools.
Although our examples will be with PostgreSQL 10 and 11, most examples will work on lower versions of PostgreSQL.
- 2019 March 21 16:50
- 20 min
- Riverside Suite
- Postgres Conference