pgfutter: Simplified Data Import Tool for PostgreSQL
pgfutter is a lightweight command-line tool designed to streamline the process of importing CSV and line-delimited JSON files into PostgreSQL databases. It abstracts the complexities of data ingestion, enabling users to efficiently transfer data with minimal setup and configuration.
Features
Automatic table generation based on CSV headers
High-performance data transfer using PostgreSQL's COPY protocol
Support for importing from local and remote databases
Error handling capabilities to manage import failures
Customizable delimiters and encoding support, limited to UTF-8
Environment variable and command-line flag options for connection details
Flexibility to specify custom table names and header fields
Repository Details
1,328
128
Updated: 11/6/2024
Languages
Go
Shell