postgresql_schema - Add or remove PostgreSQL schema from a remote host

• Synopsis
  • Requirements
• Parameters
• Notes
• Examples
• Return Values
• Status
• Maintenance
  • Author

Synopsis

• Add or remove PostgreSQL schema from a remote host.

Requirements

The below requirements are needed on the host that executes this module.

• psycopg2

Parameters

Parameter	Choices/Defaults	Comments
database	Default: "postgres"	Name of the database to connect to.
login_host	Default: "localhost"	Host running the database.
login_password		The password used to authenticate with.
login_unix_socket		Path to a Unix domain socket for local connections.
login_user		The username used to authenticate with.
name required		Name of the schema to add or remove.
owner		Name of the role to set as owner of the schema.
port	Default: 5432	Database port to connect to.
state	Choices: present ← absent	The schema state.

Notes

Examples

# 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

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key	Returned	Description
schema string	success, changed	Name of the schema Sample: acme

Status

This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.

Maintenance

This module is flagged as community which means that it is maintained by the Ansible Community. See Module Maintenance & Support for more info.

For a list of other modules that are also maintained by the Ansible Community, see here.

Author

• Flavien Chantelot <contact@flavien.io>