---
name: "apop_db_to_crosstab"
section: "1"
platform: "linux"
package: "apophenia-bin"
version: "1.0+ds-10"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/apop_db_to_crosstab"
---

# apop\_db\_to\_crosstab(1)

command line utility to convert a three-column table to a 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