Hi, COPY command's FORMAT option allows only all lowercase csv, text or binary, this is true because strcmp is being used while parsing these values.
It would be nice if the uppercase or combination of lower and upper case format options such as CSV, TEXT, BINARY, Csv, Text, Binary so on. is also allowed. To achieve this pg_strcasecmp() is used instead of strcmp. Attached is a patch having above changes. Request the community to review the patch, if it makes sense. With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com
v1-0001-COPY-command-s-data-format-option-allows-only-low.patch
Description: Binary data