dbcli/pgcli

Postgres CLI with autocompletion and syntax highlighting

Fernando Lucio Canizo

@fernandocanizo

Also tried:

$ python3 -m pgcli
/usr/bin/python3: No module named pgcli.__main__; 'pgcli' is a package and cannot be directly executed

Fernando Lucio Canizo

@fernandocanizo

There's nothing in /usr/local/bin

Fernando Lucio Canizo

@fernandocanizo

@jvidin use \copy ...

It works

locheng

@locheng

is it possible to save query result set to a file in TSV/CSV format?

Matthieu Guilbert

@gma2th

Hey, I created a PR few weeks ago, is anybody able to review it ? dbcli/pgcli#917

Fernando Lucio Canizo

@fernandocanizo

Hi all, I still haven't solved my problem with pgcli not running in Ubuntu 18.04 from August (!)

Today I decided to check on a new machine... I thought: maybe my python installation is screwed on the machines I tested because the dist-upgrade

So I launched a new VM an noticed pgcli is not even listed on 18.04

Fernando Lucio Canizo

@fernandocanizo

Forget what I just wrote: I was missing an update on the new machine, everything works perfect. So my problem on the dist-upgraded machine could be fixed by deploying a new one

Frank Sheiness

@syndesis

where does one set a default search_path ?

Smeilz

@Smeilz

Thank you for pgcli

Nice extention

@fernandocanizo try 1)pip install --upgrade requests

2)pip install psycopg2-binary

3) pip install pgcli --no-binary :all: psycopg2

Murtuza

@mzabuawala

Hi Team,

I am new to pgcli project, just setup my DEV environment on Linux Mint 19 Tara today, when I run py.test, I'm getting same error mentioned by @gma2th

Gibrain

@brain90

hi all, just wanna share my setup :

set multiline
set vi as keybindings
use pspg as default pager

[entering heaven]

Unmesh K

@unmeshk75

Hi - I am new to pgcli. I'm getting errors when trying to install it. Does pgcli work with Python 3 on Windows?

Error I see on >pip install pgcli:Failed building wheel for setproctitle
Running setup.py clean for setproctitle
Failed to build setproctitle
jupyter-console 5.2.0 has requirement prompt-toolkit<2.0.0,>=1.0.0, but you'll have prompt-toolkit 2.0.7 which is incompatible.
ipython 6.5.0 has requirement prompt-toolkit<2.0.0,>=1.0.15, but you'll have prompt-toolkit 2.0.7 which is incompatible.

Adi Nemer

@adinemer

hello

quick question

do i have to install postgre to use the cli or can i use it to access remote postgre servers

Matheus Rosa

@mdsrosa

Hello @adinemer

You don’t need to have PostgreSQL database installed. You can access remote databases. Here is our documentation page:

https://www.pgcli.com

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

Where communities thrive

People

Repo info

Activity