Is there something that provides auto-completion for PostgreSQL? I'm looking for something similar to RedGate's SQLPrompt. Currently using pgAdmin III's query tool but willing to consider other query editors.
5 Answers
Simple answer below:
I spent a long time trying to get tab-complete to work on the psql client AND the SQL shell (psql) client. Here's what you do.
Stop trying and use the client found here: pgcli
I installed using pip, opened the client using >pgcli -Upostgres, and entered the same password created with I installed Postgresql. Tab-completion works and I'm good to go.
To use autocomplete, begin typing your query; when you would like the Query editor to suggest object names or commands that might be next in your query, press the Control+Space key combination.
Related