\! <command> not works or missing

[sys-walker]

Description

When I tried to use the native command \! clear to clear screen it didn't work with pgcli as it works in psql

$ pgcli
Server: PostgreSQL 12.4 (Ubuntu 12.4-0ubuntu0.20.04.1)
Version: 2.2.0
Chat: https://gitter.im/dbcli/pgcli
Home: http://pgcli.com
pere@(none):pere> \! clear
syntax error at or near "\"
LINE 1: \! clear
        ^

Time: 0.002s
pere@(none):pere>

Your environment

• [x] Please provide your OS and version information.

  
  $  cat /etc/os-release
  NAME="Ubuntu"
  VERSION="20.04.1 LTS (Focal Fossa)"
  ID=ubuntu
  ID_LIKE=debian
  PRETTY_NAME="Ubuntu 20.04.1 LTS"
  VERSION_ID="20.04"
  HOME_URL="https://www.ubuntu.com/"
  SUPPORT_URL="https://help.ubuntu.com/"
  BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
  PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
  VERSION_CODENAME=focal
  UBUNTU_CODENAME=focal

$ python3 --version Python 3.8.5

- [x] Please provide your CLI version.

$ pgcli -v Version: 2.2.0

- [x] What is the output of ``pip freeze`` command.

$ pip3 freeze apturl==0.5.2 bcrypt==3.1.7 blinker==1.4 Brlapi==0.7.0 certifi==2019.11.28 chardet==3.0.4 Click==7.0 colorama==0.4.3 command-not-found==0.3 configobj==5.0.6 cryptography==2.8 cupshelpers==1.0 dbus-python==1.2.16 defer==1.0.6 distro==1.4.0 distro-info===0.23ubuntu1 duplicity==0.8.12.0 entrypoints==0.3 fasteners==0.14.1 future==0.18.2 httplib2==0.14.0 humanize==1.0.0 idna==2.8 keyring==18.0.1 language-selector==0.1 launchpadlib==1.10.13 lazr.restfulclient==0.14.2 lazr.uri==1.0.3 lockfile==0.12.2 louis==3.12.0 macaroonbakery==1.3.1 Mako==1.1.0 MarkupSafe==1.1.0 monotonic==1.5 netifaces==0.10.4 oauthlib==3.1.0 olefile==0.46 paramiko==2.6.0 pexpect==4.6.0 pgspecial==1.9.0 Pillow==7.0.0 prompt-toolkit==3.0.8 protobuf==3.6.1 psycopg2==2.8.4 pycairo==1.16.2 pycups==1.9.73 Pygments==2.7.2 PyGObject==3.36.0 PyJWT==1.7.1 pymacaroons==0.13.0 PyNaCl==1.3.0 pyRFC3339==1.1 python-apt==2.0.0+ubuntu0.20.4.1 python-dateutil==2.7.3 python-debian===0.1.36ubuntu1 pytz==2019.3 pyxdg==0.26 PyYAML==5.3.1 reportlab==3.5.34 requests==2.22.0 requests-unixsocket==0.2.0 screen-resolution-extra==0.0.0 SecretStorage==2.3.1 setproctitle==1.1.10 simplejson==3.16.0 six==1.14.0 sqlparse==0.3.1 systemd-python==234 tabulate==0.8.6 terminaltables==3.1.0 ubuntu-advantage-tools==20.3 ubuntu-drivers-common==0.0.0 ufw==0.36 unattended-upgrades==0.1 urllib3==1.25.8 usb-creator==0.3.7 wadllib==1.3.3 wcwidth==0.2.5 xkit==0.0.0

[j-bennet]

Same answer is here: https://github.com/dbcli/pgcli/issues/1191#issuecomment-663907983 it's not one of the commands pgcli supports. PRs are always welcome.

[gfrlv]

This command is part of pgspecial (one of the dependencies) and works since version pgspecial==1.11.5. Your versions of pgcli and all the dependencies are very old, you need to upgrade pgcli with pip3 install --upgrade pgcli.