RESET(7) PostgreSQL 9.2.7 Documentation RESET(7)NAME
RESET - restore the value of a run-time parameter to the default value
SYNOPSIS
RESET configuration_parameter
RESET ALL
DESCRIPTION
RESET restores run-time parameters to their default values. RESET is an alternative spelling for
SET configuration_parameter TO DEFAULT
Refer to SET(7) for details.
The default value is defined as the value that the parameter would have had, if no SET had ever been issued for it in the current session.
The actual source of this value might be a compiled-in default, the configuration file, command-line options, or per-database or per-user
default settings. This is subtly different from defining it as "the value that the parameter had at session start", because if the value
came from the configuration file, it will be reset to whatever is specified by the configuration file now. See Chapter 18, Server
Configuration, in the documentation for details.
The transactional behavior of RESET is the same as SET: its effects will be undone by transaction rollback.
PARAMETERS
configuration_parameter
Name of a settable run-time parameter. Available parameters are documented in Chapter 18, Server Configuration, in the documentation
and on the SET(7) reference page.
ALL
Resets all settable run-time parameters to default values.
EXAMPLES
Set the timezone configuration variable to its default value:
RESET timezone;
COMPATIBILITY
RESET is a PostgreSQL extension.
SEE ALSO SET(7), SHOW(7)PostgreSQL 9.2.7 2014-02-17 RESET(7)
Check Out this Related Man Page
RESET(7) SQL Commands RESET(7)NAME
RESET - restore the value of a run-time parameter to a default value
SYNOPSIS
RESET variable
RESET ALL
INPUTS
variable
The name of a run-time parameter. See SET [set(7)] for a list.
ALL Resets all settable run-time parameters to default values.
DESCRIPTION
RESET restores run-time parameters to their default values. Refer to SET [set(7)] for details. RESET is an alternate spelling for
SET variable TO DEFAULT
The default value is defined as the value that the variable would have had, had no SET ever been issued for it in the current session. The
actual source of this value might be a compiled-in default, the postmaster's configuration file or command-line switches, or per-database
or per-user default settings. See the Administrator's Guide for details.
See the SET manual page for details on the transaction behavior of RESET.
DIAGNOSTICS
See under the SET [set(7)] command.
EXAMPLES
Set DateStyle to its default value:
RESET DateStyle;
Set geqo to its default value:
RESET GEQO;
COMPATIBILITY
RESET is a PostgreSQL extension.
SQL - Language Statements 2002-11-22 RESET(7)
I am getting error while processing the below line : "DEPENDENCIES=$OMNIWORKS_PATH/tradewind/build/build_dg_c $(SET) "*.pcc" $(SET).pcctmp1 ".cc" h" ...
---------------------------------------------
! ----------------------------------------------------------------------------
! Build rule... (0 Replies)
Hi
Below is the i/p of my file ,first read the 1st line of the file 'i.e:SET DBASE_TARGETTABLE TO 'XX_SW' and replace with
SET DBASE_TARGETTABLE TO 'XX_tW and read the last line 'i.e : .SET TARGETTABLE TO 'TABLE135044' and replce with i/p file name (If my i/p file name is... (6 Replies)
Hi,
Im using csh and sometimes bash.
I accidentally typed SET and looks like it has resetted some enviroment variables as im not able to run autosys jobs etc ..
So i wanted to know how i can put it back to normal by replacing any profile files from another user or by editing the file which... (2 Replies)
Hi Guys,
I would like with this script
"DATA=`ora123 su -c 'echo "SET HEADING OFF;\n SET FEED OFF;\n select USER NAME, ACCOUNT_STATUS from dba_users;\n exit" | sqlplus / as sysdba -s /' `
echo $DATA >> $DAT"
make a sql query, but the statement
"select USER NAME, ACCOUNT_STATUS from... (6 Replies)
Hi all,
So wondering if anyone has ever come across this...
I know if you run SET command you can see a listing of all your shell variables. HOWEVER, if you create a script in vi, and in that script you issue a set command, it does not return the variables when you run the file after making... (4 Replies)
Hi All,
I want to read all lines after a perticular string {SET UP VALUES}apprears in the file.
SET UP values contains direcory, number of days and file type.
Step1: Read all lines below SET UP VALUES string.
Step2: If set up values are not present in each record then read from default... (4 Replies)
@echo off
SET "p0=%~0"
SET "p1=%~1"
SET "p2=%~2"
SET "p3=%~3"
SET "p4=%~4"
SET "p5=%~5"
SET "p6=%~6"
SET "p7=%~7"
SET "p8=%~8"
SET "p9=%~9"
SHIFT
SET "p10=%~9"
SHIFT
SET "p11=%~9"
SET "zip_path=D:\OraOutput\interco\%p10%"
echo Program... (5 Replies)
Hi Friends,
There is an command that,
SET -x
I am confused with the SET command , i have gone through man page but still.
could anyone advise the same and necessity of the SET command ?
Regards,
Nantha. (2 Replies)