Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
database_dialog.doctree189 linesDownload Raw Back to .doctrees
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�}��*�jsuhh�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 jh!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� tab to identify the database:�����}�(h jh!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 j3h!hh"NhNubh`)��}�(h�23*Database*�h]�hJ�Database�����}�(h j;h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j3ubhJ�U field to add a descriptive name for the database. The name24will be displayed in the �����}�(h j3h!hh"NhNubh`)��}�(h�	*pgAdmin*�h]�hJ�pgAdmin�����}�(h jMh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j3ubhJ� tree control.�����}�(h j3h!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 joh!hh"NhNubh`)��}�(h�*OID*�h]�hJ�OID�����}�(h jwh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h joubhJ�� 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 joh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jkubah}�(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�juhj(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}�jjsuhh�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 jHh!hh"NhNubh`)��}�(h�43*Encoding*�h]�hJ�Encoding�����}�(h jPh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jHubhJ� field.44The default is �����}�(h jHh!hh"NhNubh`)��}�(h�*UTF8*�h]�hJ�UTF8�����}�(h jbh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jHubhJ�.�����}�(h jHh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h jDubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK%h jAh!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 jAh!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 jAh!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 jAh!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 jh!hh"NhNubh`)��}�(h�*Locale Provider*�h]�hJ�Locale Provider�����}�(h j64h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ��65field to set the default collation for this database. Possible values are: icu, libc.66This option is available from v15 and above.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK.h j�ubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK.h jAh!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 j3h!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 jAh!hubj.)��}�(hXSelect 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)��}�(hXSelect 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 jUh!hh"NhNubh`)��}�(h�*Character Type*�h]�hJ�Character Type�����}�(h j]h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jUubhJ�� 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 jUh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK2h jQubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK2h jAh!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 jh!hh"NhNubh`)��}�(h�*ICU Locale*�h]�hJ�80ICU Locale�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�p to81specifies the ICU locale ID if the ICU locale provider is used.82This option is available from v15 and above.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK6h j{ubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK6h jAh!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 jAh!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 jAh!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 jh!hh"NhNubh`)��}�(h�*templates?*�h]�hJ�96templates?�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�; is set to true, then database will be a template database.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK?h jubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK?h jAh!hubeh}�(h]�h]�h]�h]�h]�j�juhj(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 jCh!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}�jjjsuhh�h"h#hKCh h&h!hubhV)��}�(h�GUse the *Security* tab to assign privileges and define security labels.�h]�(hJ�Use the �����}�(h jlh!hh"NhNubh`)��}�(h�102*Security*�h]�hJ�Security�����}�(h jth!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jlubhJ�5 tab to assign privileges and define security labels.�����}�(h jlh!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 jh!hh"NhNubh`)��}�(h�	*Grantor*�h]�hJ�Grantor�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� field.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKOh jubah}�(h]�h]�h]�h]�h]�uhj-h"h#hKOh j�h!hubeh}�(h]�h]�h]�h]�h]�j�juhj(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 jDh!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�113Delete Row�����}�(h jLh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jDubhJ� popup.�����}�(h jDh!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 jdh!hh"NhNubh`)��}�(h�*Security Labels*�h]�hJ�Security Labels�����}�(h jlh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jdubhJ�D panel to define security labels applied to the115database. Click the �����}�(h jdh!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j~h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jdubhJ�/ icon (+) to add each security label selection:�����}�(h jdh!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.)��}�(hXSpecify 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)��}�(hXSpecify 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�juhj(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 jh!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�134Parameters�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� tab to continue.�����}�(h jh!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}�jjBsuhh�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 jDh!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�139Parameters�����}�(h jLh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jDubhJ�3 tab to set parameters for the database. Click the �����}�(h jDh!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j^h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jDubhJ� 140icon (+) to add each parameter:�����}�(h jDh!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 jyubah}�(h]�h]�h]�h]�h]�uhj-h"h#hKjh jvh!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 jvh!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 jvh!hubeh}�(h]�h]�h]�h]�h]�j�juhj(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 jh!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 jh!hh"NhNubh`)��}�(h�151*Advanced*�h]�hJ�Advanced�����}�(h j#h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� tab to continue.�����}�(h jh!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}�jjJsuhh�h"h#hKuh h&h!hubhV)��}�(h�CUse the *Advanced* tab to set advanced parameters for the database.�h]�(hJ�Use the �����}�(h jLh!hh"NhNubh`)��}�(h�155*Advanced*�h]�hJ�Advanced�����}�(h jTh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jLubhJ�1 tab to set advanced parameters for the database.�����}�(h jLh!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)��}�(hXUse *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 jsh!hh"NhNubh`)��}�(h�*Schema restriction*�h]�hJ�Schema restriction�����}�(h j{h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jsubhJ�� 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 jsh!hh"NhNubh`)��}�(h�*public*�h]�hJ�public�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jsubhJ� so that only �����}�(h jsh!hh"NhNubh`)��}�(h�*public*�h]�hJ�public�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jsubhJ�S are shown in165the pgAdmin browser.Separate entries with a comma or tab as you type.�����}�(h jsh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK{h joubah}�(h]�h]�h]�h]�h]�uhj-h"h#hK{h jlh!hubah}�(h]�h]�h]�h]�h]�j�juhj(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 jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jh!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 jh!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}�jjUsuhh�h"h#hK�h jh!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 jWh!hh"NhNubh`)��}�(h�*hr*�h]�hJ�hr�����}�(h j_h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jWubhJ� that is owned by �����}�(h jWh!hh"NhNubh`)��}�(h�179*postgres*�h]�hJ�postgres�����}�(h jqh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jWubhJ�O. It180allows unlimited connections, and is available to all authenticated users.�����}�(h jWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jh!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�juhj(h"h#hK�h jh!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	hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�185translated�Kuuhh�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]�has�nameids�}�(jD	hjC	j@	j;	j8	u�	nametypes�}�(jD	�jC	�j;	�uh}�(hh&j@	h&j8	ju�
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.
codekingpro/portable-devtools · Team Ai