Re: cvs text to quoted cvs text - Mailing list pgsql-sql

2016-09-26 22:09 GMT+02:00 Michael Moore <michaeljmoore@gmail.com>:

Igor, not seeing how quote_literal will quote each element of the csv. It will quote the entire string, but not each element.

SELECT string_agg(quote_literal(v),',') from unnest('{AHOJ,NAZDAR}'::text[]) g(v);

Pavel, Interesting but unfortunately my dynamic sql is very complex, hundreds of lines, and a undetermined number of USING variables would be needed.

Thanks!