ansible.builtin.postgresql_schema (v2.4.4.0-1) — module

Install Ansible via pip

Install with pip install ansible==2.4.4.0.post1

Description

Add or remove PostgreSQL schema from a remote host.

Requirements

• psycopg2

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

# Create a new schema with name "acme"
- postgresql_schema:
    name: acme

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

# Create a new schema "acme" with a user "bob" who will own it
- postgresql_schema:
    name: acme
    owner: bob

Inputs

    
name:
    default: null
    description:
    - Name of the schema to add or remove.
    required: true

port:
    default: 5432
    description:
    - Database port to connect to.
    required: false

owner:
    default: null
    description:
    - Name of the role to set as owner of the schema.
    required: false

state:
    choices:
    - present
    - absent
    default: present
    description:
    - The schema state.
    required: false

database:
    default: postgres
    description:
    - Name of the database to connect to.
    required: false

login_host:
    default: localhost
    description:
    - Host running the database.
    required: false

login_user:
    default: null
    description:
    - The username used to authenticate with.
    required: false

login_password:
    default: null
    description:
    - The password used to authenticate with.
    required: false

login_unix_socket:
    default: null
    description:
    - Path to a Unix domain socket for local connections.
    required: false

Outputs

schema:
  description: Name of the schema
  returned: success, changed
  sample: acme
  type: string