Getting Environment Variables for PostgreSQL resource

[nrsmac]

I want to create new user accounts with passwords from production environment variables on PostgreSQL resource creation.

I defined environment variables under Projects>My First Project>postgresql1>Environment Variables (in prod environment). How do I then reference those environment variables in the SQL initialization scripts?

[Phaust94]

does that answer your question?

https://stackoverflow.com/questions/73117285/use-environment-variable-with-postgres-initialization-script-run-by-docker-compo

[nrsmac]

almost -- I tried this approach by mounting a bash file as a persistent mount and this did not work -- even though it normally works when I just use docker without coolify. I am talking about how Coolify lets you run an init SQL on the main config page for the postgres resource and if it supports variable expansion?