pgcli icon indicating copy to clipboard operation
pgcli copied to clipboard

New option: default DSN

Open remcohaszing opened this issue 4 years ago • 0 comments

Description

By default pgcli connects with /var/run/postgresql/.s.PGSQL.5432, which isn’t running on my device. Most of the time, I need to use pgcli -D local.

I would like pgcli to use the local DSN by default. I imagine this could be done using the following option in the configuration file:

[main]
# The default DSN to connect to when running pgcli.
default_dsn = local

Your environment

  • [x] Please provide your OS and version information. Pop!_OS 20.04

  • [x] Please provide your CLI version. 3.0.0

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

    cffi==1.14.0
    cli-helpers==1.2.1
    click==7.1.2
    configobj==5.0.6
    cryptography==2.9.2
    humanize==2.4.0
    jeepney==0.4.3
    keyring==21.2.1
    pgcli==3.0.0
    pgspecial==1.11.10
    pkg-resources==0.0.0
    prompt-toolkit==3.0.5
    psycopg2==2.8.5
    pycparser==2.20
    Pygments==2.6.1
    SecretStorage==3.1.2
    setproctitle==1.1.10
    six==1.14.0
    sqlparse==0.3.1
    tabulate==0.8.7
    terminaltables==3.1.0
    wcwidth==0.1.9
    

remcohaszing avatar Nov 06 '20 14:11 remcohaszing