pg2parquet
pg2parquet copied to clipboard
Export PostgreSQL table or query into Parquet file
I'd like to use this to query a PostGIS database that has geometry types. I see there is a GeoParquet format although I haven't looked too deeply into how well...
pg2parquet 0.1.0-beta.8 Running with --output-file does not overwrite existing destination file.
Retention for artifacts from GH action runs defaults to 30 days; hence, the binaries in the [Version 0.1.1](https://github.com/exyi/pg2parquet/actions/runs/9338422111) run have expired.
* `vector` is serialized as float32 List (with required elements) * `halfvector` is also serialized either as float32 List, or the new Parquet float16 if enabled with an option *...
I was playing around with using [pgvector](https://github.com/pgvector/pgvector) and vector columns. I thought maybe pg2parquet would handle them as arrays but I end up getting an error that it's an unsupported...
Hi! Thanks for building this tool. If you're open to suggestions for features, I have one. It would be useful to alternatively define the database connection using an environment variable,...
Thank you for a great tool. After some time of use we faced performance problems with big tables( ~5GB in our case). In our case pg_dump require 5 minutes to...
I noticed when looking at the file metadata that the `distinct_count` field is missing for string fields. I put together a reproduction with a test file so you can see:...