salt.states.postgres_schema¶

Management of PostgreSQL schemas¶

The postgres_schemas module is used to create and manage Postgres schemas.

public:
  postgres_schema.present 'dbname' 'name'

salt.states.postgres_schema.absent(dbname, name, db_user=None, db_password=None, db_host=None, db_port=None)¶

Ensure that the named schema is absent.

dbname

The database's name will work on

name

The name of the schema to remove

db_user

database username if different from config or default

db_password

user password if any password for a specified user

db_host

Database host if different from config or default

db_port

Database port if different from config or default

salt.states.postgres_schema.present(dbname, name, owner=None, db_user=None, db_password=None, db_host=None, db_port=None)¶

Ensure that the named schema is present in the database.

dbname

The database's name will work on

name

The name of the schema to manage

owner

The database user that will be the owner of the schema

db_user

database username if different from config or default

db_password

user password if any password for a specified user

db_host

Database host if different from config or default

db_port

Database port if different from config or default