|
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.54 2002/08/02 18:15:09 tgl Exp $ |
| 6 | + * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.55 2002/08/04 05:01:57 momjian Exp $ |
7 | 7 | */ |
8 | 8 |
|
9 | 9 | /*---------------------------------------------------------------------- |
@@ -567,8 +567,10 @@ psql_completion(char *text, int start, int end) |
567 | 567 | */ |
568 | 568 | elseif ((strcasecmp(prev3_wd,"GRANT")==0||strcasecmp(prev3_wd,"REVOKE")==0)&& |
569 | 569 | strcasecmp(prev_wd,"ON")==0) |
570 | | -COMPLETE_WITH_QUERY("SELECT relname FROM pg_catalog.pg_class WHERE relkind in ('r','i','S','v') AND substr(relname,1,%d)='%s' |
571 | | -UNIONSELECTnspnameFROMpg_catalog.pg_namespace;"); |
| 570 | +COMPLETE_WITH_QUERY("SELECT relname FROM pg_catalog.pg_class " |
| 571 | +"WHERE relkind in ('r','i','S','v') AND " |
| 572 | +"substr(relname,1,%d)='%s' UNION " |
| 573 | +"SELECT nspname FROM pg_catalog.pg_namespace;"); |
572 | 574 | /* Complete "GRANT * ON * " with "TO" */ |
573 | 575 | elseif (strcasecmp(prev4_wd,"GRANT")==0&&strcasecmp(prev2_wd,"ON")==0) |
574 | 576 | COMPLETE_WITH_CONST("TO"); |
|