|
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.43 2002/03/05 00:01:03 momjian Exp $ |
| 6 | + * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.44 2002/03/07 04:45:53 momjian Exp $ |
7 | 7 | */ |
8 | 8 |
|
9 | 9 | /*---------------------------------------------------------------------- |
@@ -141,7 +141,7 @@ pgsql_thing_t words_after_create[] = { |
141 | 141 | * a good idea. */ |
142 | 142 | {"RULE","SELECT rulename FROM pg_rules WHERE substr(rulename,1,%d)='%s'"}, |
143 | 143 | {"SEQUENCE","SELECT relname FROM pg_class WHERE relkind='S' and substr(relname,1,%d)='%s'"}, |
144 | | -{"TABLE","SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s'"}, |
| 144 | +{"TABLE","SELECT relname FROM pg_class WHERE(relkind='r' or relkind='v') and substr(relname,1,%d)='%s'"}, |
145 | 145 | {"TEMP",NULL},/* for CREATE TEMP TABLE ... */ |
146 | 146 | {"TRIGGER","SELECT tgname FROM pg_trigger WHERE substr(tgname,1,%d)='%s'"}, |
147 | 147 | {"TYPE","SELECT typname FROM pg_type WHERE substr(typname,1,%d)='%s'"}, |
|