sql-postgres-options

sql-postgres-options is a variable defined in `sql.el'.
Its value is

("-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.

You can customize this variable.

This variable was introduced, or its default value was changed, in version 20.8 of Emacs.