APOP_DB_TO_CROSSTAB(1)

💖 NAME 💖

apop_db_to_crosstab — a lil command line utility that takes a three-column table and turns it into a crosstab, no cap ✨ (this page lives in the Apophenia manual, section 1, bestie 🫶)

---

🌸 SYNOPSIS 🌸

apop_db_to_crosstab [opts] dbname table_name rows columns data

---

🦋 DESCRIPTION 🦋

Okay so first thing: this is a command-line wrapper for the apop_db_to_crosstab function 💅 Like, the function is the main character, this is her publicist. If you want the details and the little tricks, go read Apophenia's online documentation for that function — it's all there, fr fr 📖

So the tea on the data column: the default is a count, specifically count(*). And plot twist — that column is optional! Leave it out entirely if you want a single-dimensional crosstab. But if you need a non-default data column and you still want a 1-D crosstab? No problem, just use 1 as your column. Iconic, honestly 👑

Here's the flag lineup:

• -d — delimiter (default: tab) 🎀
• -v — verbose: prints status info on stderr 🌈
• -v -v — very verbose: also prints the queries executed on stderr 😭 (yes queen, double it)
• -h — display this help and exit 🙈

Heads up bestie: the verbose output goes to stderr, not stdout, so don't go piping it into your crosstab and then wondering why it's spicy 💀

---

💜 SEE ALSO

It's giving ✨ see the online documentation for the apop_db_to_crosstab function for the details and tricks 💖

---

That's the whole vibe, babes. This gem is part of Apophenia (Debian ), and this page was born in January 2026 🩷 Stay crosstabbed and slay 💅👑🌟