DBF_DUMP(1p)

💾 DBF_DUMP(1p) — dump the record of the dbf file

okay bestie, gather round 💖 this is dbf_dump, a little Perl script from the User Contributed Perl Documentation corner of your manual pages (section 1p, iykyk), and it is literally here to spill the entire contents of a dbf file to your terminal. no cap.

---

✨ FORMAT ✨

dbf_dump [options] files

where options are

• --rs — output record separator (default newline)
• --fs — output field separator (default colon)
• --fields — comma separated list of fields to print (default all)
• --undef — string to print for NULL values (default empty)
• --memofile — specifies unstandard name of attached memo file
• --memosep — separator for dBase III dbt's (default \x1a\x1a)
• --nomemo — do not try to read the memo (dbt/fpt) file
• --info — print info about the file and fields; with additional --SQL parameter, outputs the SQL create table
• --version — print version of the XBase library
• --table — output in nice table format (only available when Data::ShowTable is installed, overrides rs and fs)

heads up queen: --table is a whole vibe but it's ✨ conditional ✨ — if Data::ShowTable isn't installed, it's not available. and when it is around, it overrides rs and fs, so don't fight it.

---

🌸 SYNOPSIS 🌸

dbf_dump -fields id,msg table.dbf
dbf_dump -fs=' : ' table
dbf_dump --nomemo file.dbf

ssh user@host 'cat file.dbf.gz' | gunzip - | dbf_dump -

look at that last one 👑 piping a gzipped dbf straight over ssh into dbf_dump -?? that's main character energy fr fr.

---

🦋 DESCRIPTION 🦋

dbf_dump prints to standard output the content of dbf files listed. by default? it prints all fields, separated by colons, one record on a line. that's the default vibe 💅

the output record and column separators can be changed by switches on the command line — you're in control, bestie. you can also ask only for some fields to be printed, so if you only care about two columns out of forty, you get to say so.

the content of associated memo files (dbf, fpt) is printed for memo fields, unless you use the --nomemo option. so like, memo content shows up by default, and --nomemo is you saying "not today 🙈".

you can specify reading the standard input by putting dash (-) instead of file name. yes, the humble dash. iconic.

---

🎀 AVAILABLE FROM 🎀

http://www.adelton.com/perl/DBD-XBase/

---

💜 AUTHOR 💜

(c) 1998--2011 Jan Pazdziora.

---

🌈 SEE ALSO 🌈

perl(1); XBase(3pm); index_dump(1p)

---

and that's the whole page, bestie 🫶 this was perl v5.34.0, dated 2022-06-13 — so if you're reading this way later, hi, you're a time traveler, slay 💅✨