Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

LikeSaveClone

rootpgsqlpgAdmin 4docsen_UShtmllanguage_dialog.html

language_dialog.html233 linesCopy pathDownload Raw Back to html

1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6  <head>
7    <meta charset="utf-8" />
8    <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10    <title>Language Dialog &#8212; pgAdmin 4 8.6 documentation</title>
11    <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12    <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13    
14    <script src="_static/documentation_options.js?v=d4c83366"></script>
15    <script src="_static/doctools.js?v=9a2dae69"></script>
16    <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17    
18    <script src="_static/sidebar.js"></script>
19    
20    <link rel="index" title="Index" href="genindex.html" />
21    <link rel="search" title="Search" href="search.html" />
22    <link rel="next" title="Materialized View Dialog" href="materialized_view_dialog.html" />
23    <link rel="prev" title="Function Dialog" href="function_dialog.html" /> 
24  </head><body>
25    <div class="related" role="navigation" aria-label="related navigation">
26      <h3>Navigation</h3>
27      <ul>
28        <li class="right" style="margin-right: 10px">
29          <a href="genindex.html" title="General Index"
30             accesskey="I">index</a></li>
31        <li class="right" >
32          <a href="materialized_view_dialog.html" title="Materialized View Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="function_dialog.html" title="Function Dialog"
36             accesskey="P">previous</a> |</li>
37        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
38          <li class="nav-item nav-item-1"><a href="managing_database_objects.html" accesskey="U">Managing Database Objects</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">Language Dialog</a></li> 
40      </ul>
41    </div>  
42
43    <div class="document">
44      <div class="documentwrapper">
45        <div class="bodywrapper">
46          <div class="body" role="main">
47            
48  <section id="language-dialog">
49<span id="language"></span><h1><span class="target" id="index-0"></span>Language Dialog<a class="headerlink" href="#language-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the CREATE LANGUAGE dialog to register a new procedural language.</p>
51<p>The <em>Language</em> dialog organizes the registration of a procedural language
52through the following dialog tabs: <em>General</em>, <em>Definition</em>,  and <em>Security</em>.
53The <em>SQL</em> tab displays the SQL code generated by dialog selections.</p>
54<img alt="Language dialog general tab" class="align-center" src="_images/language_general.png" />
55<p>Use the fields in the <em>General</em> tab to identify a language:</p>
56<ul class="simple">
57<li><p>Use the drop-down listbox next to <em>Name</em> to select a language script.</p></li>
58<li><p>Use the drop-down listbox next to <em>Owner</em> to select a role.</p></li>
59<li><p>Store notes about the language in the <em>Comment</em> field.</p></li>
60</ul>
61<p>Click the <em>Definition</em> tab to continue.</p>
62<img alt="Language dialog definition tab" class="align-center" src="_images/language_definition.png" />
63<p>Use the fields in the <em>Definition</em> tab to define parameters:</p>
64<ul class="simple">
65<li><p>Move the <em>Trusted?</em> switch to the <em>No</em> position to specify only users with
66PostgreSQL superuser privilege can use this language. The default is <em>Yes</em>.</p></li>
67<li><p>When enabled, use the drop-down listbox next to <em>Handler Function</em> to select
68the function that will be called to execute the language’s functions.</p></li>
69<li><p>When enabled, use the drop-down listbox next to <em>Inline Function</em> to select
70the function that will be called to execute an anonymous code block (DO
71command) in this language.</p></li>
72<li><p>When enabled, use the drop-down listbox next to <em>Validator Function</em> to
73select the function that will be called when a new function in the language
74is created, to validate the new function.</p></li>
75</ul>
76<p>Click the <em>Security</em> tab to continue.</p>
77<img alt="Language dialog security tab" class="align-center" src="_images/language_security.png" />
78<p>Use the <em>Security</em> tab to assign privileges and define security labels.</p>
79<p>Use the <em>Privileges</em> panel to assign privileges to a role. Click the <em>Add</em> icon
80(+) to set privileges for database objects:</p>
81<ul class="simple">
82<li><p>Select the name of the role from the drop-down listbox in the <em>Grantee</em> field.</p></li>
83<li><p>Click inside the <em>Privileges</em> field. Check the boxes to the left of one or
84more privileges to grant the selected privilege to the specified user.</p></li>
85<li><p>The current user, who is the default grantor for granting the privilege, is displayed in the <em>Grantor</em> field.</p></li>
86</ul>
87<p>Click the <em>Add</em> icon (+) to assign additional privileges; to discard a
88privilege, click the trash icon to the left of the row and confirm deletion in
89the <em>Delete Row</em> popup.</p>
90<p>Use the <em>Security Labels</em> panel to define security labels applied to the
91function. Click the <em>Add</em> icon (+) to add each security label selection:</p>
92<ul class="simple">
93<li><p>Specify a security label provider in the <em>Provider</em> field. The named provider
94must be loaded and must consent to the proposed labeling operation.</p></li>
95<li><p>Specify a a security label in the <em>Security Label</em> field. The meaning of a
96given label is at the discretion of the label provider. PostgreSQL places no
97restrictions on whether or how a label provider must interpret security
98labels; it merely provides a mechanism for storing them.</p></li>
99</ul>
100<p>Click the <em>Add</em> icon (+) to assign additional security labels; to discard a
101security label, click the trash icon to the left of the row and confirm deletion
102in the <em>Delete Row</em> popup.</p>
103<p>Click the <em>SQL</em> tab to continue.</p>
104<p>Your entries in the <em>Language</em> dialog generate a SQL command (see an example
105below). Use the <em>SQL</em> tab for review; revisit or switch tabs to make any changes
106to the SQL command.</p>
107<section id="example">
108<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
109<p>The following is an example of the sql command generated by user selections in
110the <em>Language</em> dialog:</p>
111<img alt="Language dialog sql tab" class="align-center" src="_images/language_sql.png" />
112<p>The example shown demonstrates creating the trusted procedural language named <em>mylan</em>.</p>
113<ul class="simple">
114<li><p>Click the <em>Info</em> button (i) to access online help.</p></li>
115<li><p>Click the <em>Save</em> button to save work.</p></li>
116<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
117<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
118</ul>
119</section>
120</section>
121
122
123            <div class="clearer"></div>
124          </div>
125        </div>
126      </div>
127      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
128        <div class="sphinxsidebarwrapper">
129  <div>
130    <h3><a href="index.html">Table of Contents</a></h3>
131    <ul>
132<li><a class="reference internal" href="#">Language Dialog</a><ul>
133<li><a class="reference internal" href="#example">Example</a></li>
134</ul>
135</li>
136</ul>
137
138  </div>
139<h3><a href="index.html">Table of Contents</a></h3>
140<ul class="current">
141<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
142<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
143<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
144<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
145<li class="toctree-l1 current"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a><ul class="current">
146<li class="toctree-l2"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
147<li class="toctree-l2"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
148<li class="toctree-l2"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
149<li class="toctree-l2"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
150<li class="toctree-l2"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
151<li class="toctree-l2"><a class="reference internal" href="event_trigger_dialog.html">Event Trigger Dialog</a></li>
152<li class="toctree-l2"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
153<li class="toctree-l2"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
154<li class="toctree-l2"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
155<li class="toctree-l2"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
156<li class="toctree-l2"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
157<li class="toctree-l2"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
158<li class="toctree-l2"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
159<li class="toctree-l2"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
160<li class="toctree-l2"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
161<li class="toctree-l2 current"><a class="current reference internal" href="#">Language Dialog</a></li>
162<li class="toctree-l2"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
163<li class="toctree-l2"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
164<li class="toctree-l2"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
165<li class="toctree-l2"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
166<li class="toctree-l2"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
167<li class="toctree-l2"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
168<li class="toctree-l2"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
169<li class="toctree-l2"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
170<li class="toctree-l2"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
171<li class="toctree-l2"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
172<li class="toctree-l2"><a class="reference internal" href="user_mapping_dialog.html">User Mapping Dialog</a></li>
173<li class="toctree-l2"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
174</ul>
175</li>
176<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
177<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
178<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
179<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
180<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
181<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
182<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
183<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
184<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
185</ul>
186
187<search id="searchbox" style="display: none" role="search">
188  <h3 id="searchlabel">Quick search</h3>
189    <div class="searchformwrapper">
190    <form class="search" action="search.html" method="get">
191      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
192      <input type="submit" value="Go" />
193    </form>
194    </div>
195</search>
196<script>document.getElementById('searchbox').style.display = "block"</script>
197        </div>
198<div id="sidebarbutton" title="Collapse sidebar">
199<span>«</span>
200</div>
201
202      </div>
203      <div class="clearer"></div>
204    </div>
205    <div class="related" role="navigation" aria-label="related navigation">
206      <h3>Navigation</h3>
207      <ul>
208        <li class="right" style="margin-right: 10px">
209          <a href="genindex.html" title="General Index"
210             >index</a></li>
211        <li class="right" >
212          <a href="materialized_view_dialog.html" title="Materialized View Dialog"
213             >next</a> |</li>
214        <li class="right" >
215          <a href="function_dialog.html" title="Function Dialog"
216             >previous</a> |</li>
217        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
218          <li class="nav-item nav-item-1"><a href="managing_database_objects.html" >Managing Database Objects</a> &#187;</li>
219        <li class="nav-item nav-item-this"><a href="">Language Dialog</a></li> 
220      </ul>
221    </div>
222    <div class="footer" role="contentinfo">
223        <div class="related" role="navigation" aria-label="related navigation">
224          <ul>
225              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
226            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
227            <li class="right" ><a href="materialized_view_dialog.html" title="Materialized View Dialog" accesskey="N">next</a> |</li>
228            <li class="right" ><a href="function_dialog.html" title="Function Dialog" accesskey="P">previous</a> |</li>
229          </ul>
230        </div>
231    </div>
232  </body>
233</html>