The OpenNET Project / Index page

[ новости/++ | форум | wiki | теги | ]

Интерактивная система просмотра системных руководств (man-ов)

 ТемаНаборКатегория 
 
 [Cписок руководств | Печать]

show (7)
  • show (1) ( Linux man: Команды и прикладные программы пользовательского уровня )
  • >> show (7) ( Linux man: Макропакеты и соглашения )
  •  

    NAME

    SHOW - show the value of a run-time parameter
    

     

    SYNOPSIS

    SHOW name
    SHOW ALL
    
    
     

    DESCRIPTION

    SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or through command-line flags when starting the postmaster. See the documentation for details.  

    PARAMETERS

    name
    The name of a run-time parameter. Available parameters are documented in the documentation and on the SET [set(7)] reference page. In addition, there are a few parameters that can be shown but not set:
    SERVER_VERSION
    Shows the server's version number.
    SERVER_ENCODING
    Shows the server-side character set encoding. At present, this parameter can be shown but not set, because the encoding is determined at database creation time.
    LC_COLLATE
    Shows the database's locale setting for collation (text ordering). At present, this parameter can be shown but not set, because the setting is determined at initdb time.
    LC_CTYPE
    Shows the database's locale setting for character classification. At present, this parameter can be shown but not set, because the setting is determined at initdb time.
    IS_SUPERUSER
    True if the current role has superuser privileges.

    ALL
    Show the values of all configuration parameters, with descriptions.
     

    NOTES

    The function current_setting produces equivalent output. See the documentation.  

    EXAMPLES

    Show the current setting of the parameter DateStyle:

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

    Show the current setting of the parameter geqo:

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

    Show all settings:

    SHOW ALL;
                  name              |            setting             |                                         description                                          
    --------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
     add_missing_from               | off                            | Automatically adds missing table references to FROM clauses.
     archive_command                | unset                          | WAL archiving command.
     australian_timezones           | off                            | Interprets ACST, CST, EST, and SAT as Australian time zones.
        .
        .
        .
     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)
    
    
     

    COMPATIBILITY

    The SHOW command is a PostgreSQL extension.  

    SEE ALSO

    SET [set(7)], RESET [reset(l)]


     

    Index

    NAME
    SYNOPSIS
    DESCRIPTION
    PARAMETERS
    NOTES
    EXAMPLES
    COMPATIBILITY
    SEE ALSO


    Поиск по тексту MAN-ов: 



      Закладки на сайте
      Проследить за страницей
    Created 1996-2017 by Maxim Chirkov  
    ДобавитьРекламаВебмастеруГИД  
    Hosting by Ihor