dbcli/pgcli

Postgres CLI with autocompletion and syntax highlighting

Karmenzind

@Karmenzind

Hey guys. I got module 'keyring.errors' has no attribute 'KeyringLocked when running pgcli -D xxx. Any advice?

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.

Risto Novik

@riston

Hello, how can I set the application name for pgcli?

I hope there some people active here, the last message is from Jan 16

johnpherson

@johnpherson

Anyone know how to turn multiline on

johnpherson

@johnpherson

Never mind it's f3

Adrian Adamski

@korda

does pgcli has persistent history? if yes is there a file in which it is stored?

Juliano

@julianodba

Hi, How can I fix the below message please?
postgres> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/lib/python3.8/threading.py", line 932, in _bootstrap_inner
self.run()
File "/usr/lib/python3.8/threading.py", line 870, in runs-mode Refreshing completions...
self._target(self._args, *self._kwargs)
File "/usr/share/pgcli/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/share/pgcli/pgcli/completion_refresher.py", line 110, in refresh_tables
completer.extend_foreignkeys(executor.foreignkeys())
File "/usr/share/pgcli/pgcli/pgcompleter.py", line 278, in extend_foreignkeys
childcolmeta = meta[childschema][childtable][childcol]
KeyError: 'my_partitioned_table'

pgcli -v
Version: 2.2.0

cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04 LTS (Focal Fossa)"

PostgreSQL 11.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

Juliano

@julianodba

python3 --version
Python 3.8.2

Telmo "Trooper"

@telmotrooper

Hello, guys! I cloned the source to try and disable line wrapping when displaying query results, but I realized I could just edit variable pager in .config/pgcli/configto less -S.

Is it common for people to change their pager? Because I feel most people will never even realize there is such an option... My initial thought was to implement a toggle option in the menu like [F5] Disable line wrapping, which would change the pager to less -S or revert it back to whichever one was previously set. I'd like to hear your opinions.

1 reply

I work with tables with many columns and usually my first query is SELECT * since at first I'm not sure which fields will be important, the default behavior of wrapping the lines makes it very confusing to read the output.

Nand Kishore

@knand4930

time out error

amazon web server

Jim Angelo Beren

@jeeeem

Is there anyone using pgcli in arch linux? its not working for me. but the psql is working

Rodrigo O.

@AkioCode

Hi, all !
Is it possible to add some snippets/shortcuts commands like in this article customizing pgclirc ?
https://opensourcedbms.com/dbms/psqlrc-psql-startup-file-for-postgres/

1 reply

But first of all, I would like to thank to all colaborators of pgcli ! Really nice !

Dominic Bou-Samra

@dbousamra

Hi all. Love pgcli. I'm wondering if there is any provisions for allowing changing the background color of the terminal (or font) when connected to a particular database. My use case is I want to 100% know if I am on production

Renato Flores

@Renato776

Hi all. I really love pgcli, I already loved vanilla psql so I didn't know it could get any better! I'm just wondering if anyone has suggestions for how to quickly see/edit PG stored procedures?

Where communities thrive

People

Repo info

Activity