Variable: sql-postgres-options

sql-postgres-options is a customizable variable defined in sql.el.gz.

Value

("-P" "pager=off")

Documentation

List of additional options for sql-postgres-program.

The default setting includes the -P option which breaks older versions of the psql client (such as version 6.5.3). The -P option is equivalent to the --pset option. If you want the psql to prompt you for a user name, add the string "-u" to the list of options. If you want to provide a user name on the command line (newer versions such as 7.1), add your name with a "-U" prefix (such as "-Umark") to the list.

This variable was added, or its default value changed, in Emacs 20.8.

Source Code

;; Defined in /usr/src/emacs/lisp/progmodes/sql.el.gz
(defcustom sql-postgres-options '("-P" "pager=off")
  "List of additional options for `sql-postgres-program'.
The default setting includes the -P option which breaks older versions
of the psql client (such as version 6.5.3).  The -P option is equivalent
to the --pset option.  If you want the psql to prompt you for a user
name, add the string \"-u\" to the list of options.  If you want to
provide a user name on the command line (newer versions such as 7.1),
add your name with a \"-U\" prefix (such as \"-Umark\") to the list."
  :type '(repeat string)
  :version "20.8")