forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
76 lines
6.5 KiB
HTML
76 lines
6.5 KiB
HTML
<a name="EN-US_TOPIC_0000001764491740"></a><a name="EN-US_TOPIC_0000001764491740"></a>
|
|
|
|
<h1 class="topictitle1">PG_NAMESPACE</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001764491740__en-us_topic_0059779337_p9481321536"><strong id="EN-US_TOPIC_0000001764491740__b15555204573819">PG_NAMESPACE</strong> records the namespaces, that is, schema-related information.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491740__te459a3c807504d1b88d44c6c0179d0cb" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_NAMESPACE columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491740__r98be424293e141cdbbfa21932d698f37"><th align="left" class="cellrowborder" valign="top" width="20.13%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001764491740__aa08884513f254d4d8a7ccb87fa0ddf7d"><strong id="EN-US_TOPIC_0000001764491740__b4466163743434">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="17.669999999999998%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001764491740__a12233cbb9edb402ebfd2ccc77a33924f">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="62.2%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001764491740__a037267ea48ee4269ab4dc1c2e0b73c05">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764491740__rff72d95f9295407e88d7a6861128816d"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__a9686c50ba71e47bfa2f8e4234e42ef3c">nspname</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__a1fa12dca819a415ba88520ef9c2babee">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__a0794f21477464aeeb39b953c225d01b6">Name of the namespace</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__r1e576b714ecb4fd69ad3ab3d33585ffd"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__ac2f62d1ef60c4e7e9e4fe435f1e7aa24">nspowner</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__ac2b31ff574c94b2594b0f9e65069028d">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__a5a0994c321a3494ead070edbe723276d">Owner of the namespace</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__r9bfd3572b93e42b29fc73ac80a69ece6"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__a679eb9c67757476fa304020f5f9d1648">nsptimeline</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__a354a2a062f654760a85fc83d978b67f8">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__a96a1ad1da24944cbb952fac59468c8fb">Timeline when the namespace is created on the DN This column is for internal use and valid only on the DN.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__r3a41cd0b66b04b80a3186f0188fd5462"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__a5bb27b5cb49b4197b23467c5075a5f0a">nspacl</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__a9839fdc8a88e498bb7976e64172e1739">aclitem[]</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__a6158e89334684417ab2f3eec280b553f">Access permissions For details, see GRANT and REVOKE.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__row1257718175015"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__p10571186506">permspace</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__p35713186500">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__p05771812501">Quota of a schema's permanent tablespace</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__row10451128514"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__p114601225116">usedspace</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__p746101265115">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__p1046612205115">Used size of a schema's permanent tablespace</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491740__row86602096418"><td class="cellrowborder" valign="top" width="20.13%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764491740__p1616591519418">nsptype</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.669999999999998%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764491740__p111652152419">Char</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="62.2%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764491740__p201650151843">Distinguishes external schemas from common schemas. This parameter is supported only in 8.3.0 and later versions to adapt to LakeFormation features.</p>
|
|
<div class="note" id="EN-US_TOPIC_0000001764491740__note96351515462"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="EN-US_TOPIC_0000001764491740__p44717221656">The <strong id="EN-US_TOPIC_0000001764491740__b592319272285">nsptype</strong> field is added to distinguish external schemas from common schemas.</p>
|
|
<ul id="EN-US_TOPIC_0000001764491740__ul52728410617"><li id="EN-US_TOPIC_0000001764491740__li4272048618"><strong id="EN-US_TOPIC_0000001764491740__b6123658102714">e</strong> indicates an external schema.</li><li id="EN-US_TOPIC_0000001764491740__li0272144364"><strong id="EN-US_TOPIC_0000001764491740__b9201135182817">i</strong> indicates a common schema.</li></ul>
|
|
</div></div>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0561.html">System Catalogs</a></div>
|
|
</div>
|
|
</div>
|
|
|