YAML examples for PostgreSQL CLI
Execute PostgreSQL commands
yaml
- action: "Run PostgreSQL queries"
type: "POSTGRESQL_CLI"
trigger_time: "ON_EVERY_EXECUTION"
version: "16"
shell: "BASH"
commands: |-
psql -c '\l'
psql -f migrate.sql
setup_commands: "apt-get install -y curl"
targets:
- target: my_database
type: POSTGRESQL
name: My PostgreSQL Database
host: pg.example.com
port: "5432"
database: myapp
auth:
username: deploy_user
password: secured