codekingpro/portable-devtools
114k
1���� �sphinx.addnodes��document���)��}�(� rawsource�� ��children�]�(�docutils.nodes��target���)��}�(h�.. _database_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��database-dialog�u�tagname�h3�line�K�parent�h� _document�h�source��jD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\database_dialog.rst�ubh �section���)��}�(hhh]�(h �title���)��}�(h�`Database Dialog`:index:�h]�(h �index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Database Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh �Text����Database Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh � paragraph���)��}�(h��Use the *Database* dialog to define or modify a database. To create a database,5you must be a database superuser or have the CREATE privilege.�h]�(hJ�Use the �����}�(h hWh!hh"NhNubh �emphasis���)��}�(h�6*Database*�h]�hJ�Database�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�| dialog to define or modify a database. To create a database,7you must be a database superuser or have the CREATE privilege.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h��The *Database* dialog organizes the development of a database through the8following dialog tabs: *General*, *Definition*, *Security*, and *Parameters*.9The *SQL* tab displays the SQL code generated by dialog selections.�h]�(hJ�The �����}�(h hyh!hh"NhNubh`)��}�(h�10*Database*�h]�hJ�Database�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�S dialog organizes the development of a database through the11following dialog tabs: �����}�(h hyh!hh"NhNubh`)��}�(h� *General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, �����}�(h hyh!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�12Definition�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, �����}�h hysbh`)��}�(h�13*Security*�h]�hJ�Security�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, and �����}�(h hyh!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�14Parameters�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�.15The �����}�(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 dialog selections.�����}�(h hyh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK16h h&h!hubh �image���)��}�(h�`.. image:: images/database_general.png17 :alt: Database dialog general tab18 :align: center19�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog general tab��align��center��uri��images/database_general.png��20candidates�}��*�j suhh�h"h#hKh h&h!hubhV)��}�(h�=Use the fields in the *General* tab to identify the database:�h]�(hJ�Use the fields in the �����}�(h j h!hh"NhNubh`)��}�(h� *General*�h]�hJ�General�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ� tab to identify the database:�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh �bullet_list���)��}�(hhh]�(h � list_item���)��}�(h�~Use the *Database* field to add a descriptive name for the database. The name21will be displayed in the *pgAdmin* tree control.�h]�hV)��}�(h�~Use the *Database* field to add a descriptive name for the database. The name22will be displayed in the *pgAdmin* tree control.�h]�(hJ�Use the �����}�(h j3 h!hh"NhNubh`)��}�(h�23*Database*�h]�hJ�Database�����}�(h j; h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j3 ubhJ�U field to add a descriptive name for the database. The name24will be displayed in the �����}�(h j3 h!hh"NhNubh`)��}�(h� *pgAdmin*�h]�hJ�pgAdmin�����}�(h jM h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j3 ubhJ� tree control.�����}�(h j3 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j/ ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKh j* h!hubj. )��}�(h��Use the *OID* field to specify the object identifier to be used for the new25database. Users can specify the value greater than 16383. This option is available26from v15 and above.�h]�hV)��}�(h��Use the *OID* field to specify the object identifier to be used for the new27database. Users can specify the value greater than 16383. This option is available28from v15 and above.�h]�(hJ�Use the �����}�(h jo h!hh"NhNubh`)��}�(h�*OID*�h]�hJ�OID�����}�(h jw h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jo ubhJ�� field to specify the object identifier to be used for the new29database. Users can specify the value greater than 16383. This option is available30from v15 and above.�����}�(h jo h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jk ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKh j* h!hubj. )��}�(h�QSelect the owner of the database from the drop-down listbox in the *Owner*31field.�h]�hV)��}�(h�QSelect the owner of the database from the drop-down listbox in the *Owner*32field.�h]�(hJ�CSelect the owner of the database from the drop-down listbox in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Owner*�h]�hJ�Owner�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�33field.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKh j* h!hubj. )��}�(h�7Store notes about the database in the *Comment* field.34�h]�hV)��}�(h�6Store notes about the database in the *Comment* field.�h]�(hJ�&Store notes about the database in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Comment*�h]�hJ�Comment�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� field.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKh j* h!hubeh}�(h]�h]�h]�h]�h]��bullet�j uhj( h"h#hKh h&h!hubhV)��}�(h�'Click the *Definition* tab to continue.�h]�(hJ�35Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�36Definition�����}�(h j� h!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#hKh h&h!hubh�)��}�(h�f.. image:: images/database_definition.png37 :alt: Database dialog definition tab38 :align: center39�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog definition tab��align��center��uri��images/database_definition.png�j }�j j suhh�h"h#hKh h&h!hubhV)��}�(h�<Use the *Definition* tab to set properties for the database:�h]�(hJ�Use the �����}�(h j! h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�40Definition�����}�(h j) h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j! ubhJ�( tab to set properties for the database:�����}�(h j! h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK#h h&h!hubj) )��}�(hhh]�(j. )��}�(h�aSelect a character set from the drop-down listbox in the *Encoding* field.41The default is *UTF8*.�h]�hV)��}�(h�aSelect a character set from the drop-down listbox in the *Encoding* field.42The default is *UTF8*.�h]�(hJ�9Select a character set from the drop-down listbox in the �����}�(h jH h!hh"NhNubh`)��}�(h�43*Encoding*�h]�hJ�Encoding�����}�(h jP h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jH ubhJ� field.44The default is �����}�(h jH h!hh"NhNubh`)��}�(h�*UTF8*�h]�hJ�UTF8�����}�(h jb h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jH ubhJ�.�����}�(h jH h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h jD ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK%h jA h!hubj. )��}�(h��Select a template from the drop-down listbox in the *Template* field. If you45do not specify a template, the database will use template1.�h]�hV)��}�(h��Select a template from the drop-down listbox in the *Template* field. If you46do not specify a template, the database will use template1.�h]�(hJ�4Select a template from the drop-down listbox in the �����}�(h j� h!hh"NhNubh`)��}�(h�47*Template*�h]�hJ�Template�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�J field. If you48do not specify a template, the database will use template1.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK'h jA h!hubj. )��}�(h��Select a tablespace from the drop-down listbox in the *Tablespace* field. The49selected tablespace will be the default tablespace used to contain database50objects.�h]�hV)��}�(h��Select a tablespace from the drop-down listbox in the *Tablespace* field. The51selected tablespace will be the default tablespace used to contain database52objects.�h]�(hJ�6Select a tablespace from the drop-down listbox in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Tablespace*�h]�hJ�53Tablespace�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�` field. The54selected tablespace will be the default tablespace used to contain database55objects.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK)h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK)h jA h!hubj. )��}�(h��Select the strategy from the drop-down listbox in the *Strategy* field while56creating a new database. This option is available from v15 and above.�h]�hV)��}�(h��Select the strategy from the drop-down listbox in the *Strategy* field while57creating a new database. This option is available from v15 and above.�h]�(hJ�6Select the strategy from the drop-down listbox in the �����}�(h j� h!hh"NhNubh`)��}�(h�58*Strategy*�h]�hJ�Strategy�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�R field while59creating a new database. This option is available from v15 and above.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK,h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK,h jA h!hubj. )��}�(h��Select the locale provider from the drop-down listbox in the *Locale Provider*60field to set the default collation for this database. Possible values are: icu, libc.61This option is available from v15 and above.�h]�hV)��}�(h��Select the locale provider from the drop-down listbox in the *Locale Provider*62field to set the default collation for this database. Possible values are: icu, libc.63This option is available from v15 and above.�h]�(hJ�=Select the locale provider from the drop-down listbox in the �����}�(h j h!hh"NhNubh`)��}�(h�*Locale Provider*�h]�hJ�Locale Provider�����}�(h j64 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ��65field to set the default collation for this database. Possible values are: icu, libc.66This option is available from v15 and above.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK.h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK.h jA h!hubj. )��}�(h�OSelect the collation order from the drop-down listbox in the *Collation* field.�h]�hV)��}�(hj* h]�(hJ�=Select the collation order from the drop-down listbox in the �����}�(h j, h!hh"NhNubh`)��}�(h�*Collation*�h]�hJ� Collation�����}�(h j3 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j, ubhJ� field.�����}�(h j, h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h j( ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK1h jA h!hubj. )��}�(hX Select the character classification from the drop-down listbox in the67*Character Type* field. This affects the categorization of characters, e.g.68lower, upper and digit. The default, or a blank field, uses the character69classification of the template database.�h]�hV)��}�(hX Select the character classification from the drop-down listbox in the70*Character Type* field. This affects the categorization of characters, e.g.71lower, upper and digit. The default, or a blank field, uses the character72classification of the template database.�h]�(hJ�FSelect the character classification from the drop-down listbox in the73�����}�(h jU h!hh"NhNubh`)��}�(h�*Character Type*�h]�hJ�Character Type�����}�(h j] h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jU ubhJ�� field. This affects the categorization of characters, e.g.74lower, upper and digit. The default, or a blank field, uses the character75classification of the template database.�����}�(h jU h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK2h jQ ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK2h jA h!hubj. )��}�(h��Select the icu locale from the drop-down listbox in the *ICU Locale* to76specifies the ICU locale ID if the ICU locale provider is used.77This option is available from v15 and above.�h]�hV)��}�(h��Select the icu locale from the drop-down listbox in the *ICU Locale* to78specifies the ICU locale ID if the ICU locale provider is used.79This option is available from v15 and above.�h]�(hJ�8Select the icu locale from the drop-down listbox in the �����}�(h j h!hh"NhNubh`)��}�(h�*ICU Locale*�h]�hJ�80ICU Locale�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�p to81specifies the ICU locale ID if the ICU locale provider is used.82This option is available from v15 and above.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK6h j{ ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK6h jA h!hubj. )��}�(h��Specify the icu rules in the *ICU Rules* field as additional collation83rules to customize the behavior of the default collation of this database.84This option is available from v16 and above.�h]�hV)��}�(h��Specify the icu rules in the *ICU Rules* field as additional collation85rules to customize the behavior of the default collation of this database.86This option is available from v16 and above.�h]�(hJ�Specify the icu rules in the �����}�(h j� h!hh"NhNubh`)��}�(h�*ICU Rules*�h]�hJ� ICU Rules�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� field as additional collation87rules to customize the behavior of the default collation of this database.88This option is available from v16 and above.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK9h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK9h jA h!hubj. )��}�(h��Specify a connection limit in the *Connection Limit* field to configure the89maximum number of connection requests. The default value (*-1*) allows90unlimited connections to the database.�h]�hV)��}�(h��Specify a connection limit in the *Connection Limit* field to configure the91maximum number of connection requests. The default value (*-1*) allows92unlimited connections to the database.�h]�(hJ�"Specify a connection limit in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Connection Limit*�h]�hJ�Connection Limit�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�R field to configure the93maximum number of connection requests. The default value (�����}�(h j� h!hh"NhNubh`)��}�(h�*-1*�h]�hJ�-1�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�/) allows94unlimited connections to the database.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK<h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK<h jA h!hubj. )��}�(h�OIf the *templates?* is set to true, then database will be a template database.95�h]�hV)��}�(h�NIf the *templates?* is set to true, then database will be a template database.�h]�(hJ�If the �����}�(h j h!hh"NhNubh`)��}�(h�*templates?*�h]�hJ�96templates?�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�; is set to true, then database will be a template database.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK?h j ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK?h jA h!hubeh}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hK%h h&h!hubhV)��}�(h�%Click the *Security* tab to continue.�h]�(hJ�97Click the �����}�(h j; h!hh"NhNubh`)��}�(h�98*Security*�h]�hJ�Security�����}�(h jC h!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#hKAh h&h!hubh�)��}�(h�b.. image:: images/database_security.png99 :alt: Database dialog security tab100 :align: center101�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog security tab��align��center��uri��images/database_security.png�j }�j jj suhh�h"h#hKCh h&h!hubhV)��}�(h�GUse the *Security* tab to assign privileges and define security labels.�h]�(hJ�Use the �����}�(h jl h!hh"NhNubh`)��}�(h�102*Security*�h]�hJ�Security�����}�(h jt h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jl ubhJ�5 tab to assign privileges and define security labels.�����}�(h jl h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKGh h&h!hubhV)��}�(h�{Use the *Privileges* panel to assign privileges to a role. Click the *Add* icon103(+) to set privileges for database objects:�h]�(hJ�Use the �����}�(h j� h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�104Privileges�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�1 panel to assign privileges to a role. Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�1 icon105(+) to set privileges for database objects:�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKIh h&h!hubj) )��}�(hhh]�(j. )��}�(h�NSelect the name of the role from the drop-down listbox in the *Grantee* field.�h]�hV)��}�(hj� h]�(hJ�>Select the name of the role from the drop-down listbox in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Grantee*�h]�hJ�Grantee�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� field.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKLh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKLh j� h!hubj. )��}�(h��Click inside the *Privileges* field. Check the boxes to the left of one or106more privileges to grant the selected privilege to the specified user.�h]�hV)��}�(h��Click inside the *Privileges* field. Check the boxes to the left of one or107more privileges to grant the selected privilege to the specified user.�h]�(hJ�Click inside the �����}�(h j� h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�108Privileges�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�t field. Check the boxes to the left of one or109more privileges to grant the selected privilege to the specified user.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKMh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKMh j� h!hubj. )��}�(h�nThe current user, who is the default grantor for granting the privilege, is displayed in the *Grantor* field.110�h]�hV)��}�(h�mThe current user, who is the default grantor for granting the privilege, is displayed in the *Grantor* field.�h]�(hJ�]The current user, who is the default grantor for granting the privilege, is displayed in the �����}�(h j h!hh"NhNubh`)��}�(h� *Grantor*�h]�hJ�Grantor�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ� field.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKOh j ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKOh j� h!hubeh}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hKLh h&h!hubhV)��}�(h��Click add to set additional privileges; to discard a privilege, click the trash111icon to the left of the row and confirm deletion in the *Delete Row* popup.�h]�(hJ��Click add to set additional privileges; to discard a privilege, click the trash112icon to the left of the row and confirm deletion in the �����}�(h jD h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�113Delete Row�����}�(h jL h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jD ubhJ� popup.�����}�(h jD h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh h&h!hubhV)��}�(h��Use the *Security Labels* panel to define security labels applied to the114database. Click the *Add* icon (+) to add each security label selection:�h]�(hJ�Use the �����}�(h jd h!hh"NhNubh`)��}�(h�*Security Labels*�h]�hJ�Security Labels�����}�(h jl h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jd ubhJ�D panel to define security labels applied to the115database. Click the �����}�(h jd h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j~ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jd ubhJ�/ icon (+) to add each security label selection:�����}�(h jd h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKTh h&h!hubj) )��}�(hhh]�(j. )��}�(h��Specify a security label provider in the *Provider* field. The named provider116must be loaded and must consent to the proposed labeling operation.�h]�hV)��}�(h��Specify a security label provider in the *Provider* field. The named provider117must be loaded and must consent to the proposed labeling operation.�h]�(hJ�)Specify a security label provider in the �����}�(h j� h!hh"NhNubh`)��}�(h�118*Provider*�h]�hJ�Provider�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�^ field. The named provider119must be loaded and must consent to the proposed labeling operation.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKWh j� h!hubj. )��}�(hX Specify a a security label in the *Security Label* field. The meaning of a120given label is at the discretion of the label provider. PostgreSQL places no121restrictions on whether or how a label provider must interpret security122labels; it merely provides a mechanism for storing them.123�h]�hV)��}�(hX Specify a a security label in the *Security Label* field. The meaning of a124given label is at the discretion of the label provider. PostgreSQL places no125restrictions on whether or how a label provider must interpret security126labels; it merely provides a mechanism for storing them.�h]�(hJ�"Specify a a security label in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Security Label*�h]�hJ�Security Label�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� field. The meaning of a127given label is at the discretion of the label provider. PostgreSQL places no128restrictions on whether or how a label provider must interpret security129labels; it merely provides a mechanism for storing them.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKYh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKYh j� h!hubeh}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hKWh h&h!hubhV)��}�(h�xTo discard a security label, click the trash icon to the left of the row and130confirm deletion in the *Delete Row* popup.�h]�(hJ�eTo discard a security label, click the trash icon to the left of the row and131confirm deletion in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�132Delete Row�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� popup.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h h&h!hubhV)��}�(h�'Click the *Parameters* tab to continue.�h]�(hJ�133Click the �����}�(h j h!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�134Parameters�����}�(h j h!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#hKah h&h!hubh�)��}�(h�f.. image:: images/database_parameters.png135 :alt: Database dialog parameters tab136 :align: center137�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog parameters tab��align��center��uri��images/database_parameters.png�j }�j jB suhh�h"h#hKch h&h!hubhV)��}�(h�lUse the *Parameters* tab to set parameters for the database. Click the *Add*138icon (+) to add each parameter:�h]�(hJ�Use the �����}�(h jD h!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�139Parameters�����}�(h jL h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jD ubhJ�3 tab to set parameters for the database. Click the �����}�(h jD h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j^ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jD ubhJ� 140icon (+) to add each parameter:�����}�(h jD h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKgh h&h!hubj) )��}�(hhh]�(j. )��}�(h�DUse the drop-down listbox in the *Name* field to select a parameter.�h]�hV)��}�(hj{ h]�(hJ�!Use the drop-down listbox in the �����}�(h j} h!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j} ubhJ� field to select a parameter.�����}�(h j} h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKjh jy ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKjh jv h!hubj. )��}�(h�7Use the *Value* field to set a value for the parameter.�h]�hV)��}�(hj� h]�(hJ�Use the �����}�(h j� h!hh"NhNubh`)��}�(h�*Value*�h]�hJ�Value�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�( field to set a value for the parameter.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKkh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKkh jv h!hubj. )��}�(h�oUse the drop-down listbox next to *Role* to select a role to which the141parameter setting specified will apply.142�h]�hV)��}�(h�nUse the drop-down listbox next to *Role* to select a role to which the143parameter setting specified will apply.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j� h!hh"NhNubh`)��}�(h�*Role*�h]�hJ�Role�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�F to select a role to which the144parameter setting specified will apply.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKlh j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hKlh jv h!hubeh}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hKjh h&h!hubhV)��}�(h��Follow these steps to add additional parameter value definitions; to discard a145parameter, click the trash icon to the left of the row and confirm deletion in146the *Delete Row* popup.�h]�(hJ��Follow these steps to add additional parameter value definitions; to discard a147parameter, click the trash icon to the left of the row and confirm deletion in148the �����}�(h j� h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�149Delete Row�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� popup.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKoh h&h!hubhV)��}�(h�%Click the *Advanced* tab to continue.�h]�(hJ�150Click the �����}�(h j h!hh"NhNubh`)��}�(h�151*Advanced*�h]�hJ�Advanced�����}�(h j# h!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#hKsh h&h!hubh�)��}�(h�`.. image:: images/database_advanced.png152 :alt: Database dialog advanced tab153 :align: center154�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog advanced tab��align��center��uri��images/database_advanced.png�j }�j jJ suhh�h"h#hKuh h&h!hubhV)��}�(h�CUse the *Advanced* tab to set advanced parameters for the database.�h]�(hJ�Use the �����}�(h jL h!hh"NhNubh`)��}�(h�155*Advanced*�h]�hJ�Advanced�����}�(h jT h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jL ubhJ�1 tab to set advanced parameters for the database.�����}�(h jL h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKyh h&h!hubj) )��}�(hhh]�j. )��}�(hX Use *Schema restriction* field to provide a SQL restriction that will be used156against the pg_namespace table to limit the schemas that you see.157For example, you might enter: *public* so that only *public* are shown in158the pgAdmin browser.Separate entries with a comma or tab as you type.159�h]�hV)��}�(hX Use *Schema restriction* field to provide a SQL restriction that will be used160against the pg_namespace table to limit the schemas that you see.161For example, you might enter: *public* so that only *public* are shown in162the pgAdmin browser.Separate entries with a comma or tab as you type.�h]�(hJ�Use �����}�(h js h!hh"NhNubh`)��}�(h�*Schema restriction*�h]�hJ�Schema restriction�����}�(h j{ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h js ubhJ�� field to provide a SQL restriction that will be used163against the pg_namespace table to limit the schemas that you see.164For example, you might enter: �����}�(h js h!hh"NhNubh`)��}�(h�*public*�h]�hJ�public�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h js ubhJ� so that only �����}�(h js h!hh"NhNubh`)��}�(h�*public*�h]�hJ�public�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h js ubhJ�S are shown in165the pgAdmin browser.Separate entries with a comma or tab as you type.�����}�(h js h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK{h jo ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK{h jl h!hubah}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hK{h h&h!hubhV)��}�(h� Click the *SQL* tab to continue.�h]�(hJ�166Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j� h!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��Your entries in the *Database* dialog generate a SQL command (see an example167below). Use the *SQL* tab for review; revisit or switch tabs to make any changes168to the SQL command.�h]�(hJ�Your entries in the �����}�(h j� h!hh"NhNubh`)��}�(h�169*Database*�h]�hJ�Database�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�? dialog generate a SQL command (see an example170below). Use the �����}�(h j� h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�O tab for review; revisit or switch tabs to make any changes171to the SQL command.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h h&h!hubh%)��}�(hhh]�(h*)��}�(h�Example�h]�hJ�Example�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hK�ubhV)��}�(h�eThe following is an example of the sql command generated by user selections in172the *Database* dialog:�h]�(hJ�SThe following is an example of the sql command generated by user selections in173the �����}�(h j& h!hh"NhNubh`)��}�(h�174*Database*�h]�hJ�Database�����}�(h j. h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j& ubhJ� dialog:�����}�(h j& h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j h!hubh�)��}�(h�X.. image:: images/database_sql.png175 :alt: Database dialog sql tab176 :align: center177�h]�h}�(h]�h]�h]�h]�h]��alt��Database dialog sql tab��align��center��uri��images/database_sql.png�j }�j jU suhh�h"h#hK�h j h!hubhV)��}�(h��The example creates a database named *hr* that is owned by *postgres*. It178allows unlimited connections, and is available to all authenticated users.�h]�(hJ�%The example creates a database named �����}�(h jW h!hh"NhNubh`)��}�(h�*hr*�h]�hJ�hr�����}�(h j_ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jW ubhJ� that is owned by �����}�(h jW h!hh"NhNubh`)��}�(h�179*postgres*�h]�hJ�postgres�����}�(h jq h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jW ubhJ�O. It180allows unlimited connections, and is available to all authenticated users.�����}�(h jW h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j h!hubj) )��}�(hhh]�(j. )��}�(h�2Click the *Info* button (i) to access online help.�h]�hV)��}�(hj� h]�(hJ�181Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Info*�h]�hJ�Info�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�" button (i) to access online help.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK�h j� h!hubj. )��}�(h�%Click the *Save* button to save work.�h]�hV)��}�(hj� h]�(hJ�182Click 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#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK�h j� h!hubj. )��}�(h�5Click the *Close* button to exit without saving work.�h]�hV)��}�(hj� h]�(hJ�183Click 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#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK�h j� h!hubj. )��}�(h�=Click the *Reset* button to restore configuration parameters.�h]�hV)��}�(hj h]�(hJ�184Click 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#hK�h j ubah}�(h]�h]�h]�h]�h]�uhj- h"h#hK�h j� h!hubeh}�(h]�h]�h]�h]�h]�j� j uhj( h"h#hK�h j h!hubeh}�(h]��example�ah]�h]��example�ah]�h]�uhh$h h&h!hh"h#hK�ubeh}�(h]�(h�id1�eh]�h]�(�database dialog��database_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�jD hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K �185translated�K uuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N� generator�N� datestamp�N�root_prefix��/��source_link�N�186source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�187halt_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�ju �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]�has�nameids�}�(jD hjC j@ j; j8 u� nametypes�}�(jD �jC �j; �uh}�(hh&j@ h&j8 j u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]�� footnotes�]�� citations�]��autofootnote_start�K�symbol_footnote_start�K �188id_counter��collections��Counter���}�j� Ks��R��parse_messages�]��transform_messages�]�(h �system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�5Hyperlink target "database-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�]��189decoration�Nh!hub.