SET
目录
SET
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS é项
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
SET - æ¹åè¿è¡æ¶åæ°
SYNOPSIS
SET [ SESSION |
LOCAL ] name { TO | = } { value |
’value’ | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL
| DEFAULT }
DESCRIPTION æè¿°
SET å½ä»¤ä¿®æ¹è¿è¡æ¶éç½®åæ°ã许å¤å¨ Section 16.4 ‘‘Run-time Configuration’’ éé¢ååºçè¿è¡æ¶åæ°å¯ä»¥ç¨ SET å¨è¿è¡æ¶è®¾ç½®ã ï¼ä½æ¯æäºè¦æ±ä½¿ç¨è¶çº§ç¨æ·æéæ¥ä¿®æ¹ï¼èå¶å®æäºåå¨æå¡å¨æèä¼è¯ å¼å§ä¹åä¸è½ä¿®æ¹ãï¼è¯·æ³¨æ SET åªå½±åå½åä¼è¯ä½¿ç¨çæ°å¼ã
å¦æ SET æè SET SESSION æ¯å¨ä¸ä¸ªç¨åéåºçäºå¡éååºçï¼ é£ä¹ SET å½ä»¤çææå°å¨äºå¡åæ»çä¹åå°æ¶ã ï¼è¿ä¸ªè¡ä¸ºåPostgreSQLçæ¬ 7.3 ä¹åçä¸åï¼ é£ä¸ªæ¶å SET çææå¨åé¢çé误ä¹åä¸ä¼åæ»ãï¼ ä¸æ¦åå´å®çäºå¡æ交ï¼é£ä¹å¶ææå°æç»å°äºå¡çç»æï¼é¤é被å¦å¤ä¸ä¸ª SET è¦çã
SET LOCAL çææåªæç»å°å½åäºå¡ç»æï¼ä¸ç®¡æ¯å¦æ交ã ä¸ä¸ªç¹ä¾æ¯å¨ä¸ä¸ªäºå¡éé¢ç SET åé¢è·çä¸ä¸ª SET LOCALï¼å¨äºå¡ç»æä¹ååªè½çå° SET LOCAL çæ°å¼ï¼ä½æ¯ä¹åï¼å¦æäºå¡æ交ï¼ï¼åæ¯ SET çå¼çæã
PARAMETERS é项
SESSION
声æè¿ä¸ªå½ä»¤åªå¯¹å½åä¼è¯èµ·ä½ç¨ã ï¼å¦æ SESSION æ LOCAL é½æ²¡åºç°ï¼é£ä¹è¿ä¸ªæ¯ç¼ºçãï¼
|
LOCAL |
声æ该å½ä»¤åªå¨å½åäºå¡ä¸ææãå¨ COMMIT æè ROLLBACK ä¹åï¼ä¼è¯çº§å«ç设置å°å次çæã 请注æå¦æå¨ BEGIN åä¹å¤è¿è¡ï¼é£ä¹ SET LOCAL å°è¡¨ç°åºæ²¡æä½ç¨ï¼å 为äºå¡å°ç«å³ç»æã
|
name |
å¯è®¾ç½®çè¿è¡æ¶åæ°çååãå¯ç¨çåæ°å¨ Section 16.4 ‘‘Run-time Configuration’’ åä¸é¢å½æ¡£ã
|
value |
åæ°çæ°å¼ãå¼å¯ä»¥å£°æ为å串常éï¼æ è¯ç¬¦ï¼æ°å- ï¼æèéå·åéçä¸é¢è¿äºä¸è¥¿çå表ã DEFAULT å¯ä»¥ç¨äºæè¿äºåæ°è®¾ç½®ä¸ºå®ä»¬ç缺çå¼ã
é¤äºå¨ Section 16.4 ‘‘Run-time Configuration’’ éé¢ææ档记载çéç½®åæ°ä¹å¤ï¼ è¿æå 个åªè½ç¨ SET å½ä»¤è®¾ç½®ï¼æèæ¯æç¹æ®çè¯æ³çåæ°ï¼
|
NAMES |
SET NAMES value æ¯ SET client_encoding TO value çå«åã |
|||
|
SEED |
为éæºæ°çæå¨ï¼å½æ° randomï¼è®¾ç½®åé¨çç§åã å许çå¼æ¯ä»äº 0 å 1 ä¹é´çæµ®ç¹æ°ï¼ç¶åå®ä¼è¢«ä¹ä»¥ 231-1ã
æ们ä¹å¯ä»¥éè¿è°ç¨å½æ° setseed æ¥è®¾ç½®ç§åï¼
SELECT setseed(value);
TIME ZONE
SET TIME ZONE value
æ¯ for SET timezone TO value
çä¸ä¸ªå«åã
è¯æ³ SET TIME ZONE
å许为æ¶åºè®¾ç½®ç¹æ®çè¯æ³ã
ä¸é¢æ¯ææå¼çä¾åï¼
’PST8PDT’
å å·ä¼¯åå©çæ¶åºã
’Portugal’
è¡èçæ¶åºã
’Europe/Rome’
æ大å©æ¶åºã
|
-7 |
UTC 以西 7 å°æ¶çæ¶åºï¼çæäº PDTï¼ã
INTERVAL ’-08:00’ HOUR TO MINUTE
UTC 以西 8 å°æ¶çæ¶åºï¼çæäº PSTï¼ã
|
LOCAL |
DEFAULT
å°æ¶åºè®¾ç½®ä¸ºä½ çæ¬å°æ¶åºï¼æå¡å¨çæä½ç³»ç»ç¼ºççé£ä¸ªï¼ã
åé Section 8.5 ‘‘Date/Time Types’’ è·åæå³æ¶åºçæ´å¤ç»èã
NOTES 注æ
å½æ° set_config æä¾äºçæçåè½ã åé Section 9.13 ‘‘Miscellaneous Functions’’ ã
EXAMPLES ä¾å
设置模å¼æ索路å¾ï¼
SET search_path TO my_schema, public;
ææ¥ææ¶é´é£æ ¼è®¾ç½®ä¸ºä¼ ç»ç POSTGRES é£æ ¼ï¼ with ‘‘day before month’’ input convention:
SET datestyle TO postgres, dmy;
ææ¶åºè®¾ç½®ä¸ºå å·ä¼¯ååï¼ ä½¿ç¨åå¼å·ä¿åæ¶åºå£°æé大åå符çå±æ§ ï¼æ³¨æè¿éçæ¥æ/æ¶é´æ ¼å¼æ¯ PostgreSQLï¼ï¼
SET TIME ZONE
’PST8PDT’;
SELECT current_timestamp AS today;
today
-------------------------------
2003-04-29 15:02:01.218622-07
COMPATIBILITY å¼å®¹æ§
SET TIME ZONE æ©å±äºå¨ SQL æ åéå®ä¹çè¯æ³ã æ ååªå许æä¸ä¸ªæ°åæ¶åºåç§»ï¼ è PostgreSQL è¿å许å®æ´æ´çµæ´»çæ¶åºå£°æã ææå¶å®ç SET ç¹æ§é½æ¯ PostgreSQL æ©å±ã
SEE ALSO åè§
RESET [reset(7)], SHOW [show(l)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh