On Wed, Dec 31, 2014, at 12:01 PM, dvlsg wrote:
Yeah, I think that would be problematic. All other sql query applications I've used in the past with autocomplete seem to parse the entire query and find table references for autocompletion based on the whole query, whereas psql seems to typically base autocomplete off of the current cursor location and strings behind it without any lookaheads (as far as I can tell -- I only took a brief look, and it's been a long time since I've had to write C code).I suppose what I would really be looking for is something like the vastly simplified query below, where pressing Ctrl+Space after each "a." would provide a list of columns only for the table alias.SELECTa.Column1,a.Column2,a.Column3FROMpublic.a_table_for_querying aIt looks like that would take a fairly significant bit of work/overhaul to make the autocomplete parser look at the entire query to find a list of used tables, and then find the list of available columns based on that, if I'm reading the code correctly.I agree with that last sentiment, though -- I don't think a list of every column from every table would be very helpful.
https://github.com/amjith/pgcli
Dave LesageClub Speed, Inc.Software Engineer4740 Green River Road, Suite #308Corona, CA 92880Email: [hidden email]24 Hour Support: (877) 751-3200International Support: (951) 817-7073This e-mail is covered by the Electronic Communications Privacy Act, 18 USC §§ 2510-2521 and is legally privileged. This communication and any accompanying document(s) are confidential and privileged. They are intended for the sole use of the addressee. If you receive this transmission in error, you are advised that any disclosure, copying, distribution, or the taking of any action in reliance upon the communication is strictly prohibited. If you have received this communication in error, please contact Club Speed, Inc. at (877) 751-3200.Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Attachment:
autocomplete.png
Description: PNG image
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
