How Can I pass variables for psql using goose? e.g. -v v1=12 -v v2="'Hello World'"

[dineshkoppa]

I have my postgres.sql file, in which I have some variables that need to pass for every environment.

I need the option to pass those variables from goose to those SQL scripts

Referring to this https://stackoverflow.com/questions/7389416/postgresql-how-to-pass-parameters-from-command-line

[mfridman]

Goose supports running arbitrary sql with the -no-versioning flag. Described in more detail here:

https://pressly.github.io/goose/blog/2021/no-version-migrations/

But the tool does not, currently, support variable expansion/substitution. There's an open issue and there's some chat there on how we may implement it.. #347

Curious, could you not solve this with psql ?

[dineshkoppa]

Thanks, @mfridman. I would expect to pass the env variable feature from goose soon.

Yes psql can solve our issue, but I wanted one-stop solution from goose itself. Thats why I'm curious to look into this tool