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
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