Postgres: Get string all matches between {}

PHOTO EMBED

Mon Aug 29 2022 16:19:59 GMT+0000 (UTC)

Saved by @marcopinero #sql

select regexp_matches('FV{YY}{MM}{DD}-{UU}-{###}', '\{([A-Za-z#]+)\}', 'g');
content_copyCOPY

Get all string matches between {..} from string.