close
The Wayback Machine - https://web.archive.org/web/20201014070111/https://github.com/dbcli/pgcli/issues/1191
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

\prompt not working with pgcli #1191

Open
abhijhanwar opened this issue Jun 3, 2020 · 1 comment
Open

\prompt not working with pgcli #1191

abhijhanwar opened this issue Jun 3, 2020 · 1 comment
Labels

Comments

@abhijhanwar
Copy link

@abhijhanwar abhijhanwar commented Jun 3, 2020

Description

To work with interactive SQLs, we need to provide input at sql runtime, for this we need \prompt to work, but it's not working with pgcli as shown below:

pgdb1> \i tab_size.sql
syntax error at or near ""
LINE 1: \prompt 'enter schema name here: ' schema_name
^

as can be seen above \prompt is not identified as keyword.

Please have a look.

Your environment

  • Please provide your OS and version information.
    MacOS - version 10.14.6
  • Please provide your CLI version.
    Version: 2.2.0
  • What is the output of pip freeze command.
    $ pip3 freeze
    awscli==1.17.0
    botocore==1.14.0
    cli-helpers==2.0.1
    click==7.1.1
    colorama==0.4.1
    coloredlogs==10.0
    configobj==5.0.6
    docutils==0.15.2
    Flask==1.1.1
    humanfriendly==4.18
    humanize==2.4.0
    itsdangerous==1.1.0
    Jinja2==2.11.1
    jmespath==0.9.4
    MarkupSafe==1.1.1
    pgspecial==1.11.10
    prompt-toolkit==3.0.5
    psycopg2==2.8.5
    pyasn1==0.4.8
    Pygments==2.5.2
    python-dateutil==2.8.1
    PyYAML==5.2
    retrying==1.3.3
    rsa==3.4.2
    s3transfer==0.3.0
    setproctitle==1.1.10
    six==1.13.0
    sqlparse==0.3.0
    tabulate==0.8.7
    terminaltables==3.1.0
    urllib3==1.25.7
    wcwidth==0.2.3
    Werkzeug==1.0.1
@j-bennet
Copy link
Contributor

@j-bennet j-bennet commented Jul 25, 2020

pgcli does not support all meta-commands ("backslash commands") that exist in psql. \? will display all supported pgcli commands.

I can leave this open as feature request - but it's not a bug.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.