If we put the following procedure into the pgFormatter, we will see the indentation is not right: The end ")" comes to the very beginning of the line. Also the keyword "with" is not uppercased nor is highlighted.
CREATE OR REPLACE PROCEDURE test ()
LANGUAGE plpgsql
AS $$
BEGIN
CREATE temp TABLE test AS
with reg_data AS (
SELECT
buyer
FROM
reg
WHERE
status = 'Enabled'
)
SELECT
buyer
FROM
reg_data;
If we put the following procedure into the pgFormatter, we will see the indentation is not right: The end ")" comes to the very beginning of the line. Also the keyword "with" is not uppercased nor is highlighted.
CREATE OR REPLACE PROCEDURE test () LANGUAGE plpgsql AS $$ BEGIN CREATE temp TABLE test AS with reg_data AS ( SELECT buyer FROM reg WHERE status = 'Enabled' ) SELECT buyer FROM reg_data;
END; $$