From 78bc83fedf7f865534c61dd14067fc80d580ed29 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 26 Nov 1999 04:24:17 +0000 Subject: * Includes tab completion. It's not magic, but it's very cool. At any rate it's better than what used to be there. * Does proper SQL "host variable" substitution as pointed out by Andreas Zeugwetter (thanks): select * from :foo; Also some changes in how ':' and ';' are treated (escape with \ to send to backend). This does _not_ affect the '::' cast operator, but perhaps others that contain : or ; (but there are none right now). * To show description with a listing, append '?' to command name, e.g., \df?. This seemed to be the convenient and logical solution. Or append a '+' to see more useless information, e.g., \df+. * Fixed fflush()'ing bug pointed out by Jan during the regression test discussion. * Added LastOid variable. This ought to take care of TODO item "Add a function to return the last inserted oid, for use in psql scripts" (under CLIENTS) E.g., insert into foo values(...); insert into bar values(..., :LastOid); \echo $LastOid * \d command shows constraints, rules, and triggers defined on the table (in addition to indices) * Various fixes, optimizations, corrections * Documentation update as well Note: This now requires snprintf(), which, if necessary, is taken from src/backend/port. This is certainly a little weird, but it should suffice until a source tree cleanup is done. Enjoy. -- Peter Eisentraut Sernanders väg 10:115 --- src/bin/psql/variables.h | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/bin/psql/variables.h') diff --git a/src/bin/psql/variables.h b/src/bin/psql/variables.h index c8c3a0adaea..06493b49d86 100644 --- a/src/bin/psql/variables.h +++ b/src/bin/psql/variables.h @@ -11,7 +11,8 @@ #define VARIABLES_H #include -#define VALID_VARIABLE_CHARS "abcdefghijklmnopqrstuvwxyz0123456789_" +#define VALID_VARIABLE_CHARS "abcdefghijklmnopqrstuvwxyz"\ + "ABCDEFGHIJKLMNOPQRSTUVWXYZ" "0123456789_" struct _variable { -- cgit v1.2.3