Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
query_tool_toolbar.doctree212 linesDownload Raw Back to .doctrees
1�����sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _query_tool_toolbar:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��query-tool-toolbar�u�tagname�h3�line�K�parent�h�	_document�h�source��mD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\query_tool_toolbar.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h�`Query Tool Toolbar`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Query Tool Toolbar��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����Query Tool Toolbar�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(h��The *Query Tool* toolbar uses context-sensitive icons that provide shortcuts to5frequently performed tasks. If an icon is highlighted, the option is enabled;6if the icon is grayed-out, the task is disabled.�h]�(hJ�The �����}�(h hWh!hh"NhNubh	�emphasis���)��}�(h�*Query Tool*�h]�hJ�7Query Tool�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�� toolbar uses context-sensitive icons that provide shortcuts to8frequently performed tasks. If an icon is highlighted, the option is enabled;9if the icon is grayed-out, the task is disabled.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�note���)��}�(h��The :ref:`Query Tool <query_tool>` and10:ref:`View/Edit Data <editgrid>` tools are actually different operating11modes of the same tool. Some controls will be disabled in either mode.�h]�hV)��}�(h��The :ref:`Query Tool <query_tool>` and12:ref:`View/Edit Data <editgrid>` tools are actually different operating13modes of the same tool. Some controls will be disabled in either mode.�h]�(hJ�The �����}�(h hh!hh"NhNubh�pending_xref���)��}�(h�:ref:`Query Tool <query_tool>`�h]�h	�inline���)��}�(hh�h]�hJ�14Query Tool�����}�(h h�h!hh"NhNubah}�(h]�h]�(�xref��std��std-ref�eh]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]��refdoc��query_tool_toolbar��	refdomain�h��reftype��ref��refexplicit���refwarn���	reftarget��15query_tool�uhh�h"h#hKh hubhJ� and16�����}�(h hh!hh"NhNubh�)��}�(h� :ref:`View/Edit Data <editgrid>`�h]�h�)��}�(hh�h]�hJ�View/Edit Data�����}�(h h�h!hh"NhNubah}�(h]�h]�(h��std��std-ref�eh]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]��refdoc�h��	refdomain�h��reftype��ref��refexplicit���refwarn��h��editgrid�uhh�h"h#hKh hubhJ�n tools are actually different operating17modes of the same tool. Some controls will be disabled in either mode.�����}�(h hh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h{ubah}�(h]�h]�h]�h]�h]�uhhyh"h#hKh h&h!hubh	�image���)��}�(h�T.. image:: images/query_toolbar.png18    :alt: Query tool toolbar19    :align: center20�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool toolbar��align��center��uri��images/query_toolbar.png��21candidates�}��*�h�suhh�h"h#hKh h&h!hubhV)��}�(h�[Hover over an icon in pgAdmin to display a tooltip that describes the icon's22functionality.�h]�hJ�]Hover over an icon in pgAdmin to display a tooltip that describes the icon’s23functionality.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh%)��}�(hhh]�(h*)��}�(h�File Options�h]�hJ�File Options�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jh!hh"h#hKubh	�table���)��}�(hhh]�h	�tgroup���)��}�(hhh]�(h	�colspec���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jubh	�thead���)��}�(hhh]�h	�row���)��}�(hhh]�(h	�entry���)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jOh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jLubah}�(h]�h]�h]�h]�h]�uhjJh jGubjK)��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h jfh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jcubah}�(h]�h]�h]�h]�h]�uhjJh jGubjK)��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j}h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jzubah}�(h]�h]�h]�h]�h]�uhjJh jGubeh}�(h]�h]�h]�h]�h]�uhjEh jBubah}�(h]�h]�h]�h]�h]�uhj@h jubh	�tbody���)��}�(hhh]�(jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Open File*�h]�h`)��}�(hj�h]�hJ�	Open File�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�QClick the *Open File* icon to display a previously saved query in the SQL Editor.�h]�(hJ�24Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Open File*�h]�hJ�	Open File�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�< icon to display a previously saved query in the SQL Editor.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�
Accesskey + O�h]�hJ�
Accesskey + O�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Save File*�h]�h`)��}�(hjh]�hJ�	Save File�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h jubah}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�(hV)��}�(h�hClick the *Save* icon to perform a quick-save of a previously saved query, or to access the25*Save* menu:�h]�(hJ�26Click the �����}�(h j1h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j9h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j1ubhJ�L icon to perform a quick-save of a previously saved query, or to access the27�����}�(h j1h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h jKh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j1ubhJ� menu:�����}�(h j1h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j.ubh	�block_quote���)��}�(h��* Select *Save* to save the selected content of the SQL Editor panel in a  file.28 29* Select *Save As* to open a new browser dialog and specify a new location to which to save the30  selected content of the SQL Editor panel.�h]�h	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(h�OSelect *Save* to save the selected content of the SQL Editor panel in a  file.31�h]�hV)��}�(h�NSelect *Save* to save the selected content of the SQL Editor panel in a  file.�h]�(hJ�Select �����}�(h jth!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j|h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jtubhJ�A to save the selected content of the SQL Editor panel in a  file.�����}�(h jth!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h jpubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK%h jkubjo)��}�(h��Select *Save As* to open a new browser dialog and specify a new location to which to save the32selected content of the SQL Editor panel.�h]�hV)��}�(h��Select *Save As* to open a new browser dialog and specify a new location to which to save the33selected content of the SQL Editor panel.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�	*Save As*�h]�hJ�Save As�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�w to open a new browser dialog and specify a new location to which to save the34selected content of the SQL Editor panel.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK'h jkubeh}�(h]�h]�h]�h]�h]��bullet�h�uhjih"h#hK%h jeubah}�(h]�h]�h]�h]�h]�uhjch"h#hK%h j.ubeh}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�hV)��}�(h�
Accesskey + S�h]�hJ�
Accesskey + S�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j�ubah}�(h]�h]�h]�h]�h]�uhjJh jubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubeh}�(h]�h]�h]�h]�h]�uhj�h jubeh}�(h]�h]�h]�h]�h]��cols�Kuhjh jubah}�(h]�h]�(�	longtable��colwidths-given�eh]�h]�h]�uhjh jh!hh"h#hNubeh}�(h]��file-options�ah]�h]��file options�ah]�h]�uhh$h h&h!hh"h#hKubh%)��}�(hhh]�(h*)��}�(h�Filter/Limit Options�h]�hJ�Filter/Limit Options�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jh!hh"h#hK,ubj)��}�(hhh]�j)��}�(hhh]�(j!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j%ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j%ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j%ubjA)��}�(hhh]�jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jOh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jLubah}�(h]�h]�h]�h]�h]�uhjJh jIubjK)��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h jfh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jcubah}�(h]�h]�h]�h]�h]�uhjJh jIubjK)��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j}h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jzubah}�(h]�h]�h]�h]�h]�uhjJh jIubeh}�(h]�h]�h]�h]�h]�uhjEh jFubah}�(h]�h]�h]�h]�h]�uhj@h j%ubj�)��}�(hhh]�(jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Filter*�h]�h`)��}�(hj�h]�hJ�Filter�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�(hV)��}�(h��Click the *Filter* icon to set filtering and sorting criteria for the data when in *View/Edit data35mode*. Click the down arrow to access other filtering and sorting options:�h]�(hJ�36Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Filter*�h]�hJ�Filter�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�A icon to set filtering and sorting criteria for the data when in �����}�(h j�h!hh"NhNubh`)��}�(h�*View/Edit data37mode*�h]�hJ�View/Edit data38mode�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�E. Click the down arrow to access other filtering and sorting options:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j�ubjd)��}�(hX�* In the *SQL Filter*, you can enter a SQL query as filtering criteria.39  In *Data Sorting*, you can select the column and specify the order for sorting.40 41* Click *Filter by Selection* to show only the rows containing the values in the selected cells.42 43* Click *Exclude by Selection* to show only the rows that do not contain the values in the44  selected cells.45 46* Click *Remove Sort/Filter* to remove any previously selected sort or filtering options.�h]�jj)��}�(hhh]�(jo)��}�(h��In the *SQL Filter*, you can enter a SQL query as filtering criteria.47In *Data Sorting*, you can select the column and specify the order for sorting.48�h]�hV)��}�(h��In the *SQL Filter*, you can enter a SQL query as filtering criteria.49In *Data Sorting*, you can select the column and specify the order for sorting.�h]�(hJ�In the �����}�(h jh!hh"NhNubh`)��}�(h�*SQL Filter*�h]�hJ�50SQL Filter�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�6, you can enter a SQL query as filtering criteria.51In �����}�(h jh!hh"NhNubh`)��}�(h�*Data Sorting*�h]�hJ�Data Sorting�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�>, you can select the column and specify the order for sorting.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK8h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK8h j�ubjo)��}�(h�_Click *Filter by Selection* to show only the rows containing the values in the selected cells.52�h]�hV)��}�(h�^Click *Filter by Selection* to show only the rows containing the values in the selected cells.�h]�(hJ�Click �����}�(h j?h!hh"NhNubh`)��}�(h�*Filter by Selection*�h]�hJ�Filter by Selection�����}�(h jGh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j?ubhJ�C to show only the rows containing the values in the selected cells.�����}�(h j?h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK;h j;ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK;h j�ubjo)��}�(h�iClick *Exclude by Selection* to show only the rows that do not contain the values in the53selected cells.54�h]�hV)��}�(h�hClick *Exclude by Selection* to show only the rows that do not contain the values in the55selected cells.�h]�(hJ�Click �����}�(h jih!hh"NhNubh`)��}�(h�*Exclude by Selection*�h]�hJ�Exclude by Selection�����}�(h jqh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jiubhJ�L to show only the rows that do not contain the values in the56selected cells.�����}�(h jih!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK=h jeubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK=h j�ubjo)��}�(h�WClick *Remove Sort/Filter* to remove any previously selected sort or filtering options.�h]�hV)��}�(hj�h]�(hJ�Click �����}�(h j�h!hh"NhNubh`)��}�(h�*Remove Sort/Filter*�h]�hJ�Remove Sort/Filter�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�= to remove any previously selected sort or filtering options.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK@h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK@h j�ubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hK8h j�ubah}�(h]�h]�h]�h]�h]�uhjch"h#hK8h j�ubeh}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�
Accesskey + F�h]�hJ�
Accesskey + F�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Limit Selector�h]�hJ�Limit Selector�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�\Select a value in the *Limit Selector* to limit the size of the dataset to a number of rows.�h]�(hJ�Select a value in the �����}�(h jh!hh"NhNubh`)��}�(h�*Limit Selector*�h]�hJ�Limit Selector�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�6 to limit the size of the dataset to a number of rows.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh jubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�
Accesskey + R�h]�hJ�
Accesskey + R�����}�(h j-h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh j*ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubeh}�(h]�h]�h]�h]�h]�uhj�h j%ubeh}�(h]�h]�h]�h]�h]��cols�Kuhjh j"ubah}�(h]�h]�(�	longtable�jeh]�h]�h]�uhjh jh!hh"h#hNubeh}�(h]��filter-limit-options�ah]�h]��filter/limit options�ah]�h]�uhh$h h&h!hh"h#hK,ubh%)��}�(hhh]�(h*)��}�(h�Query Editing Options�h]�hJ�Query Editing Options�����}�(h jfh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jch!hh"h#hKFubh�)��}�(h�\.. image:: images/query_editing.png57    :alt: Query tool editing options58    :align: center59�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool editing options��align��center��uri��images/query_editing.png�h�}�h�j�suhh�h"h#hKHh jch!hubj)��}�(hhh]�j)��}�(hhh]�(j!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubjA)��}�(hhh]�jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubah}�(h]�h]�h]�h]�h]�uhj@h j�ubj�)��}�(hhh]�(jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Edit*�h]�h`)��}�(hjh]�hJ�Edit�����}�(h j
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j	ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKSh jubah}�(h]�h]�h]�h]�h]��morerows�KuhjJh jubjK)��}�(hhh]�hV)��}�(h�YUse the *Edit* menu to search, replace, or navigate the code displayed in the SQL Editor:�h]�(hJ�Use the �����}�(h j*h!hh"NhNubh`)��}�(h�*Edit*�h]�hJ�Edit�����}�(h j2h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j*ubhJ�K menu to search, replace, or navigate the code displayed in the SQL Editor:�����}�(h j*h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKSh j'ubah}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�h}�(h]�h]�h]�h]�h]�uhjJh jubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�MSelect *Find* to provide a search target, and search the SQL Editor contents.�h]�(hJ�Select �����}�(h jeh!hh"NhNubh`)��}�(h�*Find*�h]�hJ�Find�����}�(h jmh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jeubhJ�@ to provide a search target, and search the SQL Editor contents.�����}�(h jeh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKUh jbubah}�(h]�h]�h]�h]�h]�uhjJh j_ubjK)��}�(hhh]�hV)��}�(h�Cmd+F�h]�hJ�Cmd+F�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKUh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j_ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�]Select *Replace* to locate and replace (with prompting) individual occurrences of the target.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�	*Replace*�h]�hJ�Replace�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�M to locate and replace (with prompting) individual occurrences of the target.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�(Option+Cmd+F (MAC)60Ctrl+Shift+F (Others)�h]�hJ�(Option+Cmd+F (MAC)61Ctrl+Shift+F (Others)�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�MSelect *Go to Line/Column* to go to specified line number and column position�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�*Go to Line/Column*�h]�hJ�Go to Line/Column�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�3 to go to specified line number and column position�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Cmd+L or Ctrl+L�h]�hJ�Cmd+L or Ctrl+L�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh jubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�@Select *Indent Selection* to indent the currently selected text.�h]�(hJ�Select �����}�(h j@h!hh"NhNubh`)��}�(h�*Indent Selection*�h]�hJ�Indent Selection�����}�(h jHh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j@ubhJ�' to indent the currently selected text.�����}�(h j@h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h j=ubah}�(h]�h]�h]�h]�h]�uhjJh j:ubjK)��}�(hhh]�hV)��}�(h�Tab�h]�hJ�Tab�����}�(h jih!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h jfubah}�(h]�h]�h]�h]�h]�uhjJh j:ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�SSelect *Unindent Selection* to remove indentation from the currently selected text.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�*Unindent Selection*�h]�hJ�Unindent Selection�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�8 to remove indentation from the currently selected text.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�	Shift+Tab�h]�hJ�	Shift+Tab�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�_Select *Toggle Comment* to comment/uncomment any lines that contain the selection in SQL style.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�*Toggle Comment*�h]�hJ�Toggle Comment�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�H to comment/uncomment any lines that contain the selection in SQL style.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK`h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Cmd+/�h]�hJ�Cmd+/�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK`h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�6Select *Clear Query* to clear the query editor window.�h]�(hJ�Select �����}�(h jh!hh"NhNubh`)��}�(h�
*Clear Query*�h]�hJ�Clear Query�����}�(h j#h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�" to clear the query editor window.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh jubah}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�hV)��}�(h�Cmd+.�h]�hJ�Cmd+.�����}�(h jDh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh jAubah}�(h]�h]�h]�h]�h]�uhjJh jubeh}�(h]�h]�h]�h]�h]�uhjEh jubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�QSelect *Format SQL* to format the selected SQL or all the SQL if none is selected�h]�(hJ�Select �����}�(h jdh!hh"NhNubh`)��}�(h�*Format SQL*�h]�hJ�62Format SQL�����}�(h jlh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jdubhJ�> to format the selected SQL or all the SQL if none is selected�����}�(h jdh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKdh jaubah}�(h]�h]�h]�h]�h]�uhjJh j^ubjK)��}�(hhh]�hV)��}�(h�Shift+Cmd+K�h]�hJ�Shift+Cmd+K�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKdh j�ubah}�(h]�h]�h]�h]�h]�uhjJh j^ubeh}�(h]�h]�h]�h]�h]�uhjEh jubeh}�(h]�h]�h]�h]�h]�uhj�h j�ubeh}�(h]�h]�h]�h]�h]��cols�Kuhjh j�ubah}�(h]�h]�(�	longtable�jeh]�h]�h]�uhjh jch!hh"h#hNubeh}�(h]��query-editing-options�ah]�h]��query editing options�ah]�h]�uhh$h h&h!hh"h#hKFubh%)��}�(hhh]�(h*)��}�(h�Query Execution�h]�hJ�Query Execution�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j�h!hh"h#hKhubh�)��}�(h�^.. image:: images/query_execution.png63    :alt: Query tool execute options64    :align: center65�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool execute options��align��center��uri��images/query_execution.png�h�}�h�j�suhh�h"h#hKjh j�h!hubj)��}�(hhh]�j)��}�(hhh]�(j!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h j�ubjA)��}�(hhh]�jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j	ubah}�(h]�h]�h]�h]�h]�uhjJh j	ubjK)��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j)	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j&	ubah}�(h]�h]�h]�h]�h]�uhjJh j	ubjK)��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j@	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh j=	ubah}�(h]�h]�h]�h]�h]�uhjJh j	ubeh}�(h]�h]�h]�h]�h]�uhjEh j		ubah}�(h]�h]�h]�h]�h]�uhj@h j�ubj�)��}�(hhh]�(jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Stop*�h]�h`)��}�(hjk	h]�hJ�Stop�����}�(h jm	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ji	ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh jf	ubah}�(h]�h]�h]�h]�h]�uhjJh jc	ubjK)��}�(hhh]�hV)��}�(h�MClick the *Stop* icon to cancel the execution of the currently running query.�h]�(hJ�66Click the �����}�(h j�	h!hh"NhNubh`)��}�(h�*Stop*�h]�hJ�Stop�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�	ubhJ�= icon to cancel the execution of the currently running query.�����}�(h j�	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh j�	ubah}�(h]�h]�h]�h]�h]�uhjJh jc	ubjK)��}�(hhh]�hV)��}�(h�
Accesskey + Q�h]�hJ�
Accesskey + Q�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKuh j�	ubah}�(h]�h]�h]�h]�h]�uhjJh jc	ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Execute script*�h]�h`)��}�(hj�	h]�hJ�Execute script�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�	ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKwh j�	ubah}�(h]�h]�h]�h]�h]�uhjJh j�	ubjK)��}�(hhh]�(hV)��}�(h��Click the *Execute script* icon to either execute or refresh the query highlighted in the SQL67editor panel. Click the down arrow to access other execution options:�h]�(hJ�68Click the �����}�(h j�	h!hh"NhNubh`)��}�(h�*Execute script*�h]�hJ�Execute script�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�	ubhJ�� icon to either execute or refresh the query highlighted in the SQL69editor panel. Click the down arrow to access other execution options:�����}�(h j�	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKwh j�	ubjd)��}�(hXl* Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back70  a transaction if an error occurs during the transaction.71 72* Add a check next to *Auto commit?* to instruct the server to automatically commit each73  transaction.  Any changes made by the transaction will be visible to others, and74  durable in the event of a crash.�h]�jj)��}�(hhh]�(jo)��}�(h��Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back75a transaction if an error occurs during the transaction.76�h]�hV)��}�(h��Add a check next to *Auto rollback on error?* to instruct the server to automatically roll back77a transaction if an error occurs during the transaction.�h]�(hJ�Add a check next to �����}�(h j78h!hh"NhNubh`)��}�(h�*Auto rollback on error?*�h]�hJ�Auto rollback on error?�����}�(h j%79h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j80ubhJ�k to instruct the server to automatically roll back81a transaction if an error occurs during the transaction.�����}�(h j82h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKzh j83ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hKzh j84ubjo)��}�(h��Add a check next to *Auto commit?* to instruct the server to automatically commit each85transaction.  Any changes made by the transaction will be visible to others, and86durable in the event of a crash.�h]�hV)��}�(h��Add a check next to *Auto commit?* to instruct the server to automatically commit each87transaction.  Any changes made by the transaction will be visible to others, and88durable in the event of a crash.�h]�(hJ�Add a check next to �����}�(h jG89h!hh"NhNubh`)��}�(h�*Auto commit?*�h]�hJ�Auto commit?�����}�(h jO90h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jG91ubhJ�� to instruct the server to automatically commit each92transaction.  Any changes made by the transaction will be visible to others, and93durable in the event of a crash.�����}�(h jG94h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK}h jC95ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK}h j96ubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hKzh j97ubah}�(h]�h]�h]�h]�h]�uhjch"h#hKzh j�	ubeh}�(h]�h]�h]�h]�h]�uhjJh j�	ubjK)��}�(hhh]�hV)��}�(h�F5�h]�hJ�F5�����}�(h j�98h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKwh j99ubah}�(h]�h]�h]�h]�h]�uhjJh j�	ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�	*Explain*�h]�h`)��}�(hj�100h]�hJ�Explain�����}�(h j�101h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�102ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�103ubah}�(h]�h]�h]�h]�h]�uhjJh j�104ubjK)��}�(hhh]�hV)��}�(h��Click the *Explain* icon to view an explanation plan for the current query. The result of the105EXPLAIN is displayed graphically on the *Explain* tab of the output panel, and in text106form on the *Data Output* tab.�h]�(hJ�107Click the �����}�(h j�108h!hh"NhNubh`)��}�(h�	*Explain*�h]�hJ�Explain�����}�(h j�109h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�110ubhJ�s icon to view an explanation plan for the current query. The result of the111EXPLAIN is displayed graphically on the �����}�(h j�112h!hh"NhNubh`)��}�(h�	*Explain*�h]�hJ�Explain�����}�(h j�113h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�114ubhJ�2 tab of the output panel, and in text115form on the �����}�(h j�116h!hh"NhNubh`)��}�(h�
*Data Output*�h]�hJ�Data Output�����}�(h j�117h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�118ubhJ� tab.�����}�(h j�119h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�120ubah}�(h]�h]�h]�h]�h]�uhjJh j�121ubjK)��}�(hhh]�hV)��}�(h�F7�h]�hJ�F7�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jubah}�(h]�h]�h]�h]�h]�uhjJh j�122ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Explain analyze*�h]�h`)��}�(hj1h]�hJ�Explain analyze�����}�(h j3h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j/ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j,ubah}�(h]�h]�h]�h]�h]�uhjJh j)ubjK)��}�(hhh]�(hV)��}�(h�[Click the *Explain analyze* icon to invoke an EXPLAIN ANALYZE command on the current query.�h]�(hJ�123Click the �����}�(h jOh!hh"NhNubh`)��}�(h�*Explain analyze*�h]�hJ�Explain analyze�����}�(h jWh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jOubhJ�@ icon to invoke an EXPLAIN ANALYZE command on the current query.�����}�(h jOh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jLubhV)��}�(h�VNavigate through the *Explain Options* menu to select options for the EXPLAIN command:�h]�(hJ�Navigate through the �����}�(h joh!hh"NhNubh`)��}�(h�*Explain Options*�h]�hJ�Explain Options�����}�(h jwh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h joubhJ�0 menu to select options for the EXPLAIN command:�����}�(h joh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jLubjd)��}�(hX�* Select *Verbose* to display additional information regarding the query plan.124 125* Select *Costs* to include information on the estimated startup and total cost of each126  plan node, as well as the estimated number of rows and the estimated width of each127  row.128 129* Select *Buffers* to include information on buffer usage.130 131* Select *Timing* to include information about the startup time and the amount of time132  spent in each node of the query.133 134* Select *Summary* to include the summary information about the query plan.135 136* Select *Settings* to include the information on the configuration parameters.137 138* Select *Wal* to include the information on WAL record generation.�h]�jj)��}�(hhh]�(jo)��}�(h�MSelect *Verbose* to display additional information regarding the query plan.139�h]�hV)��}�(h�LSelect *Verbose* to display additional information regarding the query plan.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�	*Verbose*�h]�hJ�Verbose�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�< to display additional information regarding the query plan.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h��Select *Costs* to include information on the estimated startup and total cost of each140plan node, as well as the estimated number of rows and the estimated width of each141row.142�h]�hV)��}�(h��Select *Costs* to include information on the estimated startup and total cost of each143plan node, as well as the estimated number of rows and the estimated width of each144row.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�*Costs*�h]�hJ�Costs�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�� to include information on the estimated startup and total cost of each145plan node, as well as the estimated number of rows and the estimated width of each146row.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�9Select *Buffers* to include information on buffer usage.147�h]�hV)��}�(h�8Select *Buffers* to include information on buffer usage.�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�	*Buffers*�h]�hJ�Buffers�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�( to include information on buffer usage.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�vSelect *Timing* to include information about the startup time and the amount of time148spent in each node of the query.149�h]�hV)��}�(h�uSelect *Timing* to include information about the startup time and the amount of time150spent in each node of the query.�h]�(hJ�Select �����}�(h jh!hh"NhNubh`)��}�(h�*Timing*�h]�hJ�Timing�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�f to include information about the startup time and the amount of time151spent in each node of the query.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�JSelect *Summary* to include the summary information about the query plan.152�h]�hV)��}�(h�ISelect *Summary* to include the summary information about the query plan.�h]�(hJ�Select �����}�(h jBh!hh"NhNubh`)��}�(h�	*Summary*�h]�hJ�Summary�����}�(h jJh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jBubhJ�9 to include the summary information about the query plan.�����}�(h jBh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j>ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�NSelect *Settings* to include the information on the configuration parameters.153�h]�hV)��}�(h�MSelect *Settings* to include the information on the configuration parameters.�h]�(hJ�Select �����}�(h jlh!hh"NhNubh`)��}�(h�154*Settings*�h]�hJ�Settings�����}�(h jth!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jlubhJ�< to include the information on the configuration parameters.�����}�(h jlh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jhubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�ASelect *Wal* to include the information on WAL record generation.�h]�hV)��}�(hj�h]�(hJ�Select �����}�(h j�h!hh"NhNubh`)��}�(h�*Wal*�h]�hJ�Wal�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�5 to include the information on WAL record generation.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjch"h#hK�h jLubeh}�(h]�h]�h]�h]�h]�uhjJh j)ubjK)��}�(hhh]�hV)��}�(h�Shift+F7�h]�hJ�Shift+F7�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j)ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Commit*�h]�h`)��}�(hj�h]�hJ�Commit�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�2Click the *Commit* icon to commit the transaction.�h]�(hJ�155Click the �����}�(h j
h!hh"NhNubh`)��}�(h�*Commit*�h]�hJ�Commit�����}�(h j
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j
ubhJ�  icon to commit the transaction.�����}�(h j
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j

ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Shift+CTRL+M�h]�hJ�Shift+CTRL+M�����}�(h j9
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j6
ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�156*Rollback*�h]�h`)��}�(hj[
h]�hJ�Rollback�����}�(h j]
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jY
ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jV
ubah}�(h]�h]�h]�h]�h]�uhjJh jS
ubjK)��}�(hhh]�hV)��}�(h�6Click the *Rollback* icon to rollback the transaction.�h]�(hJ�157Click the �����}�(h jy
h!hh"NhNubh`)��}�(h�158*Rollback*�h]�hJ�Rollback�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jy
ubhJ�" icon to rollback the transaction.�����}�(h jy
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jv
ubah}�(h]�h]�h]�h]�h]�uhjJh jS
ubjK)��}�(hhh]�hV)��}�(h�Shift+CTRL+R�h]�hJ�Shift+CTRL+R�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�
ubah}�(h]�h]�h]�h]�h]�uhjJh jS
ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Macros*�h]�h`)��}�(hj�
h]�hJ�Macros�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�
ubah}�(h]�h]�h]�h]�h]�uhjJh j�
ubjK)��}�(hhh]�hV)��}�(h�zClick the *Macros* icon to manage the macros. You can create, edit or clear the macros through159the *Manage Macros* option.�h]�(hJ�160Click the �����}�(h j�
h!hh"NhNubh`)��}�(h�*Macros*�h]�hJ�Macros�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ�Q icon to manage the macros. You can create, edit or clear the macros through161the �����}�(h j�
h!hh"NhNubh`)��}�(h�*Manage Macros*�h]�hJ�
Manage Macros�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ� option.�����}�(h j�
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�
ubah}�(h]�h]�h]�h]�h]�uhjJh j�
ubjK)��}�(hhh]�h}�(h]�h]�h]�h]�h]�uhjJh j�
ubeh}�(h]�h]�h]�h]�h]�uhjEh j`	ubeh}�(h]�h]�h]�h]�h]�uhj�h j�ubeh}�(h]�h]�h]�h]�h]��cols�Kuhjh j�ubah}�(h]�h]�(�	longtable�jeh]�h]�h]�uhjh j�h!hh"h#hNubeh}�(h]��query-execution�ah]�h]��query execution�ah]�h]�uhh$h h&h!hh"h#hKhubh%)��}�(hhh]�(h*)��}�(h�Data Editing Options�h]�hJ�Data Editing Options�����}�(h jHh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jEh!hh"h#hK�ubh�)��}�(h�f.. image:: images/query_data_editing.png162    :alt: Query tool data editing options163    :align: center164�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool data editing options��align��center��uri��images/query_data_editing.png�h�}�h�jesuhh�h"h#hK�h jEh!hubj)��}�(hhh]�j)��}�(hhh]�(j!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jjubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jjubj!)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj h jjubjA)��}�(hhh]�jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubah}�(h]�h]�h]�h]�h]�uhj@h jjubj�)��}�(hhh]�(jF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�	*Add row*�h]�h`)��}�(hj�h]�hJ�Add row�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�)Click the *Add row* icon to add a new row�h]�(hJ�165Click the �����}�(h jh!hh"NhNubh`)��}�(h�	*Add row*�h]�hJ�Add row�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� icon to add a new row�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�h}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Copy*�h]�h`)��}�(hjHh]�hJ�Copy�����}�(h jJh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jFubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jCubah}�(h]�h]�h]�h]�h]�uhjJh j@ubjK)��}�(hhh]�(hV)��}�(h�AClick the *Copy* icon to copy the content with or without header:�h]�(hJ�166Click the �����}�(h jfh!hh"NhNubh`)��}�(h�*Copy*�h]�hJ�Copy�����}�(h jnh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jfubhJ�1 icon to copy the content with or without header:�����}�(h jfh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jcubjd)��}�(h��* Click the *Copy* icon to copy the content that is currently highlighted in the Data Output167   panel.168 169*  Click *Copy with headers* to copy the highlighted content along with the header.�h]�jj)��}�(hhh]�(jo)��}�(h�cClick the *Copy* icon to copy the content that is currently highlighted in the Data Output170 panel.171�h]�h	�definition_list���)��}�(hhh]�h	�definition_list_item���)��}�(h�bClick the *Copy* icon to copy the content that is currently highlighted in the Data Output172panel.173�h]�(h	�term���)��}�(h�ZClick the *Copy* icon to copy the content that is currently highlighted in the Data Output�h]�(hJ�174Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Copy*�h]�hJ�Copy�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�J icon to copy the content that is currently highlighted in the Data Output�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhj�h"h#hK�h j�ubh	�175definition���)��}�(hhh]�hV)��}�(h�panel.�h]�hJ�panel.�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhj�h"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�uhj�h"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhj�h"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�PClick *Copy with headers* to copy the highlighted content along with the header.�h]�hV)��}�(hj�h]�(hJ�Click �����}�(h j�h!hh"NhNubh`)��}�(h�*Copy with headers*�h]�hJ�Copy with headers�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�7 to copy the highlighted content along with the header.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjch"h#hK�h jcubeh}�(h]�h]�h]�h]�h]�uhjJh j@ubjK)��}�(hhh]�hV)��}�(h�
Accesskey + C�h]�hJ�
Accesskey + C�����}�(h j'h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j$ubah}�(h]�h]�h]�h]�h]�uhjJh j@ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Paste*�h]�h`)��}�(hjIh]�hJ�Paste�����}�(h jKh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jGubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jDubah}�(h]�h]�h]�h]�h]�uhjJh jAubjK)��}�(hhh]�(hV)��}�(h�_Click the *Paste* icon to paste a previously copied row with or without serial/identity values:�h]�(hJ�176Click the �����}�(h jgh!hh"NhNubh`)��}�(h�*Paste*�h]�hJ�Paste�����}�(h joh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jgubhJ�N icon to paste a previously copied row with or without serial/identity values:�����}�(h jgh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jdubjd)��}�(h��* Click the *Paste* icon to paste a previously copied row into a new row.177 178* Click the *Paste with SERIAL/IDENTITY values?* if you want to paste the copied column values179  in the serial/identity columns.�h]�jj)��}�(hhh]�(jo)��}�(h�HClick the *Paste* icon to paste a previously copied row into a new row.180�h]�hV)��}�(h�GClick the *Paste* icon to paste a previously copied row into a new row.�h]�(hJ�181Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Paste*�h]�hJ�Paste�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�6 icon to paste a previously copied row into a new row.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubjo)��}�(h�|Click the *Paste with SERIAL/IDENTITY values?* if you want to paste the copied column values182in the serial/identity columns.�h]�hV)��}�(h�|Click the *Paste with SERIAL/IDENTITY values?* if you want to paste the copied column values183in the serial/identity columns.�h]�(hJ�184Click the �����}�(h j�h!hh"NhNubh`)��}�(h�$*Paste with SERIAL/IDENTITY values?*�h]�hJ�"Paste with SERIAL/IDENTITY values?�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�N if you want to paste the copied column values185in the serial/identity columns.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjch"h#hK�h jdubeh}�(h]�h]�h]�h]�h]�uhjJh jAubjK)��}�(hhh]�hV)��}�(h�
Accesskey + P�h]�hJ�
Accesskey + P�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh jAubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Delete*�h]�h`)��}�(hjh]�hJ�Delete�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jubah}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�hV)��}�(h��Click the *Delete* icon to mark the selected rows for deletion. These marked rows get deleted186when you click the *Save Data Changes* icon.�h]�(hJ�187Click the �����}�(h j7h!hh"NhNubh`)��}�(h�*Delete*�h]�hJ�Delete�����}�(h j?h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j7ubhJ�_ icon to mark the selected rows for deletion. These marked rows get deleted188when you click the �����}�(h j7h!hh"NhNubh`)��}�(h�*Save Data Changes*�h]�hJ�Save Data Changes�����}�(h jQh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j7ubhJ� icon.�����}�(h j7h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j4ubah}�(h]�h]�h]�h]�h]�uhjJh jubjK)��}�(hhh]�hV)��}�(h�
Accesskey + D�h]�hJ�
Accesskey + D�����}�(h jrh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h joubah}�(h]�h]�h]�h]�h]�uhjJh jubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Save Data Changes*�h]�h`)��}�(hj�h]�hJ�Save Data Changes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�{Click the *Save Data Changes* icon to save data changes (insert, update, or delete) in the Data189Output Panel to the server.�h]�(hJ�190Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Save Data Changes*�h]�hJ�Save Data Changes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�^ icon to save data changes (insert, update, or delete) in the Data191Output Panel to the server.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�F6�h]�hJ�F6�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�*Save results to*192*file*�h]�(h`)��}�(h�*Save results to*�h]�hJ�Save results to�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�193�����}�(h j�h!hh"NhNubh`)��}�(h�*file*�h]�hJ�file�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(hXeClick the Save results to file icon to save the result set of the current query as a delimited194text file (CSV, if the field separator is set to a comma). This button will only be enabled when195a query has been executed and there are results in the data grid. You can specify the CSV/TXT196settings in the Preference Dialogue under SQL Editor -> CSV/TXT output.�h]�hJXeClick the Save results to file icon to save the result set of the current query as a delimited197text file (CSV, if the field separator is set to a comma). This button will only be enabled when198a query has been executed and there are results in the data grid. You can specify the CSV/TXT199settings in the Preference Dialogue under SQL Editor -> CSV/TXT output.�����}�(h j.h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j+ubah}�(h]�h]�h]�h]�h]�uhjJh j�ubjK)��}�(hhh]�hV)��}�(h�F8�h]�hJ�F8�����}�(h jEh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jBubah}�(h]�h]�h]�h]�h]�uhjJh j�ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubjF)��}�(hhh]�(jK)��}�(hhh]�hV)��}�(h�Graph Visualiser�h]�hJ�Graph Visualiser�����}�(h jeh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jbubah}�(h]�h]�h]�h]�h]�uhjJh j_ubjK)��}�(hhh]�hV)��}�(h�HUse the Graph Visualiser button to generate graphs of the query results.�h]�hJ�HUse the Graph Visualiser button to generate graphs of the query results.�����}�(h j|h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jyubah}�(h]�h]�h]�h]�h]�uhjJh j_ubjK)��}�(hhh]�h}�(h]�h]�h]�h]�h]�uhjJh j_ubeh}�(h]�h]�h]�h]�h]�uhjEh j�ubeh}�(h]�h]�h]�h]�h]�uhj�h jjubeh}�(h]�h]�h]�h]�h]��cols�Kuhjh jgubah}�(h]�h]�(�	longtable�jeh]�h]�h]�uhjh jEh!hh"h#hNubeh}�(h]��data-editing-options�ah]�h]��data editing options�ah]�h]�uhh$h h&h!hh"h#hK�ubh%)��}�(hhh]�(h*)��}�(h�200Status Bar�h]�hJ�201Status Bar�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j�h!hh"h#hK�ubh�)��}�(h�Z.. image:: images/query_status_bar.png202    :alt: Query tool status bar203    :align: center204�h]�h}�(h]�h]�h]�h]�h]��alt��Query tool status bar��align��center��uri��images/query_status_bar.png�h�}�h�j�suhh�h"h#hK�h j�h!hubhV)��}�(h�/The status bar shows the following information:�h]�hJ�/The status bar shows the following information:�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�h!hubjj)��}�(hhh]�(jo)��}�(h�?**Total rows**: The total number of rows returned by the query.�h]�hV)��}�(hj�h]�(h	�strong���)��}�(h�**Total rows**�h]�hJ�205Total rows�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�1: The total number of rows returned by the query.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubjo)��}�(h�?**Query complete**: The time is taken by the query to complete.�h]�hV)��}�(hjh]�(j�)��}�(h�**Query complete**�h]�hJ�Query complete�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h jubhJ�-: The time is taken by the query to complete.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubjo)��}�(h�H**Rows selected**: The number of rows selected in the data output panel.�h]�hV)��}�(hj<h]�(j�)��}�(h�**Rows selected**�h]�hJ�
Rows selected�����}�(h jAh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j>ubhJ�7: The number of rows selected in the data output panel.�����}�(h j>h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j:ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubjo)��}�(h�[**Changes staged**: This information showed the number of rows added, deleted, and updated.�h]�hV)��}�(hjah]�(j�)��}�(h�**Changes staged**�h]�hJ�Changes staged�����}�(h jfh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h jcubhJ�I: This information showed the number of rows added, deleted, and updated.�����}�(h jch!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j_ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubjo)��}�(h�R**Ln**: In the Query tab, it is the line number at which the cursor is positioned.�h]�hV)��}�(hj�h]�(j�)��}�(h�**Ln**�h]�hJ�Ln�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�L: In the Query tab, it is the line number at which the cursor is positioned.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubjo)��}�(h�T**Col**: In the Query tab, it is the column number at which the cursor is positioned�h]�hV)��}�(hj�h]�(j�)��}�(h�**Col**�h]�hJ�Col�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�M: In the Query tab, it is the column number at which the cursor is positioned�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjnh"h#hK�h j�h!hubeh}�(h]�h]�h]�h]�h]�j�h�uhjih"h#hK�h j�h!hubeh}�(h]��206status-bar�ah]�h]��207status bar�ah]�h]�uhh$h h&h!hh"h#hK�ubeh}�(h]�(h�id1�eh]�h]�(�query tool toolbar��query_tool_toolbar�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j�hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�208translated�Kuuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��/��source_link�N�209source_url�N�
toc_backlinks�jJ�footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�210halt_level�K�exit_status_level�K�debug�N�warning_stream�N�	traceback���input_encoding��	utf-8-sig��input_encoding_error_handler��strict��output_encoding��utf-8��output_encoding_error_handler�j�error_encoding��cp1252��error_encoding_error_handler��backslashreplace��
language_code��en��record_dependencies�N�config�N�	id_prefix�h�auto_id_prefix��id��
dump_settings�N�dump_internals�N�dump_transforms�N�dump_pseudo_xml�N�expose_internals�N�strict_visitor�N�_disable_config�N�_source�h#�_destination�N�
_config_files�]��file_insertion_enabled���raw_enabled�K�line_length_limit�M'�pep_references�N�pep_base_url��https://peps.python.org/��pep_file_url_template��pep-%04d��rfc_references�N�rfc_base_url��&https://datatracker.ietf.org/doc/html/��	tab_width�K�trim_footnote_reference_space���syntax_highlight��long��smart_quotes���smartquotes_locales�]��character_level_inline_markup���doctitle_xform���
docinfo_xform���sectsubtitle_xform���
image_loading��link��embed_stylesheet���cloak_email_addresses���section_self_link���env�Nub�reporter�N�indirect_targets�]��substitution_defs�}��substitution_names�}��refnames�}��refids�}�h]�has�nameids�}�(j�hj�j�jjj`j]j�j�jBj?j�j�j�j�u�	nametypes�}�(j��j��j�j`�j��jB�j��j��uh}�(hh&j�h&jjj]jj�jcj?j�j�jEj�j�u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K�symbol_footnote_start�K�211id_counter��collections��Counter���}�j Ks��R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�8Hyperlink target "query-tool-toolbar" is not referenced.�����}�h j{sbah}�(h]�h]�h]�h]�h]�uhhUh jxubah}�(h]�h]�h]�h]�h]��level�K�type��INFO��source�h#�line�Kuhjvubjw)��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h j�sbah}�(h]�h]�h]�h]�h]�uhhUh j�ubah}�(h]�h]�h]�h]�h]��level�K�type�j��source�h#�line�Kuhjvube�transformer�N�include_log�]��212decoration�Nh!hub.
codekingpro/portable-devtools · Team Ai