User's Guide Prev Chapter 5. The second argument for all formatting functions is a template to be used for the conversion. All templates allow the use of prefix and suffix modifiers.
Modifiers are always valid for use in templates.
The prefix ' FX ' is a global modifier only. FX must be specified as the first item in the template. Template Description 9 value with the specified number of digits 0 value with leading zeros . Now not supported. PL , SG , and TH are Postgres extensions.