Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    kodkuce
    @kodkuce
    hi i have 1 question, can i do some query or something to get CREATE STATMENT for that table, i think i saw it can be done with pg_dump but am asking can i do it while in pgcli
    Patrick
    @pwoji_gitlab
    Hey all. What's the keyboard shortcut to accept the line suggestion with autocomplete?
    Dylson
    @n370
    Hey there
    question: How can I make pip3 install pgcli use psycopg2-binary instead of building it from source?
    Dylson
    @n370
    *using
    Adam Hopkins
    @ahopkins
    Anyone seen PQconninfo not available in libpq < 9.3 after installing and trying to sign in?
    I am trying on an installation of Postgres 9.4
    I have been able to login fine from a different machine
    Roger Pack
    @rdp
    As a note the link to the google group https://groups.google.com/forum/#!forum/pgcli says "This group either doesn't exist, or you don't have permission to access it. If you're sure this group exists, contact the Owner of the group and ask them to give you access." cheers!
    Ben Williamson
    @ben-williamson-1999
    Hi,
    Is there a way to download pgcli as a dependency to a project and use the cli to run sql scripts on it?
    Amjith Ramanujam
    @amjith
    @ben-williamson-1999 That seems possible. What project are you thinking about embedding pgcli into?
    Ben Williamson
    @ben-williamson-1999
    @amjith I have an existing application which talks to an oracle database using SQLcl (among other things) and was exploring other products which could talk to the new postgresql database. The current solution executes the sqlcl.jar in the code and this needs to be substituted with pgcli. Was wondering if this was possible with the way pgcli is created.
    Akiva
    @akiva_gitlab
    Hi,
    I'm a bit confused, the gallery shows every theme in dark/light mode but I can't find where to switch light/dark modes
    TheM3tabaron
    @TheM3tabaron
    https://pastebin.com/KMhdnVu3 trying to fix this issue on Arch. No success so far. Would It be possible to fix that permanently?
    keyring.errors.KeyringLocked: Failed to unlock the collection!
    TheM3tabaron
    @TheM3tabaron
    Running Seahorse brought no solution. I use no DM, just startx/i3wm
    TheM3tabaron
    @TheM3tabaron
    solved the issue. pgcli config. not sure why keyring is default. well.. pgcli rocks!
    Martin Seidl
    @mseidl
    pgcli posgresql://spk:sk@db.foo.de:5432/dbwhatev
    I've been using pgcli for years(?)
    and I recently did a fresh install of my system and re-installed pgcli, but now when I use the same connection string that was in my history sijnce forever, i get a psycopg2.ProgrammingError: invalid dsn: missing "=" after
    and the connection string
    it works with passing them separately like -p -w -u and so on
    Martin Seidl
    @mseidl
    but for some reason with that, while it does connect, I have to re-enter the password
    Alexander Artemenko
    @svetlyak40wt

    Guys, does pgcli have an option to not rollback current transaction?

    In psql this can be done by setting this option:

    \set ON_ERROR_ROLLBACK interactive
    Christopher Harrington
    @ironiridis

    As a note the link to the google group https://groups.google.com/forum/#!forum/pgcli says "This group either doesn't exist, or you don't have permission to access it. If you're sure this group exists, contact the Owner of the group and ask them to give you access." cheers!

    Echoing this; that group is either invite-only or dead

    Dylan
    @sinhast

    Hi everyone !
    I have a little problem with pgcli, currently when I log with psql on PostgreSQL, he ask my password, logic, but when I do the same thing with pgcli, he logs me directly without any password, but, it's a problem because it's the same with "postgres" role.

    So anyone who go on my pc if i'm away can do some shit >.<

    Thank you in advance for your help !

    boogo
    @boogo
    'NoneType' object has no attribute 'encoding'
    can not login
    why
    Daniel Beecham
    @dbeecham
    I'm encountering this error: keyring.errors.KeyringLocked: Failed to unlock the collection!, has anyone seen this before?
    Daniel Beecham
    @dbeecham
    For some reason, I entered keyring = False in .config/pgcli/config (in the [main] section), started - it works, and when I remove the line again, it still works. Don't know what was wrong. Can't find anything resonable wrong from a strace. Oh well.