Install Pgloader On A Debian, Ubuntu, Kali And MacOS

Install Pgloader On A Debian, Ubuntu, Kali And MacOS

pgloader

extract, transform and load data into PostgreSQL

Maintainer: Dimitri Fontaine



Section: database

Install pgloader

  • Debian apt-get install pgloader Click to copy
  • Ubuntu apt-get install pgloader Click to copy
  • Kali Linux apt-get install pgloader Click to copy
  • macOS brew install pgloader Click to copy

pgloader

extract, transform and load data into PostgreSQL

pgloader imports data from different kind of sources and COPY it into PostgreSQL. The command language is described in the manual page and allows one to describe where to find the data source, its format, and to describe data processing and transformation. Supported source formats include CSV, fixed width flat files, dBase3 files (DBF), and SQLite and MySQL databases. In most of those formats, pgloader is able to auto-discover the schema and create the tables and the indexes in PostgreSQL. In the MySQL case it's possible to edit CASTing rules from the pgloader command directly.

To install the latest version of pgloader in your favorite operating system just copy the pgloader installation command from above and paste it into terminal. It will download and install the latest version of pgloader 2024 package in your OS.