rango export

Exports data from the database to JSON or CSV.

Usage

# Export all tables to stdout (JSON)
rango export

# Export a specific table
rango export --table users

# Export to a file
rango export --table users --output users.json

# CSV format
rango export --table users --format csv --output users.csv

# Custom database URL
rango export --table users --database-url postgres://...

Options

OptionDefaultDescription
--tableall tablesTable to export
--formatjsonOutput format: json or csv
--outputstdoutOutput file path
--database-urlDATABASE_URLDatabase connection URL

JSON format

Single table:

[
  { "id": "...", "email": "alice@example.com", "active": true },
  { "id": "...", "email": "bob@example.com", "active": false }
]

Multiple tables (no --table specified):

[
  { "__table": "user", "id": "...", "email": "alice@example.com" },
  { "__table": "post", "id": "...", "title": "Hello" }
]

The __table field lets rango import route rows to the right table automatically.

CSV format

id,email,active
abc-123,alice@example.com,true
def-456,bob@example.com,false

Cross-backend export

Export from Postgres, import into SQLite:

DATABASE_URL=postgres://... rango export --output data.json
DATABASE_URL=sqlite://dev.db rango import data.json