Multi-line Mode

The default behavior of pgcli is to execute a query as soon as the enter key is pressed. This might come as a surprise to seasoned psql users who always enter a semi-colon to denote the end of the query.

To emulate the original psql behavior you can enable the multi-line mode which will require a semi-colon to be present at the end of the line. This enables writing multi-line queries if they are really long. You can enable multi-line mode by pressing <F3> key or set it permanently via the config file.

blogroll

social