Downloads 9.1kthis week

GitHub stars 5

Extension descriptor (YAML)

Read DBF (dBase) files with support for general DBF formats and field types.

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Installing and Loading

INSTALL read_dbf FROM community;
LOAD read_dbf;

Example

-- Read all rows from a dbffile
SELECT * FROM read_dbf('filename.dbf');

About read_dbf

The read_dbf extension provides functions for reading DBF (dBase) files, which are commonly used in legacy applications and GIS data formats. It supports a wide range of DBF formats and field types, allowing you to easily integrate DBF data into your DuckDB queries.

Functions:

• read_dbf(path) - Read all rows from a DBF file

Output Schema: The output schema will depend on the structure of the DBF file being read. Each column in the DBF file will be represented as a column in the output, with appropriate data types based on the field types defined in the DBF file.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.