ansible / ansible.builtin / v2.6.10 / module / postgresql_schema Add or remove PostgreSQL schema from a remote host | "added in version" 2.3 of ansible.builtin" Authors: Flavien Chantelot <contact@flavien.io> preview | supported by communityansible.builtin.postgresql_schema (v2.6.10) — module
pip
Install with pip install ansible==2.6.10
Add or remove PostgreSQL schema from a remote host.
# Create a new schema with name "acme" - postgresql_schema: name: acme
# Create a new schema "acme" with a user "bob" who will own it - postgresql_schema: name: acme owner: bob
name: description: - Name of the schema to add or remove. required: true port: default: 5432 description: - Database port to connect to. owner: description: - Name of the role to set as owner of the schema. state: choices: - present - absent default: present description: - The schema state. database: default: postgres description: - Name of the database to connect to. login_host: default: localhost description: - Host running the database. login_user: description: - The username used to authenticate with. login_password: description: - The password used to authenticate with. login_unix_socket: description: - Path to a Unix domain socket for local connections.
schema: description: Name of the schema returned: success, changed sample: acme type: string