diff options
| author | Thomas G. Lockhart | 1997-05-16 07:13:54 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart | 1997-05-16 07:13:54 +0000 |
| commit | 07f01fc274071373063d87657c434120fa1f7e4a (patch) | |
| tree | 7500cd0dd7bc644c0a7e5e606d24415b047c1ce4 /src/man/set.l | |
| parent | d7a85cb2c9ea23ba76dbcd155a123c7a0589530f (diff) | |
Add documentation for reset, set, and show, and cross-reference in built-in.
Diffstat (limited to 'src/man/set.l')
| -rw-r--r-- | src/man/set.l | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/src/man/set.l b/src/man/set.l new file mode 100644 index 0000000000..47c42ef51d --- /dev/null +++ b/src/man/set.l @@ -0,0 +1,85 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.1 1997/05/16 07:13:52 thomas Exp $ +.TH SET SQL 05/14/97 PostgreSQL PostgreSQL +.SH NAME +set \(em set run-time parameters for session +.SH SYNOPSIS +.nf +\fBset\fR variable \fBto\fR 'value1[,value2 ...]' +.fi +.SH DESCRIPTION +.BR Set +will modify configuration parameters for +.IR variable +during a session. +.PP +Current values can be obtained using +.IR show (l), +and values can be restored to the defaults using +.IR reset (l). +Parameters and values are case-insensitive. +Note that the value field is always specified as a string, so +is enclosed in single-quotes. +.PP +.IR DateStyle +determines the output format for the date and time data types. +See +.IR "built-in" (3) +for more information on available styles. + +.if n .ta 5 +15 +40 +.if t .ta 0.5i +1.5i +3.0i +.in 0 +.nf +DateStyle + ISO - use ISO 8601-style dates and times + SQL - use Oracle/Ingres-style dates and times + Postgres - use traditional Postgres format + European - use dd/mm/yyyy for numeric date representations. + NonEuropean - use mm/dd/yyyy for numeric date representations. + US - same as 'NonEuropean' + default - restores the default values ('US,Postgres') +.fi +.PP +.IR GEQO +enables or disables the genetic optimizer algorithm. This algorithm is +.IR on +by default. See the GEQO README for more information. + +.if n .ta 5 +15 +40 +.if t .ta 0.5i +1.5i +3.0i +.in 0 +.nf +GEQO + on - turn the genetic optimizer 'on' + off - duh +.fi + +.SH EXAMPLES +.nf +-- +--Set the style of date to ISO +-- +set DateStyle to 'ISO' +.fi +.PP +.nf +-- +--Set the style of date to SQL with European conventions +-- +set DateStyle to 'SQL,European' +.fi +.PP +.nf +-- +--Turn off the genetic optimizer +-- +set GEQO to 'off' +.fi +.SH "SEE ALSO" +built-in(3), +reset(l), +show(l). +.SH BUGS +Of course. |