Tutorials

Selects a column by its name or position.

psv first attempts to match the name against the table's column names.

If no column names match and {name} is a number, then the number will be used as described for .{number} below.

This behaviour is expected be suitable for most situations.

Ambiguous column identification can be overcome via the following alternatives.

selects the left-most column of a table.

Tip the first keyword is implied to mean before first when used as the last argument to the put, move or insert commands.

selects the right-most column of a table.

Tip the last keyword is implied to mean after last when used as the last argument to the put, move or insert commands.

The before keyword indicates that the next argument will be the name of a target column, before which the command's action should take place.

Specifically:

• before must be the second-last argument for a command
• the column named after the before keyword will be the command's target
• use :before to address a column named before

e.g. psv put todo before done will move or insert the todo column before the done column.

The after keyword indicates that the next argument will be the name of a target column, after which the command's action should take place.

Specifically:

• after must be the second-last argument for a command
• the column named after the after keyword will be the command's target
• use :after to address a column named after

e.g. psv put todo after done will move or insert the todo column after the done column.

Selects a column exclusively by its name.

Even if name is a number, it will not be used as a column's position.

:first, :last, :config etc. should be used to identify columns with names that would otherwise match psv keywords.

selects a column exclusively by its position, starting with 1 for the left-most column.