CopyOut

id: postgres_copy_out
namespace: company.team

tasks:
  - id: copy_out
    type: io.kestra.plugin.jdbc.postgresql.CopyOut
    url: jdbc:postgresql://sample_postgres:5432/world
    username: "{{ secret("POSTGRES_USERNAME") }}"
    password: "{{ secret("POSTGRES_PASSWORD") }}"
    format: CSV
    sql: SELECT 1 AS int, 't'::bool AS bool UNION SELECT 2 AS int, 'f'::bool AS bool
    header: true
    delimiter: "\t"

id: export_from_postgres
namespace: company.team

tasks:
  - id: export
    type: io.kestra.plugin.jdbc.postgresql.CopyOut
    url: jdbc:postgresql://sample_postgres:5432/world
    username: "{{ secret("POSTGRES_USERNAME") }}"
    password: "{{ secret("POSTGRES_PASSWORD") }}"
    format: CSV
    header: true
    sql: SELECT * FROM country LIMIT 10
    delimiter: ","

  - id: log
    type: io.kestra.plugin.core.log.Log
    message: "{{ outputs.export.rowCount }}"