? psql
Index: tab-complete.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v
retrieving revision 1.44
diff -c -r1.44 tab-complete.c
*** tab-complete.c	7 Mar 2002 04:45:53 -0000	1.44
--- tab-complete.c	7 Mar 2002 20:46:51 -0000
***************
*** 732,741 ****
  
  /* VACUUM */
  	else if (strcasecmp(prev_wd, "VACUUM") == 0)
! 		COMPLETE_WITH_QUERY("SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' UNION SELECT 'ANALYZE'::text");
! 	else if (strcasecmp(prev2_wd, "VACUUM") == 0 && strcasecmp(prev_wd, "ANALYZE") == 0)
  		COMPLETE_WITH_QUERY(Query_for_list_of_tables);
- 
  
  /* ... FROM ... */
  	else if (strcasecmp(prev_wd, "FROM") == 0)
--- 732,740 ----
  
  /* VACUUM */
  	else if (strcasecmp(prev_wd, "VACUUM") == 0)
! 		COMPLETE_WITH_QUERY("SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' UNION SELECT 'FULL'::text UNION SELECT 'ANALYZE'::text");
! 	else if (strcasecmp(prev2_wd, "VACUUM") == 0 && (strcasecmp(prev_wd, "FULL") == 0 || strcasecmp(prev_wd, "ANALYZE") == 0))
  		COMPLETE_WITH_QUERY(Query_for_list_of_tables);
  
  /* ... FROM ... */
  	else if (strcasecmp(prev_wd, "FROM") == 0)