aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-03-07 04:45:53 +0000
committerBruce Momjian <bruce@momjian.us>2002-03-07 04:45:53 +0000
commit609f71b760d64f8ff512a5caa23d4803f664bd84 (patch)
treef4ec73fb6430d82cf4a4fed8e9086316096b841f
parent9178b7fceae1e2b44e2741bcd0f23b0ccc4bdb9f (diff)
downloadpostgresql-609f71b760d64f8ff512a5caa23d4803f664bd84.tar.gz
postgresql-609f71b760d64f8ff512a5caa23d4803f664bd84.zip
Also an small change to the tab-complete feature of psql which allows to
use tables and views interchangeably. Manuel Sugawara
-rw-r--r--src/bin/psql/tab-complete.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 85296fc1999..e5f3816442f 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -3,7 +3,7 @@
*
* Copyright 2000 by PostgreSQL Global Development Group
*
- * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.43 2002/03/05 00:01:03 momjian Exp $
+ * $Header: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v 1.44 2002/03/07 04:45:53 momjian Exp $
*/
/*----------------------------------------------------------------------
@@ -141,7 +141,7 @@ pgsql_thing_t words_after_create[] = {
* a good idea. */
{"RULE", "SELECT rulename FROM pg_rules WHERE substr(rulename,1,%d)='%s'"},
{"SEQUENCE", "SELECT relname FROM pg_class WHERE relkind='S' and substr(relname,1,%d)='%s'"},
- {"TABLE", "SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s'"},
+ {"TABLE", "SELECT relname FROM pg_class WHERE (relkind='r' or relkind='v') and substr(relname,1,%d)='%s'"},
{"TEMP", NULL}, /* for CREATE TEMP TABLE ... */
{"TRIGGER", "SELECT tgname FROM pg_trigger WHERE substr(tgname,1,%d)='%s'"},
{"TYPE", "SELECT typname FROM pg_type WHERE substr(typname,1,%d)='%s'"},