Shortcuts for Running SQL Commands and Scripts
For more information about the individual SQL scripts relevant to administration and to troubleshooting or performance tuning, see Tools.
After logging in to a console window and invoking:
A reminder banner will appear:
USAGE of the enabled shortcuts:
psqlc "<a SQL command>"
psqlf <path to script with SQL commands> [<arg1> [<arg2> [...]]]
Invokes interactive prompt. Note that you can also invoke SQL scripts
from within the interactive prompt, like so: \i <path to script>
; you will then be prompted for script args.
You can use the
psqlf shortcut to run the various SQL scripts packaged with LCE that are found under
Here is an example of running a SQL script that takes no arguments:
And here is an example of running a SQL script that takes an argument:
psqlf pg-helper-sql/disk-usage-one-silo.sql 0
To quickly locate and run a script:
Log in to LCE via the command line interface (CLI).
psqlffollowed by a space.
Type the first few letters of the name of the script you want to run. For example, to run wal-activity.sql, you can type wa.
psqlf automatically completes the name of the script.
To run the script, press Enter.
LCE runs the selected script.