For standard run the following as root:
zypper addrepo https://download.opensuse.org/repositories/home:fbui:branches:test-rebuild-systemd-macros/standard/home:fbui:branches:test-rebuild-systemd-macros.repo
zypper refresh
zypper install postgresql
For openSUSE Factory run the following as root:
zypper addrepo https://download.opensuse.org/repositories/home:fbui:branches:test-rebuild-systemd-macros/openSUSE_Factory/home:fbui:branches:test-rebuild-systemd-macros.repo
zypper refresh
zypper install postgresql