apop_db_to_crosstab(1)

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

Section 1 apophenia-bin bookworm source

Description

APOP_DB_TO_CROSSTAB

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