/ home / community / community.general / 1.3.14 / module / postgresql_schema

community.general.postgresql_schema (1.3.14) — module

Add or remove PostgreSQL schema

Authors: Flavien Chantelot (@Dorn-) <contact@flavien.io>, Thomas O'Donnell (@andytom)

Install collection

Install with ansible-galaxy collection install community.general:==1.3.14

Add to requirements.yml

  collections:
    - name: community.general
      version: 1.3.14

Description

Add or remove PostgreSQL schema.

Requirements

psycopg2

Usage examples

Scanned by Steampunk Spotter

- name: Create a new schema with name acme in test database
  community.general.postgresql_schema:
    db: test
    name: acme

Scanned by Steampunk Spotter

- name: Create a new schema acme with a user bob who will own it
  community.general.postgresql_schema:
    name: acme
    owner: bob

Scanned by Steampunk Spotter

- name: Drop schema "acme" with cascade
  community.general.postgresql_schema:
    name: acme
    state: absent
    cascade_drop: yes

Inputs

    
name:
    aliases:
    - schema
    description:
    - Name of the schema to add or remove.
    required: true
    type: str

port:
    aliases:
    - login_port
    default: 5432
    description:
    - Database port to connect to.
    type: int

owner:
    description:
    - Name of the role to set as owner of the schema.
    type: str

state:
    choices:
    - absent
    - present
    default: present
    description:
    - The schema state.
    type: str

ca_cert:
    aliases:
    - ssl_rootcert
    description:
    - Specifies the name of a file containing SSL certificate authority (CA) certificate(s).
    - If the file exists, the server's certificate will be verified to be signed by one
      of these authorities.
    type: str

database:
    aliases:
    - db
    - login_db
    default: postgres
    description:
    - Name of the database to connect to and add or remove the schema.
    type: str

ssl_mode:
    choices:
    - allow
    - disable
    - prefer
    - require
    - verify-ca
    - verify-full
    default: prefer
    description:
    - Determines whether or with what priority a secure SSL TCP/IP connection will be
      negotiated with the server.
    - See U(https://www.postgresql.org/docs/current/static/libpq-ssl.html) for more information
      on the modes.
    - Default of C(prefer) matches libpq default.
    type: str

login_host:
    description:
    - Host running the database.
    type: str

login_user:
    default: postgres
    description:
    - The username used to authenticate with.
    type: str

trust_input:
    default: true
    description:
    - If C(no), check whether values of parameters I(schema), I(owner), I(session_role)
      are potentially dangerous.
    - It makes sense to use C(no) only when SQL injections via the parameters are possible.
    type: bool
    version_added: 0.2.0
    version_added_collection: community.general

cascade_drop:
    default: false
    description:
    - Drop schema with CASCADE to remove child objects.
    type: bool

session_role:
    description:
    - Switch to session_role after connecting.
    - The specified session_role must be a role that the current login_user is a member
      of.
    - Permissions checking for SQL commands is carried out as though the session_role
      were the one that had logged in originally.
    type: str

login_password:
    description:
    - The password used to authenticate with.
    type: str

login_unix_socket:
    description:
    - Path to a Unix domain socket for local connections.
    type: str

Outputs

queries:
  description: List of executed queries.
  returned: always
  sample:
  - CREATE SCHEMA "acme"
  type: list
schema:
  description: Name of the schema.
  returned: success, changed
  sample: acme
  type: str

Install collection

Add to requirements.yml

Description

Requirements

Usage examples

Inputs

Outputs

See also