pgcli
pgcli copied to clipboard
Postgres CLI with autocompletion and syntax highlighting
## Description I would like to extend the functionality in confirm_destructive_query to allow for asking of a password. I feel like the Y/N is great, but I am super paranoid,...
## 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...
I would like to run some commands on start up, like \x. Is this possible?
## Description I use pspg and table_format csv in pgcli. This works well for long result sets with lots of rows (more than one page or screen). I pass --quit-if-one-screen...
## Description I'd really enjoy it if `\e [file]` could provide file name completion like `\i filename` does. I like to store common queries in a directory. I can execute...
## Description Using the standard services syntax to connect, e.g. ``` psql service=myservice ``` Does not appear to work with pgcli? I noticed that this was supposedly fixed with #1035...
## Description With this SQL: ```sql CREATE EXTENSION hstore; CREATE OR REPLACE FUNCTION no_labels() RETURNS hstore AS $$ SELECT hstore(ARRAY[]::text[]) $$ language sql immutable; CREATE OR REPLACE FUNCTION labels() RETURNS...
## Description Azure specific postgres databases cannot be set as DSN Azure Postgres users are in the format of user@server_name, and the extra @ confuses pgcli For example one entry...
Hi, i can't get function keys (F2, F3, F4) to work with pgcli and iterm(OSX). everything is working fine with osx terminal, and function keys do work in iterm and...
## 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...