when use DB2 database, the format of export data is just like this:
123, "zhangsan", -23.
But in postgresql, the format is just like this:
123, zhangsan, -23.
How to achieve the same format of DB2 in postgresql?
I tried to use
copy xxx to '.csv' (format csv,delimiter ',',force_quote (column...))
but I have to manually add the column on which I want to add quotation marks after the force_quote...How to automatically determine non-numeric columns with quotation marks? I know in mysql, there is a "enclosed by” to achieve. In postgresql, how to achieve this?