61.2.1 libpq Lisp Variables

Various Unix environment variables are used by libpq to provide defaults to the many different parameters. In the SXEmacs Lisp API, these environment variables are bound to Lisp variables to provide more convenient access to Lisp Code. These variables are passed to the backend database server during the establishment of a database connection and when the pq-setenv call is made.

Variable: pg:host

Initialized from the PGHOST environment variable. The default host to connect to.

Variable: pg:user

Initialized from the PGUSER environment variable. The default database user name.

Variable: pg:options

Initialized from the PGOPTIONS environment variable. Default additional server options.

Variable: pg:port

Initialized from the PGPORT environment variable. The default TCP port to connect to.

Variable: pg:tty

Initialized from the PGTTY environment variable. The default debugging TTY.

Compatibility note: Debugging TTYs are turned off in the SXEmacs Lisp binding.

Variable: pg:database

Initialized from the PGDATABASE environment variable. The default database to connect to.

Variable: pg:realm

Initialized from the PGREALM environment variable. The default Kerberos realm.

Variable: pg:client-encoding

Initialized from the PGCLIENTENCODING environment variable. The default client encoding.

Compatibility note: This variable is not present in non-Mule SXEmacsen. This variable is not present in versions of libpq prior to 7.0. In the current implementation, client encoding is equivalent to the file-name-coding-system format.

Variable: pg:authtype

Initialized from the PGAUTHTYPE environment variable. The default authentication scheme used.

Compatibility note: This variable is unused in versions of libpq after 6.5. It is not implemented at all in the SXEmacs Lisp binding.

Variable: pg:geqo

Initialized from the PGGEQO environment variable. Genetic optimizer options.

Variable: pg:cost-index

Initialized from the PGCOSTINDEX environment variable. Cost index options.

Variable: pg:cost-heap

Initialized from the PGCOSTHEAP environment variable. Cost heap options.

Variable: pg:tz

Initialized from the PGTZ environment variable. Default timezone.

Variable: pg:date-style

Initialized from the PGDATESTYLE environment variable. Default date style in returned date objects.

Variable: pg-coding-system

This is a variable controlling which coding system is used to encode non-ASCII strings sent to the database.

Compatibility Note: This variable is not present in InfoDock.