search

dbcli / pgcli

Postgres CLI with autocompletion and syntax highlighting
http://pgcli.com
BSD 3-Clause "New" or "Revised" License
12.01k stars 551 forks source link

Autocomplete offers no columns after one column named 'type' #1412

Open ShootingStar91 opened 1 year ago

ShootingStar91 commented 1 year ago

Description

I work with a table that has a column named type

If I write a query like: SELECT type, name, id FROM table;

Then after typing the column name type, I will not get any autocomplete suggestions for column names. I will get those before typing "type". The feature only suggests table names after "type". Also type is highlighted as it is a non-reserving keyword, rightly so I believe.

Your environment

Ubuntu 22.04.2 pgcli 3.3.1

Pip freeze: agate==1.6.3 agate-dbf==0.2.2 agate-excel==0.2.5 agate-sql==0.5.8 ansible-base==2.10.8 apache-libcloud==3.2.0 appdirs==1.4.4 apptools==5.1.0 apt-xapian-index==0.49 apturl==0.5.2 argcomplete==1.8.1 argon2-cffi==21.1.0 asciitree==0.3.3 astroid==2.9.3 astropy==5.0.2 asttokens==2.0.5 attrs==21.2.0 autobahn==21.11.1 Automat==20.2.0 autopep8==1.6.0 ayatana-settings==21.1.28 Babel==2.8.0 backcall==0.2.0 base58==1.0.3 bcrypt==3.2.0 beautifulsoup4==4.10.0 beniget==0.4.1 bitarray==1.6.3 bleach==4.1.0 blinker==1.4 blosc==1.9.2 Bottleneck==1.3.2 breezy==3.2.1 Brlapi==0.8.3 Brotli==1.0.9 CacheControl==0.12.10 cachetools==5.0.0 cachy==0.3.0 cajarename==21.11.24 cbor==1.0.0 cdo==1.5.6 certifi==2020.6.20 cffi==1.15.0 cftime==1.5.2 chardet==4.0.0 cleo==0.8.1 cli-helpers==2.2.1 click==8.0.3 clikit==0.6.2 cloudpickle==2.0.0 colorama==0.4.4 command-not-found==0.3 configobj==5.0.6 constantly==15.1.0 cov-core==1.15.0 coverage==6.2 crashtest==0.3.1 cryptography==3.4.8 css-parser==1.0.7 cssutils==1.0.2 csvkit==1.0.6 cupshelpers==1.0 cutadapt==3.5 cycler==0.11.0 Cython==0.29.28 dask==2022.1.0+dfsg dbfread==2.0.7 dbus-python==1.2.18 decorator==4.4.2 defer==1.0.6 defusedxml==0.7.1 deja-dup-caja==0.0.9 Deprecated==1.2.13 descartes==1.1.0 devscripts===2.22.1ubuntu1 distlib==0.3.4 distributed==2022.1.0+ds.1 distro==1.7.0 distro-info===1.1build1 dnaio==0.7.1 dnspython==2.1.0 dropbox==11.26.0 dulwich==0.20.31 duplicity==0.8.21 ecdsa==0.18.0b1 entrypoints==0.4 envisage==6.0.1 et-xmlfile==1.0.1 fastbencode==0.0.5 fasteners==0.14.1 fastimport==0.9.14 filelock==3.6.0 flatbuffers===1.12.1-git20200711.33e2d80-dfsg1-0.6 folder-color-caja==0.0.86 folder-color-common==0.0.86 fonttools==4.29.1 fs==2.4.12 fsspec==2022.1.0 fuse-python==1.0.2 fusepy==3.0.1 future==0.18.2 gajim==1.3.3 gast==0.5.2 GDAL==3.4.1 geographiclib==1.52 geopy==2.2.0 google-api-python-client==1.7.11 google-auth==1.5.1 google-auth-httplib2==0.1.0 gpg===1.16.0-unknown greenlet==1.1.2 gssapi==1.6.12 h5netcdf==0.12.0 h5py==3.6.0 h5py.-debian-h5py-serial==3.6.0 HeapDict==1.0.1 html5lib==1.1 httplib2==0.20.2 hyperlink==21.0.0 hypothesis==6.36.0 idna==3.3 img2pdf==0.4.2 importlib-metadata==4.6.4 incremental==21.3.0 iniconfig==1.1.1 iotop==0.6 ipykernel==6.7.0 ipython==7.31.1 ipython_genutils==0.2.0 ipywidgets==6.0.0 isodate==0.6.1 isort==5.6.4 jdcal==1.0 jedi==0.18.0 jeepney==0.7.1 Jinja2==3.0.3 jmespath==0.10.0 joblib==0.17.0 jsonschema==3.2.0 jupyter-client==7.1.2 jupyter-core==4.9.1 jupyterlab-pygments==0.1.2 keyring==23.5.0 kiwisolver==1.3.2 language-selector==0.1 launchpadlib==1.10.16 lazr.restfulclient==0.14.4 lazr.uri==1.0.6 lazy-object-proxy==0.0.0 leather==0.3.4 libarchive-c==2.9 libhfst_swig==3.15.4b0 llvmlite==0.38.0 locket==0.2.1 lockfile==0.12.2 logilab-common==1.8.2 louis==3.20.0 lxml==4.8.0 lz4==3.1.3+dfsg macaroonbakery==1.3.1 Magnus==1.0.3 Mako==1.1.3 Markdown==3.3.6 MarkupSafe==2.0.1 mate-hud==22.4.4 mate-tweak==22.4.8 matplotlib==3.5.1 matplotlib-inline==0.1.3 mayavi==4.7.1 mccabe==0.6.1 meld==3.20.4 mercurial==6.1.1 meson==0.61.2 mne==0.23.4 mnemonic==0.19 mock==4.0.3 monotonic==1.6 more-itertools==8.10.0 mpi4py==3.1.3 mpmath==0.0.0 msgpack==1.0.3 mypy-extensions==0.4.3 mysqlclient==1.4.6 nbclient==0.5.6 nbconvert==6.4.0 nbformat==5.1.3 nbxmpp==2.0.4 nest-asyncio==1.5.4 netaddr==0.8.0 netCDF4==1.5.8 netifaces==0.11.0 nibabel==3.2.2 nose==1.3.7 nose2==0.9.2 notebook==6.4.8 ntlm-auth==1.4.0 numba==0.55.1 numcodecs==0.9.1+ds numexpr==2.8.1 numpy==1.21.5 oauth2client==4.1.3 oauthlib==3.2.0 odfpy==1.4.2 olefile==0.46 onboard==1.4.1 openpyxl==3.0.9 OWSLib==0.25.0 packaging==21.3 pandas==1.3.5 pandocfilters==1.5.0 paramiko==2.9.3 parsedatetime==2.6 parso==0.8.1 partd==1.2.0 passlib==1.7.4 pastel==0.2.1 patiencediff==0.2.1 patsy==0.5.2 pbr==5.8.0 pdfarranger==1.8.2 pendulum==2.1.2 pep8==1.7.1 pexpect==4.8.0 pgcli==3.3.1 pgspecial==1.11.10 pickleshare==0.7.5 pikepdf==5.0.1+dfsg Pillow==9.0.1 pkginfo==1.8.2 platformdirs==2.5.1 plotly==5.4.0 pluggy==0.13.0 ply==3.11 poetry==1.1.12 poetry-core==1.0.7 precis-i18n==1.0.2 prometheus-client==0.9.0 prompt-toolkit==3.0.28 protobuf==3.12.4 pssh==2.3.4 psutil==5.9.0 psycopg2==2.9.2 ptyprocess==0.7.0 pulsemixer==1.5.1 py==1.10.0 py-ubjson==0.16.1 pyasn1==0.4.8 pyasn1-modules==0.2.1 pycairo==1.20.1 pycodestyle==2.8.0 pycparser==2.21 pycryptodomex==3.11.0 pycups==2.0.1 pydicom==2.2.2 pydocstyle==6.1.1 PyDrive==1.3.1 pyerfa==2.0.0.1 pyface==7.4.0 pyflakes==2.4.0 pygame==2.1.2 pygit2==1.6.1 PyGithub==1.55 Pygments==2.11.2 PyGObject==3.42.1 PyHamcrest==2.0.2 PyICU==2.8.1 pyinotify==0.9.6 PyJWT==2.3.0 pykerberos==1.1.14 pylev==1.2.0 pylibacl==0.6.0 pylibtiff==0.4.4 pylint==2.12.2 pymacaroons==0.13.0 pymol==2.5.0 PyNaCl==1.5.0 PyOpenGL==3.1.5 pyOpenSSL==21.0.0 pyparsing==2.4.7 pypng==0.0.20 pyproj==3.3.0 PyQRCode==1.2.1 PyQt5==5.15.6 PyQt5-sip==12.9.1 PyQtWebEngine==5.15.5 pyraf==2.2.0 pyRFC3339==1.1 pyrsistent==0.18.1 pysvn==1.9.15 pytest==6.2.5 pytest-arraydiff==0.5.0 pytest-astropy==0.9.0 pytest-astropy-header==0.2.0 pytest-cov==3.0.0 pytest-doctestplus==0.11.2 pytest-filter-subpackage==0.1.1 pytest-mock==3.6.1 pytest-openfiles==0.5.0 pytest-remotedata==0.3.3 python-apt==2.4.0+ubuntu1 python-axolotl==0.2.3 python-axolotl-curve25519==0.4.1.post2 python-dateutil==2.8.1 python-debian===0.1.43ubuntu1 python-gitlab==2.10.1 python-gnupg==0.4.8 python-lsp-jsonrpc==1.0.0 python-lsp-server==1.3.3 python-magic==0.4.24 python-pam==1.8.4 python-slugify==4.0.0 python-snappy==0.5.3 python-xapp==2.2.1 python-xlib==0.29 pythran==0.10.0 pytidylib==0.3.2 pytimeparse==1.1.5 PyTrie==0.4.0 pytz==2022.1 pytzdata==2020.1 pyudev==0.22.0 pywinrm==0.3.0 pyxattr==0.7.2 pyxdg==0.27 PyYAML==5.4.1 pyzmq==22.3.0 qrcode==7.3.1 QScintilla==2.11.6 reportlab==3.6.8 requests==2.25.1 requests-kerberos==0.12.0 requests-ntlm==1.1.0 requests-toolbelt==0.9.1 rope==0.22.0 rsa==4.8 rubber==1.6.0 s3cmd==2.2.0 scikit-learn==0.23.2 scipy==1.8.0 SCons==4.0.1 scour==0.38.2 seaborn==0.11.2 SecretStorage==3.3.1 selinux==3.3 Send2Trash==1.8.1b0 service-identity==18.1.0 setproctitle==1.2.2 Shapely==1.8.0 shellingham==1.4.0 simplejson==3.17.6 simpy==3.0.11 six==1.16.0 snowballstemmer==2.2.0 sortedcontainers==2.1.0 soupsieve==2.3.1 SQLAlchemy==1.4.31 sqlparse==0.4.2 ssh-import-id==5.11 stone==3.3.1 stsci.tools==4.0.1 sympy==1.9 systemd-python==234 tables==3.7.0 tabulate==0.8.9 tblib==1.7.0 tenacity==6.3.1 terminado==0.13.1 terminaltables==3.1.0 terminator==2.1.1 testpath==0.5.0 threadpoolctl==3.1.0 tinycss==0.4 tinycss2==1.1.1 toml==0.10.2 tomlkit==0.9.2 toolz==0.11.2 tornado==6.1 traitlets==5.1.1 traits==6.3.2 traitsui==7.2.1 Twisted==22.1.0 txaio==21.2.1 typing-extensions==3.10.0.2 u-msgpack-python==2.3.0 ubuntu-advantage-tools==8001 ubuntu-drivers-common==0.0.0 ufoLib2==0.13.1 ufw==0.36.1 ujson==5.1.0 unattended-upgrades==0.1 unicodedata2==14.0.0 Unidecode==1.3.3 unidiff==0.5.5 uritemplate==3.0.1 urllib3==1.26.5 virtualenv==20.13.0+ds wadllib==1.3.6 wcwidth==0.2.5 webencodings==0.5.1 widgetsnbextension==2.0.0 wrapt==1.13.3 wsaccel==0.6.3 xarray==0.16.1 xdg==5 xkit==0.0.0 xlrd==1.2.0 xlwt==1.3.0 xmltodict==0.12.0 xopen==1.2.1 yapf==0.32.0 youtube-dl==2021.12.17 zarr==0.0.0 zict==2.0.0 zipp==1.0.0 zope.interface==5.4.0

j-bennet commented 1 year ago

@ShootingStar91 so you have a column named type?

ShootingStar91 commented 1 year ago

@ShootingStar91 so you have a column named type?

That's correct

I work with a table that has a column named type