pgdump-mapper

Overview

The pgdump-mapper is designed to read PostgreSQL dump files and export the data in various formats. It provides a command-line interface for easy configuration and usage.

Features

• Read PostgreSQL Dump Files: Efficiently parses PostgreSQL dump files, handling table definitions, primary keys, and foreign keys.
• Export Options: Supports exporting data in multiple formats:
  • JSON
  • JSON Pretty
  • YAML
  • HTML
  • SQLite
• Filter Options: Supports filtering data based on:
  • Schema
  • Table
  • Columns

Project Structure

pgdump-mapper
├── internal
│   ├── cli/            # Command-line interface handles
│   │   └── errors/     # Error declarations
│   │   └── messages/   # Message declarations 
│   └── data/           # Main logic for reading and exporting data 
│       └── exporters/  # Logic for data export 
│       └── parsers/    # Logic for data processing 
│       └── templates/  # Template declarations
├── models/             # Data models 
├── README.md           # Documentation
└── main.go             # Entry point

Usage Instructions

1. Clone the Repository:

   git clone https://github.com/hedibertosilva/pgdump-mapper.git
   cd pgdump-mapper
   

2. Build the Application:

   go build -o pgdump-mapper main.go
   

3. Install it:

   cp pgdump-mapper /home/$USER/.local/bin
   

4. Usage:

   pgdump-mapper --help
   

Contributing Code

Feel free to contribute. Contact me via hed.cavalcante@gmail.com