Convert PGSQL to CSV online

Input file

Our API uses a .SQL file as input. This could be a PostgreSQL dump from the pg_dump tool or an output of any other tool that returns SQL. The file should contain CREATE TABLE and INSERT/UPDATE statements.

Max file size for web uploads: 50 GB
Register to upload big files via Amazon S3.

Output file

The API will return a ZIP archive of .CSV files, one for each table in the given database file. The CSV files comply with our CSV specification.

Conversion methods

Using CURL

Replace file.sql with the path to the PostgreSQL .SQL file you want to convert.
The file output.zip will contain a CSV file, one for each table in the given database file. If something went wrong, output.zip contains the error message.

curl -F files[]=@file.sql 'https://www.rebasedata.com/api/v1/convert?outputFormat=csv&errorResponse=zip' -o output.zip

How long does it take?

The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.

Why use RebaseData?

Terms