DBS_DUMPTABSTRUCT(1p)

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

✨ dbs_dumptabstruct — the Perl manual page, bestie edition ✨

okay so this is DBS_DUMPTABSTRUCT(1p) from the User Contributed Perl Documentation section, and honestly? she's a little utility with main character energy. let's get into it 💅

🌸 NAME 🌸

dbs_dumptabstruct — creates a file set with SQL table schemas. that's it, that's the whole vibe. 🎀

💖 DESCRIPTION 💖

so dbs_dumptabstruct is a utility that creates a file set with SQL table schemas. like, that's her whole job and she does it flawlessly.

the way it works: for every single table in the database, dbs_dumptabstruct calls the appropriate dumper utility, and the output gets directed to a file named table.sql in the current directory. one file per table, no cap. 🗂️

and if a password is necessary? she'll ask you for it. polite queen behavior. 🙈

🦋 COMMAND LINE PARAMETERS 🦋

the required command line parameters are:

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

the third parameter is optional and it specifies the database user and/or the host where the database resides. the examples given are literally:

racke
racke@linuxia.de
@linuxia.de

so user, user@host, or just @host. pick your fighter. ✨

👑 COMMAND LINE OPTIONS 👑

💫 -d=OPTIONS, -o=OPTIONS, --dump-options=OPTIONS 💫

passes options through to the dumper utility. for example, "--compatible=mysql40". giving the dumper exactly what she needs, yk? 🫶

💫 -p, --pipe 💫

prints the table dumps to standard output. no files, just vibes. 🔥

💫 -t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...] 💫

a comma-separated list of tables to dump. only the ones you name, bestie. 🎯

💫 --exclude-matching-tables=REGEXP 💫

excludes any table matching the regular expression REGEXP from dumping. so if a table's name matches, she's not coming to the party. 🚫

💀 BUGS 💀

not a bug exactly but like… only mysql and Pg drivers are supported. so if your driver isn't one of those two? yeah. she can't help you, and that's the tea. 😭

💜 AUTHOR 💜

Stefan Hornburg (Racke), racke@linuxia.de. the icon who wrote her. 👑

⭐ VERSION ⭐

0.17. periodt. 💅

🌈 SEE ALSO 🌈

fr fr, read those SEE ALSO pages if you wanna go deeper. iykyk. 🧚

and that's a wrap, bestie! this page came to you from perl v5.32.0, dated 2021-01-06, and yes she's DBS_DUMPTABSTRUCT(1p) through and through. go dump some table structures and slay ✨💖🎀

📦 where this page comes from