Comments (7)
Yes it would be a useful feature and I want to do it.
It's hard to tell if it'll be easy to do or not. It'll require some parsing changes to parse_utils file.
https://github.com/amjith/pgcli/blob/master/pgcli/packages/parseutils.py#L11
You're welcome to take a stab at it.
from pgcli.
hi,
i submitted a pull request (#83) that adds double quote escapes for table/column names with spaces, symbols, non-ascii chars and mixed-cased letters.
from pgcli.
PR #83 overlaps with this feature request. It add auto-escaping to the columns/tables that are keywords or Uppercased or spaces. But it doesn't do auto-completion if the user opens a double quote.
So I'm leaving this issue open to track that feature. :)
Cheers!
from pgcli.
Hi,
yes I noticed this too but I wasn't sure what had to changed. Maybe just the cleanup_regex
in parseutils.py
?
If it's something that requires more work you could give me some pointers an i'll look into it ... but maybe your quicker doing it yourself.
from pgcli.
I think it should be a as simple as adding/removing stuff in the cleanup_regex.
I haven't had time to deep dive into the code since I announced it. Barely keeping up with reviewing PRs and answering Issues. You're welcome to take a stab at it, otherwise I hope to spend some time this weekend to work on it. :)
Cheers!
from pgcli.
This commit afef77a fixes the auto-completion for quoted tables/columns that are auto-escaped.
from pgcli.
This is now released in v0.12.0.
https://pypi.python.org/pypi/pgcli/0.12.0
from pgcli.
Related Issues (20)
- pgcli disconnects when closing pager with `q` HOT 5
- Output to file in addition to the pager?
- Named Queries more user firendly
- [feature request] Unicode table HOT 1
- Using environment variables to connect via ssh HOT 2
- pgcli 4.0 - ModuleNotFoundError: No module named 'six' HOT 7
- pgcli.magic `conn.session.engine.url` raises AttributeError after breaking change upstream in ipython-sql
- Raised notices are printed backwards HOT 3
- Segfault on MacOs HOT 2
- Doesn't work with Python 3.11/Windows HOT 6
- Tab completion not working in version 4.0.1 on macOS
- pendulum dependency cannot be installed on 32-bit arches HOT 4
- Autocomplete not working for Apache AGE extension function names HOT 1
- Boolean type always show `false` HOT 9
- `invalid input syntax for type oid: "{oid}"` when running \d on an index HOT 4
- Per-database prompt colours HOT 1
- psycopg.errors.DataCorrupted: missing chunk number 0 for toast value 16386 in pg_toast_2619 HOT 3
- Can not quit pgcli if server has shutdown
- Readme link - this page has moved HOT 1
- Document how to replace pg_isready with pgcli HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgcli.