pgcli

pgcli copied to clipboard

syntax error at or near "$" in parameter aggregation in named queries

1

## Description I am trying to create named queries with parameter aggregation, but I get `syntax error at or near "$"` errors. I tested with the queries from [the manual](https://www.pgcli.com/named_queries.md),...

dtluna

Wrong quotation in \ev

1

## Description `\ev schema.my_view` produces `CREATE OR REPLACE VIEW "schema.my_view"`. It *should* produce `... VIEW "schema"."my_view"`, I think (with quotes enclosing "schema" and "my_view" separately). The effect or this had...

Jakubzik

Is it ok to add pgcli as 1password shell plugin?

3

Hi, as I'm not affiliated with either projects I just wanted to make sure if it's ok to add pgcli as a 1Password shell plugin (or at least try to...

szymon

How to change default key bindings / hotkeys or assign new bindings

4

Hi! First of all, thanks for an amazing tool that helps a lot! I have a small question: Are there any ways to change default key bindings, or assign new...

shitcoding

\d+ doesn't show options of a table while psql does

1

## Description In psql, `\d+` shows options of a table. In pgcli, it didn't. **pgcli:** **psql:** ## Your environment ``` $ zsh --version zsh 5.8.1 (x86_64-ubuntu-linux-gnu) $ omz version master...

Ray-Eldath

Autocomplete offers no columns after one column named 'type'

2

## Description I work with a table that has a column named **type** If I write a query like: SELECT type, name, id FROM table; Then after typing the column...

ShootingStar91

TypeError: cannot use a string pattern on a bytes-like object

5

## Description When launching pgcli, I get the following error: ``` Exception in thread completion_refresh: Traceback (most recent call last): File "/usr/lib/python3.11/threading.py", line 1038, in _bootstrap_inner self.run() File "/usr/lib/python3.11/threading.py", line...

jumpnett

Allow default format for timestamps

6

## Description It'd be nice if I could set a default format for timestamp columns. For example, rather than seeing `2023-04-27 15:16:38.125568+00`, I'd prefer to see `2023-04-27 15:16:38` (or maybe...

truthdoug

The `psql` command supports using a `PSQL_EDITOR` environment variable in place of `EDITOR`. This is useful if you want to use a specific editor for SQL that differs from your...

sangaline

## Description If a transaction is manually started (`begin transaction;`) then an attempt to edit a postgres function or stored procedure is made via `\ef function_name`, pgcli will crash. Expected...

mqudsi