Autocomplete SQL after JOIN definition (pgAdmin4 4.x can do it)
Autocomplete SQL after JOIN definition (pgAdmin4 4.x can do it)
3
votes
![](https://secure.gravatar.com/avatar/b3c2d31e5ec07b6847d9f8e8abe7dd7e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Jeremy commented
I love this feature of pgAdmin. Offering multiple join autocomplete suggestions would be great, but even just one suggestion that matches everything I might want to join on based on table FKs and column names would be fine. Deleting text is always faster than typing out all of the joins myself.
-
Marc Büttner commented
Example:
SELECT * FROM "LFSPos" lp
INNER JOIN "LFS" l ON l. --[NO AUTOCOMPLETE AFTER "l."]