export-from-postgres.yaml

id: export-from-postgres
namespace: company.team

tasks:
  - id: export
    type: io.kestra.plugin.jdbc.postgresql.CopyOut
    url: jdbc:postgresql://sample_postgres:5433/world
    username: postgres
    password: postgres
    format: CSV
    header: true
    sql: SELECT * FROM country LIMIT 10
    delimiter: ","

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

extend:
  title: Export output of a Postgres SQL query to a CSV file
  description: This example shows how to extract data from a Postgres table. The
    flow logs the number of extracted rows. The extracted file can be retrieved
    with the `{{ outputs.export.uri }}` command.
  tags:
    - Postgres
    - SQL
    - Outputs
  ee: false
  demo: false
  meta_description: "This workflow shows how to extract data from a Postgres table."