planetscale / cli

The CLI for PlanetScale Database
https://planetscale.com/cli
Apache License 2.0
603 stars 52 forks source link

[Feature Request] JSON, Parquet or CSV output format options for `pscale databases dump` #892

Open davidzajac1 opened 2 months ago

davidzajac1 commented 2 months ago

Currently pscale database dump will create many SQL files containing SQL INSERT commands that can be run. It would be more helpful to output all the rows in JSON, Parquet or CSV files. This could be done by adding an --output-format flag where the default is "sql" but could also have an option for "json", "parquet" or "csv" like pscale database dump mydb --output-format json.