PostgreSQL Provider is a provider used to query POSTGRES databases
steps: - name: Query postgres provider: postgres config: "{{ provider.my_provider_name }}" with: query: {value}
actions: - name: Query postgres provider: postgres config: "{{ provider.my_provider_name }}" with: query: {value}
CREATE USER '<username>' WITH ENCRYPTED PASSWORD '<password>'
CREATE DATABASE '<yourdbname>';
GRANT ALL PRIVILEGES ON <database>.* TO '<username>'