Tutorials

Previous Next

Put

Command

put {column} …

put {column} … before {column}

put {column} … after {column}

Alternative put {column} …
Purpose

move or insert columns to a target location.

The default target of the put command is before first, i.e. to the left of a table.

The addition of before {column} or after {column} can be used to place the columns relative to another, taget column.

The column names first and last are interpreted as the first column and the last column respectively.

Use :first, :last, :before or :after to reference columns named first, last etc..

Tips

Use move to move existing columns only.

Use insert to insert new columns regardless of existing columns.

Examples

psv put wip done

  • move or add the columns wip and done to the left of each table
  • Existing columns are moved (including their data).
  • Missing columns are added

psv put wip done before task

  • Place the columns wip and done before the task column.
  • If the target column, task does not exist, place the columns at the left of the table.

psv put wip done last

  • Place the columns wip and done on the right of each table.

Playground - alter all tables so that they begin with a "wip" and "done" column % psv put wip done Chores: | Task | Done | ----------------- | ----- | clean the kitchen | done | wash the dished | done | vacuum | in progress Projects: | Project | Task | -------- | -------------------- | bird house | design bird house | | buy wood | | cut parts | | assemble parts | - | fully-over-engineered letter box - alter all tables so that they begin with a "wip" and "done" column % psv put wip done before task Chores: | Task | Done | ----------------- | ----- | clean the kitchen | done | wash the dished | done | vacuum | in progress Projects: | Project | Task | -------- | -------------------- | bird house | design bird house | | buy wood | | cut parts | | assemble parts | - | fully-over-engineered letter box # this table no "task" column, so the "before" keyword puts the columns on the # left of the table. Cooking: | Step | Description | ---- | ---------- | 1 | boil water | 2 | add eggs | 3 | wait 4 minutes | 4 | serve - move / add a "wip" and "done" at the end of the table % psv put wip done last Chores: | Task | Done | ----------------- | ----- | clean the kitchen | done | wash the dished | done | vacuum | in progress Projects: | Project | Task | -------- | -------------------- | bird house | design bird house | | buy wood | | cut parts | | assemble parts | - | fully-over-engineered letter box Cooking: | Step | Description | ---- | ---------- | 1 | boil water | 2 | add eggs | 3 | wait 4 minutes | 4 | serve
Previous Next