pgcli icon indicating copy to clipboard operation
pgcli copied to clipboard

Postgres CLI with autocompletion and syntax highlighting

Results 162 pgcli issues
Sort by recently updated
recently updated
newest added

## Description select * from table_name limit 10; OK!!! select * from table_name; garbled!!! ![中文乱码](https://github.com/dbcli/pgcli/assets/54530758/4967561e-83ba-4a31-90b7-0447226dbbca) ![编码信息](https://github.com/dbcli/pgcli/assets/54530758/356297ef-d8ca-4ab1-a506-3817192873ce) ## Your environment os: win10 Server: PostgreSQL 11.3 pgcli-Version: 3.5.0 - [ ] What...

This reference to session in pgcli.magic [conn.session.engine.url](https://github.com/dbcli/pgcli/blob/89979a93538d81b43c5a79c95d3c268dd32cf1d2/pgcli/magic.py#L43 ) raises an AttributeError for the current HEAD version of ipython-sql (after https://github.com/catherinedevlin/ipython-sql/commit/9fbf83baff3739757b494c9776d4dfeac275d5d2). It can be changed to just `conn.url`. However, it's probably...

like this: ![изображение](https://github.com/dbcli/pgcli/assets/1572969/11b01b7f-5604-4f24-9fa3-80647cf93ca2) ``` ┌───┬───┬───┐ │ 1 │ 2 │ 3 │ ├───┼───┼───┤ │ 4 │ 5 │ 6 │ └───┴───┴───┘ ```

## Description This is not an issue but more of a feature request. I love this tool. I am wondering if it's possible to look into the environment variables when...

## Description I love the autocompletion of pgcli. I love that it does completion of the columns I'm selecting _after_ I've added the `FROM tablename` to the query. So, I...

## Description I think it can be helpfull to have: 1. An ability to edit named quieries in my \editor (f.ex. vim): with \n familly command - maybe \ne 2....

## Description Hello Installing pgcli 3.5.0 on a Debian server with postgresql 15, when, as unix user postgres, I run a simple `pgcli`, I get a proper prompt, but as...

## Description Whenever I run a query that returns lots of rows the pager (`less`) gets activated (this is fine) if I then press `q` to exit the pager, then...

Is there any way to both output to the pager & to a file? something similar to psql's `--log-file` ? right now if you enable output to file there are...

regular output (mainly query results) goes to the pager. status output goes directly to stdout. both implement a consistent interface for easy mocking in tests. ## Description Picking up where...