[FIXED] How to Insert empty string in amazon redhsift without getting converteed to NULL?

Issue

I am tryig to load data using copy command in redshift using pipe delimeter csv file, while loading || empty is getting converted to NULL as i wanted but |""| this also getting converted to NULL. how can i handel this situation please respond.

Solution

\copy (select * from schema.table) to 'path/filename.csv' NULL 'NULL' DELIMETER '|' CSV HEADER; for exporting. In redshift I used NULL as 'NULL' option in the copy command it worked

Answered By - Surya Appana

Answer Checked By - Robin (PHPFixing Admin)