SHOW
目录
SHOW
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO
è¯è
è·
NAME
SHOW - æ¾ç¤ºè¿è¡æ¶åæ°çæ°å¼
SYNOPSIS
SHOW name
SHOW ALL
DESCRIPTION æè¿°
SHOW å°æ¾ç¤ºå½åè¿è¡æ¶åæ°çæ°å¼ã è¿äºåéå¯ä»¥éè¿ SET è¯- å¥æ¥è®¾ç½®ï¼æèéè¿ç¼è¾ postgresql.confï¼ æèéè¿ PGOPTIONS ç¯å¢åéï¼ï¼å¨ä½¿ç¨libpqæè以 libpq 为åºç¡çåºç¨çæ¶åãï¼ æèå¨postmasterå¯å¨æ¶ç¨å½ä»¤è¡åæ°æ¥è®¾ç½®ã åé Section 16.4 ‘‘Run-time Configuration’’ è·åç»èã
PARAMETERS åæ°
|
name |
è¿è¡æ¶åæ°çå称ãå¯ç¨çåæ°å¨
Section 16.4 ‘‘Run-time
Configuration’’
éé¢æææ¡£ï¼ä»¥å
SET [set(7)]
æå页ã
å¦å¤ï¼è¿æå 个åæ°å¯ä»¥æ¾ç¤ºï¼ä½æ¯ä¸è½è®¾ç½®ï¼
SERVER_VERSION
æ¾ç¤ºæå¡å¨ççæ¬å·ã
SERVER_ENCODING
æ¾ç¤ºæå¡å¨æçå- 符éç¼ç ãç®åï¼è¿ä¸ªåæ°åªè½æ¾ç¤ºä½ä¸è½è®¾ç½®ï¼ å 为ç¼ç æ¯å¨å建æ°æ®åºçæ¶åå³å®çã
LC_COLLATE
æ¾ç¤ºæ°æ®åºçå符éåºå设置ï¼å- 符顺åºï¼ãç®åï¼è¿ä¸ªåæ°åªè½æ¾ç¤º ä½ä¸è½è®¾ç½®ï¼å 为设置æ¯å¨ initdb çæ¶å设置çã
LC_CTYPE
为å- 符éåç±»æ¾ç¤ºæ°æ®åºçåºå设置ãç®åï¼è¿ä¸ªåæ°åªè½æ¾ç¤ºï¼ä¸è½è®¾ç½®ï¼ å 为å®ç设置æ¯å¨ initdb çæ¶åå³å®çã
IS_SUPERUSER
å¦æå½åäºå¡è®¤è¯æ è¯ç¬¦æè¶çº§ç¨æ·æéï¼å为çã
|
ALL |
æ¾ç¤ºææå½åä¼è¯åæ°ã
NOTES
å½æ° current_setting çæç¸åè¾åºã åé Section 9.13 ‘‘Miscellaneous Functions’’ ã
EXAMPLES ä¾å
æ¾ç¤ºå½å DateStyle ç设置ï¼
SHOW DateStyle;
DateStyle
-----------
ISO, MDY
(1 row)
æ¾ç¤ºåæ°geqoçå½å设置ï¼
SHOW geqo;
geqo
------
on
(1 row)
æ¾ç¤ºææ设置ï¼
SHOW ALL;
name | setting
-------------------------------+---------------------------------------
australian_timezones | off
authentication_timeout | 60
checkpoint_segments | 3
.
.
.
wal_debug | 0
wal_sync_method | fdatasync
(94 rows)
COMPATIBILITY å¼å®¹æ§
SHOW å½ä»¤æ¯ PostgreSQL æ©å±ã
SEE ALSO
SET [set(7)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh