Release Notes 1.1
What's Changed
ADBC PostgreSQL — Arpe.io ADBC FastDriver
FastBCP now supports ADBC for PostgreSQL via the -C adbc_pgsql connector, powered by the new ADBC Arrow_FEBE drivers (Arpe.io ADBC FastDriver).
Key highlights:
- Ultra-fast Parquet exports from PostgreSQL
- Native Arrow columnar format eliminates conversion overhead
- Same high-performance ADBC approach as the existing
adbc_mssqlconnector
Usage:
fastbcp -S pg-server:5432 \
-d MyDatabase \
-Q "SELECT * FROM public.orders" \
-C adbc_pgsql \
--fileoutput "orders.parquet"
See Connection Parameters documentation for more details.
[Breaking] New Default Date Format
The default --dateformat value for CSV, JSON, and XLSX outputs has changed from yyyy-MM-dd to yyyy-MM-dd HH:mm:sszzz.
Auto-adaptive behavior: The format automatically adapts based on the column type:
- Date-only columns remain formatted as
yyyy-MM-dd - Timestamp/DateTime columns are formatted as
yyyy-MM-dd HH:mm:sseven if a timezone token (zzz) is in the format string - DateTimeOffset columns include the full timezone offset
This change also fixes date-only format handling and adds timezone support for CSV date formatting.
Migration: If your pipeline depends on the previous default (yyyy-MM-dd), explicitly set --dateformat "yyyy-MM-dd" in your command.
New Boolean Format Values
The --boolformat parameter now supports additional formats:
| Format | Example output |
|---|---|
True/False | True, False |
yes/no | yes, no |
y/n | y, n |
These are in addition to the existing true/false, t/f, and 1/0 formats.
Example:
fastbcp -S myserver \
-d MyDatabase \
-Q "SELECT * FROM products" \
--fileoutput "products.csv" \
--boolformat "True/False"
Environment Variables Guardrails
Added internal guardrails on environment variable handling to prevent injection vectors from this channel. This is a security hardening change with no user-facing impact.