���s���p�����[�^�̌��݂̐ݒ��\������ SHOW

PostgreSQL �� ���ݎ��s���� psql �ŁA�p�����[�^��\������ɂ� "SHOW" �Ƃ����R�}���h���g�p���܂��B

psql=#  SHOW checkpoint_segments;

 checkpoint_segments
---------------------
 32
(1 row)

"SHOW ALL" ���ƈꗗ��\�����邱�Ƃ��ł��܂��B

psql=#  \x
psql=#  SHOW ALL;

-[ RECORD 1 ]-------------------------------------------------------------------
name        | allow_system_table_mods
setting     | off
description | Allows modifications of the structure of system tables.
-[ RECORD 2 ]-------------------------------------------------------------------
name        | application_name
setting     | psql
description | Sets the application name to be reported in statistics and logs.
-[ RECORD 3 ]-------------------------------------------------------------------
name        | archive_command
setting     | (disabled)
description | Sets the shell command that will be called to archive a WAL file.

Google �T�C�g������

Amazon�A�\�V�G�C�g