Translations of this page?:
Loads data from a CSV file into an existing table. A value of NULL in a cell will be converted to a database NULL rather than the string “NULL”
Since LiquiBase 1.7
<loadData tableName="users" file="com/sample/users.csv">
<column name="id" type="NUMERIC"/>
<column name="firstname" type="STRING"/>
<column name="lastname" type="STRING"/>
<column name="username" type="STRING"/>
</loadData>
| tableName | Name of the table to insert data into [required] |
| schemaName | Name of the table schema |
| file | CSV file to load [required] |
| encoding | Encoding of the CSV file (defaults to UTF-8) |
| column | Defines how the data should be loaded |
| index | A zero-based index of the column being described [index or header required] |
| header | Data file header row value of column being described [index or header required] |
| name | Name of the column to insert into. Defaults to the header value in the file |
| type | Data type of the column. Possible values: STRING, NUMERIC, DATE, BOOLEAN [required] |
| MySQL | No Issues |
| PostgreSQL | No Issues |
| Oracle | No Issues |
| MS-SQL | No Issues |
| Sybase | No Issues |
| DB2 | No Issues |
| Derby | No Issues |
| HSQL | No Issues |
| H2 | No Issues |
| Caché | No Issues |
| Firebird | No Issues |
| MaxDB | No Issues |
| SQLite | No Issues |
Automatic Rollback Support: NO
