4 ms·
I usually begin my queries by typing "SELECT * FROM", and then go back to the * after I've done everything else. There's a bonus in doing that - you get auto c
by HeavyStorm 7y ago
I usually begin my queries by typing "SELECT * FROM", and then go back to the * after I've done everything else.
There's a bonus in doing that - you get auto completion from the editors on many cases if you've filled the from first.
- edgarvaldes 7y agoThis is exactly what I do, and for the same reasons.
- mritchie712 7y agoI do this too, so the autocomplete in SeekWell automatically does this, check it out: https://www.loom.com/share/9c7979a163eb4513b3320e6e90c66079 https://www.loom.com/share/9c7979a163eb4513b3320e6e90c66079 If you type just a table name into an empty cell it will autocomplete with a full SELECT statement. e.g. if you typed "pubuser" and selected "public.users" it would autocomplete with: SELECT pu.* FROM public.users AS pu WHERE 1=1 Disclaimer: I built this.