DO $$ BEGIN CREATE TABLE (...); END $$; adds an extra space to variable length types before closing paren

[pchuffman]

For example, in this DO $$ ... END $$ context, a VARCHAR(10) is formatted as

VARCHAR(10 )

There is an extra space before the closing paren. Same for CHAR, NUMERIC etc. This also happens with, for example, a column check constraint, "C1 VARCHAR(10) CHECK(C1 > 1)" results in

VARCHAR (10 ) CHECK (C1 > 1 )

pg_format in.txt -o out.txt

out.txt
in.txt