How Alter postgres table definitions with ansible?

[simon read]

We are using ansible to deploy postgres/schema/tables.

We require to patch the tables and therefore require to alter the tables (e.g. add or change type of columns).
There seems to be two modules related to this. postgresql_table (can create tables but not alter) and
postgres_query (seems to be for DML statements).

Can you advise? I am new too ansible and wonder why altering tables is not currently included with a module?

[Kai Stian Olstad]

On 31.08.2019 19:56, simon read wrote:
> Can you advise? I am new too ansible and wonder why altering tables is not
> currently included with a module?

The person(s) that created the module didn't have the need for the functionality and did not implement it.

Anyone can add the functionality if that want to, or hire someone to do it for them.


--
Kai Stian Olstad