Provide * autocompletion of all columns of a table #779
tobias-haenel
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
I would like to have autocompletion for * to add in all column names if the table can be uniquely identified:
(e.g. in select and update/insert with returning clause)
should expand to
where
id,column_aandcolumn_bare all columns of the tablefood.this would simplify capturing the current db schema state of a table into a sql query file.
later schema changes wouldn't break any queries or lead to unnecessary data transmission.
right now I need to enumerate all columns manually.
I would also be fine if a custom id/character to trigger where used to trigger this completion or to make it optional, so that is doesn't collide with the standard
*usage.thanks for you work on this urgently needed work in the ecosystem of LSPs and Postgres!
All reactions