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