Reset
Restores runtime variables to their default settings.
Synopsis
RESET
variable
Parameters
variable
A runtime variable that you wish to reset to its default value. See the reference entry titled âSETâ for more information on available variables.
Results
RESET VARIABLE
The message returned when a specified variable is reset to its default value.
Description
Use the RESET
command to return runtime variables to their original
values. For more information about values allowed for these variables, and what the original
values were, refer to the reference entry titled âSET.â
You can also issue the following command to accomplish the same effect:
SET variable TO DEFAULT
Example
The following example resets a variable called SEED
to its default
value:
testdb=# RESET SEED;
RESET VARIABLE
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.