Export a table or a query result to a file system

Source code

Tool. Runs: dorieh.platform.util.pg_export

Description

This tool builds all indices for the specified table. Log file displays real-time progress of building indices

Inputs

Name

Type

Default

Description

table

string?

the name of the table

sql

string?

SQL query

partition

string[]?

List of columns to be used for partitioning

output

string

the name of the newly created file or directory

format

string

Format of the export, one of jsonl, parquet, csv, hdf5

database

File

Path to database connection file, usually database.ini

connection_name

string

The name of the section in the database.ini file

depends_on

Any?

a special field used to enforce dependencies and execution order

Outputs

Name

Type

Description

data

[‘File’, ‘Directory’]

log

File

errors

stderr