v.21.11New Features
Added CSV Null Representation Setting for Output Format
Added a settingoutput_format_csv_null_representation: This is the same asoutput_format_tsv_null_representationbut is for CSV output. #29123 (PHO).
Why it matters
This feature addresses the need to customize the representation ofNULL values when exporting data in CSV format, similar to the existing capability for TSV format with output_format_tsv_null_representation. It allows users to better control and standardize the output to meet their data processing or integration requirements.How to use it
Set theoutput_format_csv_null_representation setting to the desired string value before exporting data with CSV format. For example, use SET output_format_csv_null_representation = 'NULL'; to represent NULL values as the string "NULL" in the CSV output.