Skip to main content
Version: 1.1 (Latest)

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_mssql connector

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:ss even 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:

FormatExample output
True/FalseTrue, False
yes/noyes, no
y/ny, 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.

Copyright © 2026 Architecture & Performance.