Date: 2014-10-23
Time: 09:30–10:20
Room: Renacimiento I
Level: Intermediate
pgloader version 3.1 is now released and allows you to load about any data into your favorite RDMBS, because sometimes a Foreign Data Wrapper will not cut it.
Among other things, pgloader allows for complete unnatended data migration from MySQL, including schema discovery (with indexes and foreign keys) and a powerful rule-based casting clause. That allows you to cast some tinyint to boolean and some others to smallint from the same command.
Also supported are CSV files, fixed width files, SQLite databases, dBase files and IXF files.