Define psql extra options
Closed this issue · 1 comments
fljdin commented
A psql
task should define some extra options to use with psql
client
Examples:
-At
: no-align and tuples only-L
or-o
: output into log file-P
: other printing options, in the style of\pset
-v
or--set
: variable assignment like the\set
meta-command
fljdin commented
PR #21 provides an alternative to some requested features
Example:
tasks:
- id: 1
type: psql
name: No-align and tuples only (or other \pset options)
command: SELECT 1 \g (format=unaligned tuples_only)
- id: 2
type: psql
name: Expanded printing option
command: SELECT 1 \gx
- id: 3
type: psql
name: output into log file
command: SELECT 1 \g output.txt