
Example:
dbadmin=> SELECT 'ABC' || RPAD(' ', 10, ' ') || 'DEF' "Insert 10 spaces!";
Insert 10 spaces!
-------------------
ABC DEF
(1 row)
dbadmin=> SELECT 'ABC' || SPACE(10) || 'DEF' "Insert 10 spaces!";
Insert 10 spaces!
-------------------
ABC DEF
(1 row)
dbadmin=> SELECT 'My girlfriend broke up with me because she said she needed ' || SPACE(10) || '!?!?' AS "?";
?
---------------------------------------------------------------------------
My girlfriend broke up with me because she said she needed !?!?
(1 row)
Helpful Links:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/SPACE.htm
https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/RPAD.htm
Have fun!