Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

reset(7) [centos man page]

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)
Man Page

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Unix

how do you change a configuration file during run time. (1 Reply)
Discussion started by: areef4u
1 Replies

2. Programming

Error while loading libstlport_gcc.so library

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)
Discussion started by: shafi2all
0 Replies

3. Shell Programming and Scripting

script help

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)
Discussion started by: mohan705
6 Replies

4. UNIX for Dummies Questions & Answers

SET Command removed the variables

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)
Discussion started by: spectator
2 Replies

5. UNIX for Dummies Questions & Answers

bash script & sql query

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)
Discussion started by: ixibits
6 Replies

6. UNIX for Dummies Questions & Answers

SET produces different results in a script?

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)
Discussion started by: losingit
4 Replies

7. Shell Programming and Scripting

Read all lines after a string appears in the file.

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)
Discussion started by: Nagaraja Akkiva
4 Replies

8. Shell Programming and Scripting

Can anybody change this into Linux shell scripts?

@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)
Discussion started by: monisha
5 Replies

9. UNIX for Dummies Questions & Answers

SET command

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)
Discussion started by: Nandy
2 Replies