DBS_PRINTTAB(1p)

📦
version 0.21 · 3 versions
, in debian bookworm, ubuntu jammy, ubuntu noble

✨ NAME ✨

dbs_printtab — prints SQL table data on standard output 💅

okay bestie, this is dbs_printtab, a lil utility (from the User Contributed Perl Documentation collection, iykyk) whose whole entire personality is: it prints your SQL table data straight to standard output. that's the job. that's the gig. and yes, it will ask you for a password if necessary, because boundaries ✋🔐

🦋 DESCRIPTION 🦋

dbs_printtab is an utility to print SQL table data on standard output. no cap, that's literally what it does — you point it at a table, it spills the contents onto your terminal. iconic behavior.

and dbs_printtab asks for a password if necessary. so if it needs one, it'll be like "bestie… the password? 🥺" and you provide it. simple as.

🌸 COMMAND LINE PARAMETERS 🌸

the required command line parameters are, in order:

  1. the DBI driver — that's "Pg" for Postgres or "mysql" for MySQL 👑
  2. the database name
  3. the table name

the fourth parameter is optional, and it specifies the database user and/or the host where the database resides. the accepted shapes are:

  • "racke" — just a user
  • "racke@linuxia.de" — user plus host
  • "@linuxia.de" — just a host, no user, the @ holding it down by itself 💀

💖 COMMAND LINE OPTIONS 💖

  • -c=COLUMN[,COLUMN], --columns=COLUMN[,COLUMN] — the output is restricted to the given COLUMN arguments. so you're like "not me wanting only these columns actually 💅" and it listens.
  • --sort=KEY[,KEY] — the output is sorted by the KEY arguments. multiple keys? comma-separate them, she can handle it.

💀 BUGS 💀

msql is not fully supported. that's it. that's the whole warning. msql girlies, we're sorry, it's giving incomplete. 🫶

👑 AUTHOR 👑

Stefan Hornburg (Racke), racke@linuxia.de — the legend, the main character, the one who wrote this thing. periodt.

🌈 SEE ALSO 🌈

and that's the whole page, bestie!! this was shipped as part of perl v5.32.0, dated 2021-01-06, and yeah, that's the DBS_PRINTTAB(1p) moment. go print some tables, you absolute icon 💅✨🎀

📦 where this page comes from