Flashnux

GNU/Linux man pages

• CentOS
• Debian
• Red Hat
• Ubuntu
• Unix

Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :

ISBN : 978-2-7460-9712-4
EAN : 9782746097124
(Editions ENI)

GNU/Linux	RedHat 5.2 (Apollo)
	set(l)

---

SET

NAME
SYNOPSIS
DESCRIPTION
EXAMPLES
SEE ALSO
BUGS

---

NAME

set - set run-time parameters for session

SYNOPSIS

set variable to ’value1[,value2 ...]’

DESCRIPTION

Set will modify configuration parameters for variable during a session.

Current values can be obtained using show(l), and values can be restored to the defaults using 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.

DateStyle determines the output format for the date and time data types. See pgbuiltin(3) for more information on available styles.

DateStyle Values

	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’)

GEQO enables or disables the genetic optimizer algorithm. This algorithm is on by default, which used GEQO for statements of eight or more tables. See the GEQO README for more information.

GEQO Values

	on	- use for statements with 8 or more tables
	on=10	- use for statements with 10 or more tables
	off	- do not use the genetic optimizer

R_PLANS enables or disables right-hand evaluation of plans. It may be useful when joining big relations with small ones. This algorithm is off by default. It’s not used by GEQO anyway.

R_PLANS Values

	on	- turn right-hand plan evaluation ’on’
	off	- do not use right-hand plan evaluation

EXAMPLES

--
--Set the style of date to ISO
--
set DateStyle to ’ISO’

--
--Set the style of date to SQL with European conventions
--
set DateStyle to ’SQL,European’

--
--Use GEQO for statements with 4 or more tables
--
set GEQO to ’on=4’
--
--Turn off the genetic optimizer
--
set GEQO to ’off’

SEE ALSO

pgbuiltin(3), reset(l), show(l).

BUGS

Of course.

---

---

set(l)