NADEEF CSV File Format

Jump to bottom

Si Yin edited this page Apr 23, 2014 · 8 revisions

CSV Grammar

File       -> Header <line separator> Body
Header     -> Column <comma> Column*
Column     -> <columnName> <space> Type
Type       -> <SQL types>
Body       -> Tuple <line separator> Tuple*
Tuple      -> Value <comma> Value*

<line separator> is the new line char.
<comma> is ','.
<columnName> is a valid SQL column name.
<SQL types> is a valid SQL type, we are using PostgreSQL Types.

Reference

RFC 4180 http://tools.ietf.org/html/rfc4180