* Includes tab completion. It's not magic, but it's very cool. At any
Bruce Momjian <bruce@momjian.us>
* 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 <something> 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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/psql-ref.sgml | modified | +163 −169 |
| src/bin/psql/command.c | modified | +72 −49 |
| src/bin/psql/command.h | modified | +0 −4 |
| src/bin/psql/common.c | modified | +51 −51 |
| src/bin/psql/describe.c | modified | +485 −276 |
| src/bin/psql/describe.h | modified | +12 −20 |
| src/bin/psql/help.c | modified | +1 −1 |
| src/bin/psql/input.c | modified | +4 −2 |
| src/bin/psql/input.h | modified | +5 −10 |
| src/bin/psql/large_obj.c | modified | +8 −8 |
| src/bin/psql/large_obj.h | modified | +2 −1 |
| src/bin/psql/mainloop.c | modified | +79 −79 |
| src/bin/psql/Makefile.in | modified | +11 −3 |
| src/bin/psql/print.c | modified | +35 −33 |
| src/bin/psql/print.h | modified | +2 −2 |
| src/bin/psql/prompt.c | modified | +1 −1 |
| src/bin/psql/settings.h | modified | +5 −1 |
| src/bin/psql/startup.c | modified | +11 −11 |
| src/bin/psql/tab-complete.c | added | +812 −0 |
| src/bin/psql/tab-complete.h | added | +8 −0 |
| src/bin/psql/variables.h | modified | +2 −1 |
| src/bin/psql/win32.mak-old | modified | +0 −72 |