How to Load and Manage CSV Files using DbSchema

Connection Dialog

A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format.

DbSchema can simultaneously load and manage multiple CSV files placed inside a folder. In the DbSchema connection dialog choose the folder where the CSV files are. The connection dialog is explained here.

Load CSV Files from Folder

CSV Format

DelimiterRecordSeparatorEscapeCharacterQuoteCharacterQuoteModeNullStringIgnoreEmptyLines
, "true
, "false
| \"true
, "true
, ""MINIMALtrue
""MINIMALtrue
\ALL_NON_NULL\Nfalse
, \"MINIMAL\Nfalse
, "ALL_NON_NULLfalse
\ALL_NON_NULL\Nfalse
, "false
"true

Save the Database Back to CSV

After connecting, DbSchema will load the data into a H2 local database. You can edit the data, add new records, etc. To save back the data to CSV file use the command: 

save csv to 'path'
where the path is the folder where to save the data.

DbSchema Features for CSV Files

DbSchema is loading the CSV files to a temporary H2 database. DbSchema will auto-detect the mandatory fields, primary keys and foreign keys.

DbSchema Diagram for CSV files

Available are all DbSchema features, including the SQL Editor, Relational Data Explorer, Query Builder, etc.