pá 26. 1. 2024 v 20:45 odesílatel <walt...@technowledgy.de> napsal:
> Pavel Stehule: > > looks a little bit obscure - why do you need to do it from psql? And how > > frequently do you do it? > > I store all my SQL code in git and use "psql -e" to "bundle" it into an > extension, which is then deployed to production. > this is good way > > The code is spread over many files, which include other files via \ir. > Sometimes you need to include other types of files, though - for example > code in other languages as Steve mentioned, but I have also had cases > for yaml files, markdown templates, even binary assets which should > still be considered "code" and not data. > > So anything in that direction would help. > but why you need to do in psql? - you can prepare content outside and execute just like echo "CREATE FUNCTION ...." | psql