PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

SHOW

劉䓄

SHOW -- 滆䴺誊臯施埗昄䔇唚

臺濘

SHOW name
SHOW ALL

柟誄

SHOW 儖滆䴺嘷嬉誊臯施埗昄䔇昄唚㔗認底埻麟埇傖锔誺 SET 臺埖㔕䚡膏 postgresql.conf 桺傽㔕PGOPTIONS 䯇嵄埻麟(婘嘪䫘嘺庯 libpq 䔇庫䫘䘋废䔇施唍)㔕劇媘 postgres 䔇变傴臯埗昄準螆䘞㔗埗黙䆹17诙埡䂖誗㔗

埗昄

name

誊臯施埗昄䔇劉䓄㔗埇䫘䔇埗昄婘䆹17傖埪 SET 欋喯釕麯麵橬桺懼㔗埥崡誻橬庹婻埗昄埇傖滆䴺嘖滇婉脘螆䘞

SERVER_VERSION

滆䴺橉媇単䔇䬽橸埙

SERVER_ENCODING

滆䴺橉媇単䆇䔇庖严镖䚡乕㔗䕞嬉認婻埗昄埻脘滆䴺嘖婉脘螆䘞啹婺䚡乕滇婘录傺昄扞康䔇施唍喿垔䔇㔗

LC_COLLATE

滆䴺昄扞康䔇庖严镖寺嘘螆䘞(庖严釺废)㔗䕞嬉認婻埗昄埻脘滆䴺嘖婉脘螆䘞啹婺垄滇婘 initdb 䔇施唍螆䘞䔇㔗

LC_CTYPE

婺庖严镖彖䌂滆䴺昄扞康䔇寺嘘螆䘞㔗䕞嬉認婻埗昄埻脘滆䴺嘖婉脘螆䘞啹婺垄滇婘 initdb 䔇施唍螆䘞䔇㔗

IS_SUPERUSER

套悩嘷嬉庋媇螴臕湺臖严橬轙亓䫘潙溄鍊彍婺䩘㔗

ALL

滆䴺欔橬陉䘞埗昄埗昄傖埪噽柟誄

濘懟

庘昄 current_setting 䫘潊䕩劯䔇膷庺㔗埗黙誗9.20㔗

冋床

滆䴺嘷嬉 DateStyle 螆䘞

SHOW DateStyle;
 DateStyle
-----------
 ISO, MDY
(1 row)

滆䴺埗昄 geqo 䔇嘷嬉螆䘞

SHOW geqo;
 geqo
------
 on
(1 row)

滆䴺欔橬螆䘞

SHOW ALL;
              name              |            setting             |                                         description                                          
--------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
 add_missing_from               | off                            | Automatically adds missing table references to FROM clauses.
 archive_command                | unset                          | WAL archiving command.
    .
    .
    .
 work_mem                       | 1024                           | Sets the maximum memory to be used for query workspaces.
 zero_damaged_pages             | off                            | Continues processing past damaged page headers.
(146 rows)

噚垹攓

SHOW 变傴滇 PostgreSQL 欷匘㔗

埽蓕

SET, RESET
劯锔饡釕嬉誕
SET TRANSACTION婪婔亓START TRANSACTION