Re: How to ensure column names are double quoted while using execute format when building a stored procedure? - Mailing list pgsql-general

The following command runs but does not produce results as expected.

 

Execute Format('insert into stats select %L as id, %2$L as checks, count(%3$s) from %4$s where %5$s is null', i, 'count of nulls in '||col, col, t_name, col);

All columns have got capital letters in.  How to ensure that the columns are double-quote when they are fed in as variables.

The type of format conversion to use to produce the format specifier's output. The following types are supported:

s formats the argument value as a simple string. A null value is treated as an empty string.

I treats the argument value as an SQL identifier, double-quoting it if necessary. It is an error for the value to be null (equivalent to quote_ident).

L quotes the argument value as an SQL literal. A null value is displayed as the string NULL, without quotes (equivalent to quote_nullable).