|
3 | 3 | *
|
4 | 4 | * Copyright 2000 by PostgreSQL Global Development Group
|
5 | 5 | *
|
6 |
| - * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.44 2002/03/0704:45:53 momjian Exp $ |
| 6 | + * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.45 2002/03/0720:48:41 momjian Exp $ |
7 | 7 | */
|
8 | 8 |
|
9 | 9 | /*----------------------------------------------------------------------
|
@@ -732,11 +732,10 @@ psql_completion(char *text, int start, int end)
|
732 | 732 |
|
733 | 733 | /* VACUUM */
|
734 | 734 | elseif (strcasecmp(prev_wd,"VACUUM")==0)
|
735 |
| -COMPLETE_WITH_QUERY("SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' UNION SELECT 'ANALYZE'::text"); |
736 |
| -elseif (strcasecmp(prev2_wd,"VACUUM")==0&&strcasecmp(prev_wd,"ANALYZE")==0) |
| 735 | +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"); |
| 736 | +elseif (strcasecmp(prev2_wd,"VACUUM")==0&&(strcasecmp(prev_wd,"FULL")==0||strcasecmp(prev_wd,"ANALYZE")==0)) |
737 | 737 | COMPLETE_WITH_QUERY(Query_for_list_of_tables);
|
738 | 738 |
|
739 |
| - |
740 | 739 | /* ... FROM ... */
|
741 | 740 | elseif (strcasecmp(prev_wd,"FROM")==0)
|
742 | 741 | COMPLETE_WITH_QUERY(Query_for_list_of_tables);
|
|