Read DBF (dBase) files with support for general DBF formats and field types.
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
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_dbf | table | NULL | NULL |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|