pgcli
pgcli copied to clipboard
Postgres CLI with autocompletion and syntax highlighting
## Description Hello, I am interested in trying the PG extension Apache AGE with pgcli. Almost all uses of the extension is via the functions it provides. So, it would...
## Description In psql, when you run `\d+ `, the first line of output will look like this ``` Materialized view "public.matviewname" View "public.viewname" Table "public.tablename" ``` This is useful...
## Description It's not a "problem", rather a suggestion (with plan to act uppon). When releasing new versions, it would be nice if one could download the package from the...
## Description I am running a PostgreSQL server in a Docker container and using Secure TCP/IP Connections with SSL. In my `postgresql.conf` file, I include the following lines: ``` ssl...
Add types to typeshed so that this library can be statically analysed.
## Description Sets the session time zone to the system time zone after connecting. Adds [`tzlocal`](https://github.com/regebro/tzlocal/tree/master) as a dependency for a cross-platform way of getting the current time and handling...
Thank you guys for this very useful piece of software and all the time and effort put in mainting it. Here is my usecase, I want to set my pager...
## Description pgcli crashes when using `use` directive ## Your environment PostgreSQL 16.5 pgcli-4.1.0 Python 3.11 - FreeBSD 14.1 - 4.1.0 - zsh: command not found: pip (I install from...
## Description To be suggested autocompletion when setting the search_path, the keyword's suggestion "search_path TO" will be suggested on a "SET" token, only if the latter is the first token...
I have a section that contains character '#' in ~/.pg_service.conf, like ``` [staging_instance] host=XXXX port=5432 dbname=postgres user=root password=abc#123 ``` using psql could login successfully ``` ~# psql service=staging_instance psql (13.20,...