Scroll to navigation

APOP_DB_TO_CROSSTAB(1) Apophenia APOP_DB_TO_CROSSTAB(1)

NAME

apop_db_to_crosstab - command line utility to convert a three-column table to a crosstab

SYNOPSIS

apop_db_to_crosstab [opts] dbname table_name rows columns data

DESCRIPTION

A command-line wrapper for the apop_db_to_crosstab function. See Apophenia's online documentation for that function for details and tricks. The default for the data column is a count [count(*)] The column is optional; leave it out if you want a single-dimensional crosstab. If you need a non-default data column but want a 1-D crosstab, use 1 as your column.
-d
delimiter (default: <tab>)
-v
verbose: prints status info on stderr
-v -v
very verbose: also print queries executed on stderr
-h
display this help and exit
March 2019 Apophenia (Debian )