(In psql:)
I need to modify the 2nd prompt. So i looked at the sources:
I leave the validity test (of the name of the option/param) to SetVariable !!



Here is the patch:

diff -c /internet/cvs/pgsql/src/bin/psql/command.c.~1~ 
/internet/cvs/pgsql/src/bin/psql/command.c
*** /internet/cvs/pgsql/src/bin/psql/command.c.~1~      Tue Feb  6 22:26:00 2001
--- /internet/cvs/pgsql/src/bin/psql/command.c  Tue Feb  6 22:26:00 2001
***************
*** 1745,1750 ****
--- 1745,1760 ----
        }
  
  
+ 
+       /* toggle use of pager */
+       else if (strncmp(param, "PROMPT",6) == 0)
+       {
+         SetVariable(pset.vars, param, value); /* SetVariable takes care of whether 
+param is actually valid !! */
+       }
+ 
+ 
+ 
+ 
        else
        {
                psql_error("\\pset: unknown option: %s\n", param);





diff -c /internet/cvs/pgsql/src/bin/psql/tab-complete.c.~2~ 
/internet/cvs/pgsql/src/bin/psql/tab-complete.c
*** /internet/cvs/pgsql/src/bin/psql/tab-complete.c.~2~ Tue Feb  6 22:24:06 2001
--- /internet/cvs/pgsql/src/bin/psql/tab-complete.c     Tue Feb  6 22:24:06 2001
***************
*** 706,713 ****
        else if (strcmp(prev_wd, "\\pset") == 0)
        {
                char       *my_list[] = {"format", "border", "expanded", "null", 
"fieldsep",
!                       "tuples_only", "title", "tableattr", "pager",
!               "recordsep", NULL};
  
                COMPLETE_WITH_LIST(my_list);
        }
--- 706,713 ----
        else if (strcmp(prev_wd, "\\pset") == 0)
        {
                char       *my_list[] = {"format", "border", "expanded", "null", 
"fieldsep",
!                                        "tuples_only", "title", "tableattr", "pager", 
!                                        "PROMPT1","PROMPT2","PROMPT3","recordsep", 
NULL};
  
                COMPLETE_WITH_LIST(my_list);
        }

Reply via email to