Hello, I think the postgresql ansible module is for administrating postgresql or enabling the execution of scripts or queries rather then providing a some layer around DDL or DML commands for PostgreSQL.
You should be able to use postgresql_query_module or postgresql_script_module for executing the SQL you have to provide. BR, Roland Dick Visser schrieb am Mittwoch, 17. April 2024 um 18:00:30 UTC+3: > Hi,, > > I'm trying to manage a postgres database with ansible. > Database OK, users OK, tables OK. > But now I have a table which has a field that should auto update with > NOW() upon changes. So far that requires SQL statements like this: > > CREATE FUNCTION ... > CREATE TRIGGER... > > I looked at > https://docs.ansible.com/ansible/latest/collections/community/postgresql/index.html > but I don;t immediately see something that suits... > Any suggestions? > > thx! > > Dick > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/10ba4786-511c-4b0e-bbc8-6bab079e75f4n%40googlegroups.com.
