Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
synonym_dialog.doctree50 linesDownload Raw Back to .doctrees
1���-�sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _synonym_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��synonym-dialog�u�tagname�h3�line�K�parent�h�	_document�h�source��iD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\synonym_dialog.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h�`Synonym Dialog`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Synonym Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����Synonym Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(h�_Use the *Synonym* dialog to substitute the name of a target object with a5user-defined synonym.�h]�(hJ�Use the �����}�(h hWh!hh"NhNubh	�emphasis���)��}�(h�	*Synonym*�h]�hJ�Synonym�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�N dialog to substitute the name of a target object with a6user-defined synonym.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h��The *Synonym* dialog organizes the development of a synonym through the7*General* tab. The *SQL* tab displays the SQL code generated by dialog8selections.�h]�(hJ�The �����}�(h hyh!hh"NhNubh`)��}�(h�	*Synonym*�h]�hJ�Synonym�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�; dialog organizes the development of a synonym through the9�����}�(h hyh!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�10 tab. The �����}�(h hyh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�: tab displays the SQL code generated by dialog11selections.�����}�(h hyh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�image���)��}�(h�^.. image:: images/synonym_general.png12    :alt: Synonym dialog general tab13    :align: center14�h]�h}�(h]�h]�h]�h]�h]��alt��Synonym dialog general tab��align��center��uri��images/synonym_general.png��15candidates�}��*�h�suhh�h"h#hKh h&h!hubhV)��}�(h�<Use the fields in the *General* tab to identify the synonym:�h]�(hJ�Use the fields in the �����}�(h h�h!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ� tab to identify the synonym:�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(h�nUse the *Name* field to specify the name of synonym. The name will be16displayed in the *pgAdmin* tree control.�h]�hV)��}�(h�nUse the *Name* field to specify the name of synonym. The name will be17displayed in the *pgAdmin* tree control.�h]�(hJ�Use the �����}�(h h�h!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ�I field to specify the name of synonym. The name will be18displayed in the �����}�(h h�h!hh"NhNubh`)��}�(h�	*pgAdmin*�h]�hJ�pgAdmin�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ� tree control.�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hKh h�h!hubh�)��}�(h�qSelect the name of the schema in which the synonym will reside from the19drop-down listbox in the *Schema* field.20�h]�hV)��}�(h�pSelect the name of the schema in which the synonym will reside from the21drop-down listbox in the *Schema* field.�h]�(hJ�aSelect the name of the schema in which the synonym will reside from the22drop-down listbox in the �����}�(h j9h!hh"NhNubh`)��}�(h�*Schema*�h]�hJ�Schema�����}�(h jAh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j9ubhJ� field.�����}�(h j9h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j5ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hKh h�h!hubeh}�(h]�h]�h]�h]�h]��bullet�h�uhh�h"h#hKh h&h!hubhV)��}�(h�-In the definition panel, identify the target:�h]�hJ�-In the definition panel, identify the target:�����}�(h jfh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh�)��}�(h�a.. image:: images/synonym_definition.png23    :alt: Synonym dialog general tab24    :align: center25�h]�h}�(h]�h]�h]�h]�h]��alt��Synonym dialog general tab��align��center��uri��images/synonym_definition.png�h�}�h�j�suhh�h"h#hKh h&h!hubh�)��}�(hhh]�(h�)��}�(h�gUse the drop-down listbox next to *Target Type* to select the type of26object referenced by the synonym.�h]�hV)��}�(h�gUse the drop-down listbox next to *Target Type* to select the type of27object referenced by the synonym.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j�h!hh"NhNubh`)��}�(h�
*Target Type*�h]�hJ�Target Type�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�8 to select the type of28object referenced by the synonym.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK h j�h!hubh�)��}�(h�oUse the drop-down listbox next to *Target Schema* to select the name of the29schema in which the object resides.�h]�hV)��}�(h�oUse the drop-down listbox next to *Target Schema* to select the name of the30schema in which the object resides.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Target Schema*�h]�hJ�
Target Schema�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�> to select the name of the31schema in which the object resides.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK"h j�h!hubh�)��}�(h�nUse the drop-down listbox next to *Target Object* to select the name of the32object referenced by the synonym.33�h]�hV)��}�(h�mUse the drop-down listbox next to *Target Object* to select the name of the34object referenced by the synonym.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Target Object*�h]�hJ�
Target Object�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�< to select the name of the35object referenced by the synonym.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK$h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK$h j�h!hubeh}�(h]�h]�h]�h]�h]�jeh�uhh�h"h#hK h h&h!hubhV)��}�(h� Click the *SQL* tab to continue.�h]�(hJ�36Click the �����}�(h jh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� tab to continue.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h h&h!hubhV)��}�(h�KYour selections and entries in the *Synonym* dialog generate a SQL command.�h]�(hJ�#Your selections and entries in the �����}�(h j,h!hh"NhNubh`)��}�(h�	*Synonym*�h]�hJ�Synonym�����}�(h j4h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j,ubhJ� dialog generate a SQL command.�����}�(h j,h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK)h h&h!hubh�)��}�(h�V.. image:: images/synonym_sql.png37    :alt: Synonym dialog sql tab38    :align: center39�h]�h}�(h]�h]�h]�h]�h]��alt��Synonym dialog sql tab��align��center��uri��images/synonym_sql.png�h�}�h�j[suhh�h"h#hK+h h&h!hubhV)��}�(h�CThe example creates a synonym for the *emp* table named *emp_hist*.�h]�(hJ�&The example creates a synonym for the �����}�(h j]h!hh"NhNubh`)��}�(h�*emp*�h]�hJ�emp�����}�(h jeh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j]ubhJ�
 table named �����}�(h j]h!hh"NhNubh`)��}�(h�40*emp_hist*�h]�hJ�emp_hist�����}�(h jwh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j]ubhJ�.�����}�(h j]h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK/h h&h!hubh�)��}�(hhh]�(h�)��}�(h�%Click the *Save* button to save work.�h]�hV)��}�(hj�h]�(hJ�41Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� button to save work.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK1h j�h!hubh�)��}�(h�5Click the *Close* button to exit without saving work.�h]�hV)��}�(hj�h]�(hJ�42Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Close*�h]�hJ�Close�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�$ button to exit without saving work.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK2h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK2h j�h!hubh�)��}�(h�?Click the *Reset* button to restore configuration parameters.43 44�h]�hV)��}�(h�=Click the *Reset* button to restore configuration parameters.�h]�(hJ�45Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Reset*�h]�hJ�Reset�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�, button to restore configuration parameters.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK3h j�h!hubeh}�(h]�h]�h]�h]�h]�jeh�uhh�h"h#hK1h h&h!hubeh}�(h]�(h�id1�eh]�h]�(�synonym dialog��synonym_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�jhs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�46translated�Kuuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��/��source_link�N�47source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�48halt_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�jK�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�}�(jhjju�	nametypes�}�(j�j�uh}�(hh&jh&u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K�symbol_footnote_start�K�49id_counter��collections��Counter���}�jYKs��R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�4Hyperlink target "synonym-dialog" is not referenced.�����}�h j�sbah}�(h]�h]�h]�h]�h]�uhhUh j�ubah}�(h]�h]�h]�h]�h]��level�K�type��INFO��source�h#�line�Kuhj�ubj�)��}�(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�Kuhj�ube�transformer�N�include_log�]��50decoration�Nh!hub.
codekingpro/portable-devtools · Team Ai