{"repo":"exyi/pg2parquet","free":true,"listed":false,"github":"https://github.com/exyi/pg2parquet","clone":"git clone https://github.com/exyi/pg2parquet.git","description":"Export PostgreSQL table or query into Parquet file","language":"Rust","stars":96,"topics":["parquet","postgres","postgresql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"PostgreSQL - Parquet Simple tool for exporting PostgreSQL tables into parquet, with support for more esoteric Postgres features than just int and text . Installation Download Binary from Github Download the binary from Github Actions artifacts (click on the latest run, scroll to the bottom, choose your system). Using Cargo Using Nix flakes If you use Nix, this command will install the latest pg2parquet version. It compiles it from sources, so the installation will take some time. Then use the pg2parquet in the new shell. Note that you might need to add --extra-experimental-features 'nix-command flakes' argument to the nix invocation. Arch User Repository If on an Arch-based system, use yay -S pg2parquet (or your favorite AUR helper). From Sources Install Rust and Cargo. Clone the repo. It should finish in few minutes ( 10 CPU minutes). Take the target/release/pg2parquet file, delete rest of the target directory (it takes quite a bit of disk space). You can optionally strip the binary, but you'll get poor stack trace if it crashes. Basic usage Alternatively, you can export result of a SQL query You can also use environment variables $PGPASSWORD and $PGUSER for credentials. You can use $DATABASE URL variable to specify the full connection string. Supported types Basic SQL types : text , char , varchar and friends, all kinds of int s, bool , floating point numbers, timestamp , timestamptz , date , time , uuid interval - interval has lower precision in Parquet (ms) than in Postgr","default_branch":null,"files":null,"tree":[],"storefront":"/r/exyi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/exyi/pg2parquet/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}