• Bruce Momjian's avatar
    * Includes tab completion. It's not magic, but it's very cool. At any · 78bc83fe
    Bruce Momjian authored
    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
    78bc83fe
tab-complete.c 30.8 KB