DBCOLCREATE(1)

📦
version 3.9 · 3 versions
, in epel 9

💅 dbcolcreate — aka DBCOLCREATE(1), from the User Contributed Perl Documentation corner of the universe ✨

okay so bestie, picture this: you've got a table, and it's missing a column. tragic. iconic of you to fix it with dbcolcreate, which just... makes new columns. that's the whole gig. it lives in the Perl man pages (User Contributed Perl Documentation, to be precise) and it's lowkey a lifesaver 🫶

✨ NAME ✨

dbcolcreate — create new columns, periodt 💅

🌸 SYNOPSIS 🌸

    dbcolcreate NewColumn1 [NewColumn2]

or, if you're feeling fancy and want a default value in there:

    dbcolcreate -e DefaultValue NewColumnWithDefault

🦋 DESCRIPTION 🦋

Create columns NewColumn1, etc. — with an optional DefaultValue if you're into that 💖. that's it, that's the vibe. no cap.

🎀 OPTIONS 🎀

  • -e EmptyValue, --empty — tells it what value your freshly created columns should get. your new columns, your rules ✨
  • -f, --first — puts all the new columns at the front of every row, main character energy 👑. by default? they go at the end of each row instead.
  • --no-recreate-fatal — by default, trying to create a column that already exists is an error (drama, honestly 😭). with --no-recreate-fatal, we just ignore the re-creation instead.

This module also supports the standard fsdb options, bestie:

  • -d — enable debugging output 🔍
  • -i InputSource, --input — read from InputSource, typically a file name, or - for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
  • -o OutputDestination, --output — write to OutputDestination, typically a file name, or - for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
  • --autorun, --noautorun — by default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. the --(no)autorun option controls that behavior within Perl 🧚
  • --header H — use H as the full Fsdb header, rather than reading a header from then input. (yes, "then input" — that's the original wording, leaving it exactly as-is, don't come for me 🙈)
  • --help — show help 🫶
  • --man — show full manual 📖

⭐ SAMPLE USAGE ⭐

🌈 Input:

    #fsdb test
    a
    b

🌈 Command:

    cat data.fsdb | dbcolcreate foo

🌈 Output:

    #fsdb      test    foo
    a       -
    b       -

see how foo just appeared? ate. 🔥

💜 SEE ALSO 💜

Fsdb. — go check it out, iykyk

Copyright (C) 1991-2022 by John Heidemann <johnh@isi.edu>

This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.

ngl, credit where credit is due: John Heidemann has been holding it down since 1991, and this is GNU GPL v2 territory, so read COPYING before you get creative 🍓

okay that's the whole page, love u, bye 💖

perl v5.32.1 📅 2024-08-02 — that's the version and date, stamped at the very bottom like a little time capsule from the day this manpage last got its glow-up. slay. ✨🎀

📦 where this page comes from