PHP Manual

PEAR Manual

Smarty Manual

PostgreSQL

MySQL Manual

Perl Manual

19.4. database configuration

recall from chapter 17 that the postgresql server provides a large number of run-time configuration variables. you can set database-specific default values for many of these settings.

for example, if for some reason you want to disable the geqo optimizer for a given database, you'd ordinarily have to either disable it for all databases or make sure that every connecting client is careful to issue set geqo to off;. to make this setting the default within a particular database, you can execute the command

alter database mydb set geqo to off;

this will save the setting (but not set it immediately). in subsequent connections to this database it will appear as though set geqo to off; had been executed just before the session started. note that users can still alter this setting during their sessions; it will only be the default. to undo any such setting, use alter database dbname reset varname;.