Create Table with "WITH" Inline Function Not Have Correct Indentation

[lih3120]

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;
$$