API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 24th, 2017
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.85 KB | None | 0 0
raw download clone embed print report
  1. diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
  2. index 71c86142a6..b2fae027f5 100644
  3. --- a/doc/src/sgml/catalogs.sgml
  4. +++ b/doc/src/sgml/catalogs.sgml
  5. @@ -221,6 +221,11 @@
  6. </row>
  7.  
  8. <row>
  9. + <entry><link linkend="catalog-pg-partitioned-table"><structname>pg_partitioned_table</structname></link></entry>
  10. + <entry>information about partition key of tables</entry>
  11. + </row>
  12. +
  13. + <row>
  14. <entry><link linkend="catalog-pg-pltemplate"><structname>pg_pltemplate</structname></link></entry>
  15. <entry>template data for procedural languages</entry>
  16. </row>
  17. @@ -236,6 +241,16 @@
  18. </row>
  19.  
  20. <row>
  21. + <entry><link linkend="catalog-pg-publication"><structname>pg_publication</structname></link></entry>
  22. + <entry>publications for logical replication</entry>
  23. + </row>
  24. +
  25. + <row>
  26. + <entry><link linkend="catalog-pg-publication-rel"><structname>pg_publication_rel</structname></link></entry>
  27. + <entry>relation to publication mapping</entry>
  28. + </row>
  29. +
  30. + <row>
  31. <entry><link linkend="catalog-pg-range"><structname>pg_range</structname></link></entry>
  32. <entry>information about range types</entry>
  33. </row>
  34. @@ -256,6 +271,11 @@
  35. </row>
  36.  
  37. <row>
  38. + <entry><link linkend="catalog-pg-sequence"><structname>pg_sequence</structname></link></entry>
  39. + <entry>information about sequences</entry>
  40. + </row>
  41. +
  42. + <row>
  43. <entry><link linkend="catalog-pg-shdepend"><structname>pg_shdepend</structname></link></entry>
  44. <entry>dependencies on shared objects</entry>
  45. </row>
  46. @@ -276,6 +296,21 @@
  47. </row>
  48.  
  49. <row>
  50. + <entry><link linkend="catalog-pg-statistic-ext"><structname>pg_statistic_ext</structname></link></entry>
  51. + <entry>extended planner statistics</entry>
  52. + </row>
  53. +
  54. + <row>
  55. + <entry><link linkend="catalog-pg-subscription"><structname>pg_subscription</structname></link></entry>
  56. + <entry>logical replication subscriptions</entry>
  57. + </row>
  58. +
  59. + <row>
  60. + <entry><link linkend="catalog-pg-subscription-rel"><structname>pg_subscription_rel</structname></link></entry>
  61. + <entry>relation state for subscriptions</entry>
  62. + </row>
  63. +
  64. + <row>
  65. <entry><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link></entry>
  66. <entry>tablespaces within this database cluster</entry>
  67. </row>
  68. @@ -1095,6 +1130,17 @@
  69. </row>
  70.  
  71. <row>
  72. + <entry><structfield>attidentity</structfield></entry>
  73. + <entry><type>char</type></entry>
  74. + <entry></entry>
  75. + <entry>
  76. + If a zero byte (<literal>''</literal>), then not an identity column.
  77. + Otherwise, <literal>a</literal> = generated
  78. + always, <literal>d</literal> = generated by default.
  79. + </entry>
  80. + </row>
  81. +
  82. + <row>
  83. <entry><structfield>attisdropped</structfield></entry>
  84. <entry><type>bool</type></entry>
  85. <entry></entry>
  86. @@ -1309,14 +1355,8 @@
  87. <entry><structfield>rolpassword</structfield></entry>
  88. <entry><type>text</type></entry>
  89. <entry>
  90. - Password (possibly encrypted); null if none. If the password
  91. - is encrypted, this column will begin with the string <literal>md5</>
  92. - followed by a 32-character hexadecimal MD5 hash. The MD5 hash
  93. - will be of the user's password concatenated to their user name.
  94. - For example, if user <literal>joe</> has password <literal>xyzzy</>,
  95. - <productname>PostgreSQL</> will store the md5 hash of
  96. - <literal>xyzzyjoe</>. A password that does not follow that
  97. - format is assumed to be unencrypted.
  98. + Password (possibly encrypted); null if none. The format depends
  99. + on the form of encryption used.
  100. </entry>
  101. </row>
  102.  
  103. @@ -1330,6 +1370,29 @@
  104. </tgroup>
  105. </table>
  106.  
  107. + <para>
  108. + For an MD5 encrypted password, <structfield>rolpassword</structfield>
  109. + column will begin with the string <literal>md5</> followed by a
  110. + 32-character hexadecimal MD5 hash. The MD5 hash will be of the user's
  111. + password concatenated to their user name. For example, if user
  112. + <literal>joe</> has password <literal>xyzzy</>, <productname>PostgreSQL</>
  113. + will store the md5 hash of <literal>xyzzyjoe</>.
  114. + </para>
  115. +
  116. + <para>
  117. + If the password is encrypted with SCRAM-SHA-256, it has the format:
  118. +<synopsis>
  119. +SCRAM-SHA-256$<replaceable><iteration count></>:<replaceable><salt></>$<replaceable><StoredKey></>:<replaceable><ServerKey></>
  120. +</synopsis>
  121. + where <replaceable>salt</>, <replaceable>StoredKey</> and
  122. + <replaceable>ServerKey</> are in Base64 encoded format. This format is
  123. + the same as that specified by RFC 5803.
  124. + </para>
  125. +
  126. + <para>
  127. + A password that does not follow either of those formats is assumed to be
  128. + unencrypted.
  129. + </para>
  130. </sect1>
  131.  
  132.  
  133. @@ -1541,7 +1604,8 @@
  134. The catalog <structname>pg_class</structname> catalogs tables and most
  135. everything else that has columns or is otherwise similar to a
  136. table. This includes indexes (but see also
  137. - <structname>pg_index</structname>), sequences, views, materialized
  138. + <structname>pg_index</structname>), sequences (but see also
  139. + <structname>pg_sequence</structname>), views, materialized
  140. views, composite types, and TOAST tables; see <structfield>relkind</>.
  141. Below, when we mean all of these
  142. kinds of objects we speak of <quote>relations</quote>. Not all
  143. @@ -1723,11 +1787,15 @@
  144. <entry><type>char</type></entry>
  145. <entry></entry>
  146. <entry>
  147. - <literal>r</> = ordinary table, <literal>i</> = index,
  148. - <literal>S</> = sequence, <literal>v</> = view,
  149. + <literal>r</> = ordinary table,
  150. + <literal>i</> = index,
  151. + <literal>S</> = sequence,
  152. + <literal>t</> = TOAST table,
  153. + <literal>v</> = view,
  154. <literal>m</> = materialized view,
  155. - <literal>c</> = composite type, <literal>t</> = TOAST table,
  156. - <literal>f</> = foreign table
  157. + <literal>c</> = composite type,
  158. + <literal>f</> = foreign table,
  159. + <literal>p</> = partitioned table
  160. </entry>
  161. </row>
  162.  
  163. @@ -1840,6 +1908,13 @@
  164. </row>
  165.  
  166. <row>
  167. + <entry><structfield>relispartition</structfield></entry>
  168. + <entry><type>bool</type></entry>
  169. + <entry></entry>
  170. + <entry>True if table is a partition</entry>
  171. + </row>
  172. +
  173. + <row>
  174. <entry><structfield>relfrozenxid</structfield></entry>
  175. <entry><type>xid</type></entry>
  176. <entry></entry>
  177. @@ -1847,7 +1922,7 @@
  178. All transaction IDs before this one have been replaced with a permanent
  179. (<quote>frozen</>) transaction ID in this table. This is used to track
  180. whether the table needs to be vacuumed in order to prevent transaction
  181. - ID wraparound or to allow <literal>pg_clog</> to be shrunk. Zero
  182. + ID wraparound or to allow <literal>pg_xact</> to be shrunk. Zero
  183. (<symbol>InvalidTransactionId</symbol>) if the relation is not a table.
  184. </entry>
  185. </row>
  186. @@ -1885,6 +1960,16 @@
  187. Access-method-specific options, as <quote>keyword=value</> strings
  188. </entry>
  189. </row>
  190. +
  191. + <row>
  192. + <entry><structfield>relpartbound</structfield></entry>
  193. + <entry><type>pg_node_tree</type></entry>
  194. + <entry></entry>
  195. + <entry>
  196. + If table is a partition (see <structfield>relispartition</structfield>),
  197. + internal representation of the partition bound
  198. + </entry>
  199. + </row>
  200. </tbody>
  201. </tgroup>
  202. </table>
  203. @@ -1960,6 +2045,14 @@
  204. </row>
  205.  
  206. <row>
  207. + <entry><structfield>collprovider</structfield></entry>
  208. + <entry><type>char</type></entry>
  209. + <entry></entry>
  210. + <entry>Provider of the collation: <literal>d</literal> = database
  211. + default, <literal>c</literal> = libc, <literal>i</literal> = icu</entry>
  212. + </row>
  213. +
  214. + <row>
  215. <entry><structfield>collencoding</structfield></entry>
  216. <entry><type>int4</type></entry>
  217. <entry></entry>
  218. @@ -1980,6 +2073,17 @@
  219. <entry></entry>
  220. <entry><symbol>LC_CTYPE</> for this collation object</entry>
  221. </row>
  222. +
  223. + <row>
  224. + <entry><structfield>collversion</structfield></entry>
  225. + <entry><type>text</type></entry>
  226. + <entry></entry>
  227. + <entry>
  228. + Provider-specific version of the collation. This is recorded when the
  229. + collation is created and then checked when it is used, to detect
  230. + changes in the collation definition that could lead to data corruption.
  231. + </entry>
  232. + </row>
  233. </tbody>
  234. </tgroup>
  235. </table>
  236. @@ -2514,7 +2618,7 @@
  237. All transaction IDs before this one have been replaced with a permanent
  238. (<quote>frozen</>) transaction ID in this database. This is used to
  239. track whether the database needs to be vacuumed in order to prevent
  240. - transaction ID wraparound or to allow <literal>pg_clog</> to be shrunk.
  241. + transaction ID wraparound or to allow <literal>pg_xact</> to be shrunk.
  242. It is the minimum of the per-table
  243. <structname>pg_class</>.<structfield>relfrozenxid</> values.
  244. </entry>
  245. @@ -4167,6 +4271,7 @@
  246. </table>
  247. </sect1>
  248.  
  249. +
  250. <sect1 id="catalog-pg-namespace">
  251. <title><structname>pg_namespace</structname></title>
  252.  
  253. @@ -4583,6 +4688,111 @@
  254. </sect1>
  255.  
  256.  
  257. + <sect1 id="catalog-pg-partitioned-table">
  258. + <title><structname>pg_partitioned_table</structname></title>
  259. +
  260. + <indexterm zone="catalog-pg-partitioned-table">
  261. + <primary>pg_partitioned_table</primary>
  262. + </indexterm>
  263. +
  264. + <para>
  265. + The catalog <structname>pg_partitioned_table</structname> stores
  266. + information about how tables are partitioned.
  267. + </para>
  268. +
  269. + <table>
  270. + <title><structname>pg_partitioned_table</> Columns</title>
  271. +
  272. + <tgroup cols="4">
  273. + <thead>
  274. + <row>
  275. + <entry>Name</entry>
  276. + <entry>Type</entry>
  277. + <entry>References</entry>
  278. + <entry>Description</entry>
  279. + </row>
  280. + </thead>
  281. +
  282. + <tbody>
  283. +
  284. + <row>
  285. + <entry><structfield>partrelid</structfield></entry>
  286. + <entry><type>oid</type></entry>
  287. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
  288. + <entry>The OID of the <structname>pg_class</> entry for this partitioned table</entry>
  289. + </row>
  290. +
  291. + <row>
  292. + <entry><structfield>partstrat</structfield></entry>
  293. + <entry><type>char</type></entry>
  294. + <entry></entry>
  295. + <entry>
  296. + Partitioning strategy; <literal>l</> = list partitioned table,
  297. + <literal>r</> = range partitioned table
  298. + </entry>
  299. + </row>
  300. +
  301. + <row>
  302. + <entry><structfield>partnatts</structfield></entry>
  303. + <entry><type>int2</type></entry>
  304. + <entry></entry>
  305. + <entry>The number of columns in partition key</entry>
  306. + </row>
  307. +
  308. + <row>
  309. + <entry><structfield>partattrs</structfield></entry>
  310. + <entry><type>int2vector</type></entry>
  311. + <entry><literal><link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.attnum</literal></entry>
  312. + <entry>
  313. + This is an array of <structfield>partnatts</structfield> values that
  314. + indicate which table columns are part of the partition key. For
  315. + example, a value of <literal>1 3</literal> would mean that the first
  316. + and the third table columns make up the partition key. A zero in this
  317. + array indicates that the corresponding partition key column is an
  318. + expression, rather than a simple column reference.
  319. + </entry>
  320. + </row>
  321. +
  322. + <row>
  323. + <entry><structfield>partclass</structfield></entry>
  324. + <entry><type>oidvector</type></entry>
  325. + <entry><literal><link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link>.oid</literal></entry>
  326. + <entry>
  327. + For each column in the partition key, this contains the OID of the
  328. + operator class to use. See
  329. + <link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link> for details.
  330. + </entry>
  331. + </row>
  332. +
  333. + <row>
  334. + <entry><structfield>partcollation</structfield></entry>
  335. + <entry><type>oidvector</type></entry>
  336. + <entry><literal><link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link>.oid</literal></entry>
  337. + <entry>
  338. + For each column in the partition key, this contains the OID of the
  339. + the collation to use for partitioning.
  340. + </entry>
  341. + </row>
  342. +
  343. + <row>
  344. + <entry><structfield>partexprs</structfield></entry>
  345. + <entry><type>pg_node_tree</type></entry>
  346. + <entry></entry>
  347. + <entry>
  348. + Expression trees (in <function>nodeToString()</function>
  349. + representation) for partition key columns that are not simple column
  350. + references. This is a list with one element for each zero
  351. + entry in <structfield>partattrs</>. Null if all partition key columns
  352. + are simple references.
  353. + </entry>
  354. + </row>
  355. +
  356. + </tbody>
  357. + </tgroup>
  358. + </table>
  359. + </sect1>
  360. +
  361. +
  362. <sect1 id="catalog-pg-pltemplate">
  363. <title><structname>pg_pltemplate</structname></title>
  364.  
  365. @@ -4689,6 +4899,7 @@
  366.  
  367. </sect1>
  368.  
  369. +
  370. <sect1 id="catalog-pg-policy">
  371. <title><structname>pg_policy</structname></title>
  372.  
  373. @@ -4748,6 +4959,13 @@
  374. </row>
  375.  
  376. <row>
  377. + <entry><structfield>polpermissive</structfield></entry>
  378. + <entry><type>boolean</type></entry>
  379. + <entry></entry>
  380. + <entry>Is the policy permissive or restrictive?</entry>
  381. + </row>
  382. +
  383. + <row>
  384. <entry><structfield>polroles</structfield></entry>
  385. <entry><type>oid[]</type></entry>
  386. <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
  387. @@ -5131,6 +5349,137 @@
  388.  
  389. </sect1>
  390.  
  391. + <sect1 id="catalog-pg-publication">
  392. + <title><structname>pg_publication</structname></title>
  393. +
  394. + <indexterm zone="catalog-pg-publication">
  395. + <primary>pg_publication</primary>
  396. + </indexterm>
  397. +
  398. + <para>
  399. + The catalog <structname>pg_publication</structname> contains all
  400. + publications created in the database. For more on publications see
  401. + <xref linkend="logical-replication-publication">.
  402. + </para>
  403. +
  404. + <table>
  405. + <title><structname>pg_publication</structname> Columns</title>
  406. +
  407. + <tgroup cols="4">
  408. + <thead>
  409. + <row>
  410. + <entry>Name</entry>
  411. + <entry>Type</entry>
  412. + <entry>References</entry>
  413. + <entry>Description</entry>
  414. + </row>
  415. + </thead>
  416. +
  417. + <tbody>
  418. + <row>
  419. + <entry><structfield>oid</structfield></entry>
  420. + <entry><type>oid</type></entry>
  421. + <entry></entry>
  422. + <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
  423. + </row>
  424. +
  425. + <row>
  426. + <entry><structfield>pubname</structfield></entry>
  427. + <entry><type>Name</type></entry>
  428. + <entry></entry>
  429. + <entry>Name of the publication</entry>
  430. + </row>
  431. +
  432. + <row>
  433. + <entry><structfield>pubowner</structfield></entry>
  434. + <entry><type>oid</type></entry>
  435. + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
  436. + <entry>Owner of the publication</entry>
  437. + </row>
  438. +
  439. + <row>
  440. + <entry><structfield>puballtables</structfield></entry>
  441. + <entry><type>bool</type></entry>
  442. + <entry></entry>
  443. + <entry>If true, this publication automatically includes all tables
  444. + in the database, including any that will be created in the future.
  445. + </entry>
  446. + </row>
  447. +
  448. + <row>
  449. + <entry><structfield>pubinsert</structfield></entry>
  450. + <entry><type>bool</type></entry>
  451. + <entry></entry>
  452. + <entry>If true, <command>INSERT</command> operations are replicated for
  453. + tables in the publication.</entry>
  454. + </row>
  455. +
  456. + <row>
  457. + <entry><structfield>pubupdate</structfield></entry>
  458. + <entry><type>bool</type></entry>
  459. + <entry></entry>
  460. + <entry>If true, <command>UPDATE</command> operations are replicated for
  461. + tables in the publication.</entry>
  462. + </row>
  463. +
  464. + <row>
  465. + <entry><structfield>pubdelete</structfield></entry>
  466. + <entry><type>bool</type></entry>
  467. + <entry></entry>
  468. + <entry>If true, <command>DELETE</command> operations are replicated for
  469. + tables in the publication.</entry>
  470. + </row>
  471. + </tbody>
  472. + </tgroup>
  473. + </table>
  474. + </sect1>
  475. +
  476. + <sect1 id="catalog-pg-publication-rel">
  477. + <title><structname>pg_publication_rel</structname></title>
  478. +
  479. + <indexterm zone="catalog-pg-publication-rel">
  480. + <primary>pg_publication_rel</primary>
  481. + </indexterm>
  482. +
  483. + <para>
  484. + The catalog <structname>pg_publication_rel</structname> contains the
  485. + mapping between relations and publications in the database. This is a
  486. + many-to-many mapping. See also <xref linkend="view-pg-publication-tables">
  487. + for a more user-friendly view of this information.
  488. + </para>
  489. +
  490. + <table>
  491. + <title><structname>pg_publication_rel</structname> Columns</title>
  492. +
  493. + <tgroup cols="4">
  494. + <thead>
  495. + <row>
  496. + <entry>Name</entry>
  497. + <entry>Type</entry>
  498. + <entry>References</entry>
  499. + <entry>Description</entry>
  500. + </row>
  501. + </thead>
  502. +
  503. + <tbody>
  504. + <row>
  505. + <entry><structfield>prpubid</structfield></entry>
  506. + <entry><type>oid</type></entry>
  507. + <entry><literal><link linkend="catalog-pg-publication"><structname>pg_publication</structname></link>.oid</literal></entry>
  508. + <entry>Reference to publication</entry>
  509. + </row>
  510. +
  511. + <row>
  512. + <entry><structfield>prrelid</structfield></entry>
  513. + <entry><type>oid</type></entry>
  514. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
  515. + <entry>Reference to relation</entry>
  516. + </row>
  517. + </tbody>
  518. + </tgroup>
  519. + </table>
  520. + </sect1>
  521. +
  522. <sect1 id="catalog-pg-range">
  523. <title><structname>pg_range</structname></title>
  524.  
  525. @@ -5453,33 +5802,120 @@
  526. </table>
  527. </sect1>
  528.  
  529. - <sect1 id="catalog-pg-shdepend">
  530. - <title><structname>pg_shdepend</structname></title>
  531. + <sect1 id="catalog-pg-sequence">
  532. + <title><structname>pg_sequence</structname></title>
  533.  
  534. - <indexterm zone="catalog-pg-shdepend">
  535. - <primary>pg_shdepend</primary>
  536. + <indexterm zone="catalog-pg-sequence">
  537. + <primary>pg_sequence</primary>
  538. </indexterm>
  539.  
  540. <para>
  541. - The catalog <structname>pg_shdepend</structname> records the
  542. - dependency relationships between database objects and shared objects,
  543. - such as roles. This information allows
  544. - <productname>PostgreSQL</productname> to ensure that those objects are
  545. - unreferenced before attempting to delete them.
  546. + The catalog <structname>pg_sequence</structname> contains information about
  547. + sequences. Some of the information about sequences, such as the name and
  548. + the schema, is in <structname>pg_class</structname>.
  549. </para>
  550.  
  551. - <para>
  552. - See also <link linkend="catalog-pg-depend"><structname>pg_depend</structname></link>,
  553. - which performs a similar function for dependencies involving objects
  554. - within a single database.
  555. - </para>
  556. + <table>
  557. + <title><structname>pg_sequence</> Columns</title>
  558.  
  559. - <para>
  560. - Unlike most system catalogs, <structname>pg_shdepend</structname>
  561. - is shared across all databases of a cluster: there is only one
  562. - copy of <structname>pg_shdepend</structname> per cluster, not
  563. - one per database.
  564. - </para>
  565. + <tgroup cols="4">
  566. + <thead>
  567. + <row>
  568. + <entry>Name</entry>
  569. + <entry>Type</entry>
  570. + <entry>References</entry>
  571. + <entry>Description</entry>
  572. + </row>
  573. + </thead>
  574. +
  575. + <tbody>
  576. + <row>
  577. + <entry><structfield>seqrelid</structfield></entry>
  578. + <entry><type>oid</type></entry>
  579. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
  580. + <entry>The OID of the <structname>pg_class</> entry for this sequence</entry>
  581. + </row>
  582. +
  583. + <row>
  584. + <entry><structfield>seqtypid</structfield></entry>
  585. + <entry><type>oid</type></entry>
  586. + <entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
  587. + <entry>Data type of the sequence</entry>
  588. + </row>
  589. +
  590. + <row>
  591. + <entry><structfield>seqstart</structfield></entry>
  592. + <entry><type>int8</type></entry>
  593. + <entry></entry>
  594. + <entry>Start value of the sequence</entry>
  595. + </row>
  596. +
  597. + <row>
  598. + <entry><structfield>seqincrement</structfield></entry>
  599. + <entry><type>int8</type></entry>
  600. + <entry></entry>
  601. + <entry>Increment value of the sequence</entry>
  602. + </row>
  603. +
  604. + <row>
  605. + <entry><structfield>seqmax</structfield></entry>
  606. + <entry><type>int8</type></entry>
  607. + <entry></entry>
  608. + <entry>Maximum value of the sequence</entry>
  609. + </row>
  610. +
  611. + <row>
  612. + <entry><structfield>seqmin</structfield></entry>
  613. + <entry><type>int8</type></entry>
  614. + <entry></entry>
  615. + <entry>Minimum value of the sequence</entry>
  616. + </row>
  617. +
  618. + <row>
  619. + <entry><structfield>seqcache</structfield></entry>
  620. + <entry><type>int8</type></entry>
  621. + <entry></entry>
  622. + <entry>Cache size of the sequence</entry>
  623. + </row>
  624. +
  625. + <row>
  626. + <entry><structfield>seqcycle</structfield></entry>
  627. + <entry><type>bool</type></entry>
  628. + <entry></entry>
  629. + <entry>Whether the sequence cycles</entry>
  630. + </row>
  631. + </tbody>
  632. + </tgroup>
  633. + </table>
  634. + </sect1>
  635. +
  636. + <sect1 id="catalog-pg-shdepend">
  637. + <title><structname>pg_shdepend</structname></title>
  638. +
  639. + <indexterm zone="catalog-pg-shdepend">
  640. + <primary>pg_shdepend</primary>
  641. + </indexterm>
  642. +
  643. + <para>
  644. + The catalog <structname>pg_shdepend</structname> records the
  645. + dependency relationships between database objects and shared objects,
  646. + such as roles. This information allows
  647. + <productname>PostgreSQL</productname> to ensure that those objects are
  648. + unreferenced before attempting to delete them.
  649. + </para>
  650. +
  651. + <para>
  652. + See also <link linkend="catalog-pg-depend"><structname>pg_depend</structname></link>,
  653. + which performs a similar function for dependencies involving objects
  654. + within a single database.
  655. + </para>
  656. +
  657. + <para>
  658. + Unlike most system catalogs, <structname>pg_shdepend</structname>
  659. + is shared across all databases of a cluster: there is only one
  660. + copy of <structname>pg_shdepend</structname> per cluster, not
  661. + one per database.
  662. + </para>
  663.  
  664. <table>
  665. <title><structname>pg_shdepend</> Columns</title>
  666. @@ -5930,6 +6366,305 @@
  667.  
  668. </sect1>
  669.  
  670. + <sect1 id="catalog-pg-statistic-ext">
  671. + <title><structname>pg_statistic_ext</structname></title>
  672. +
  673. + <indexterm zone="catalog-pg-statistic-ext">
  674. + <primary>pg_statistic_ext</primary>
  675. + </indexterm>
  676. +
  677. + <para>
  678. + The catalog <structname>pg_statistic_ext</structname>
  679. + holds extended planner statistics.
  680. + Each row in this catalog corresponds to a <firstterm>statistics object</>
  681. + created with <xref linkend="sql-createstatistics">.
  682. + </para>
  683. +
  684. + <table>
  685. + <title><structname>pg_statistic_ext</> Columns</title>
  686. +
  687. + <tgroup cols="4">
  688. + <thead>
  689. + <row>
  690. + <entry>Name</entry>
  691. + <entry>Type</entry>
  692. + <entry>References</entry>
  693. + <entry>Description</entry>
  694. + </row>
  695. + </thead>
  696. +
  697. + <tbody>
  698. +
  699. + <row>
  700. + <entry><structfield>stxrelid</structfield></entry>
  701. + <entry><type>oid</type></entry>
  702. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
  703. + <entry>Table containing the columns described by this object</entry>
  704. + </row>
  705. +
  706. + <row>
  707. + <entry><structfield>stxname</structfield></entry>
  708. + <entry><type>name</type></entry>
  709. + <entry></entry>
  710. + <entry>Name of the statistics object</entry>
  711. + </row>
  712. +
  713. + <row>
  714. + <entry><structfield>stxnamespace</structfield></entry>
  715. + <entry><type>oid</type></entry>
  716. + <entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.oid</literal></entry>
  717. + <entry>
  718. + The OID of the namespace that contains this statistics object
  719. + </entry>
  720. + </row>
  721. +
  722. + <row>
  723. + <entry><structfield>stxowner</structfield></entry>
  724. + <entry><type>oid</type></entry>
  725. + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
  726. + <entry>Owner of the statistics object</entry>
  727. + </row>
  728. +
  729. + <row>
  730. + <entry><structfield>stxkeys</structfield></entry>
  731. + <entry><type>int2vector</type></entry>
  732. + <entry><literal><link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.attnum</literal></entry>
  733. + <entry>
  734. + An array of attribute numbers, indicating which table columns are
  735. + covered by this statistics object;
  736. + for example a value of <literal>1 3</literal> would
  737. + mean that the first and the third table columns are covered
  738. + </entry>
  739. + </row>
  740. +
  741. + <row>
  742. + <entry><structfield>stxkind</structfield></entry>
  743. + <entry><type>char[]</type></entry>
  744. + <entry></entry>
  745. + <entry>
  746. + An array containing codes for the enabled statistic types;
  747. + valid values are:
  748. + <literal>d</literal> for n-distinct statistics,
  749. + <literal>f</literal> for functional dependency statistics
  750. + </entry>
  751. + </row>
  752. +
  753. + <row>
  754. + <entry><structfield>stxndistinct</structfield></entry>
  755. + <entry><type>pg_ndistinct</type></entry>
  756. + <entry></entry>
  757. + <entry>
  758. + N-distinct counts, serialized as <structname>pg_ndistinct</> type
  759. + </entry>
  760. + </row>
  761. +
  762. + <row>
  763. + <entry><structfield>stxdependencies</structfield></entry>
  764. + <entry><type>pg_dependencies</type></entry>
  765. + <entry></entry>
  766. + <entry>
  767. + Functional dependency statistics, serialized
  768. + as <structname>pg_dependencies</> type
  769. + </entry>
  770. + </row>
  771. +
  772. + </tbody>
  773. + </tgroup>
  774. + </table>
  775. +
  776. + <para>
  777. + The <structfield>stxkind</structfield> field is filled at creation of the
  778. + statistics object, indicating which statistic type(s) are desired.
  779. + The fields after it are initially NULL and are filled only when the
  780. + corresponding statistic has been computed by <command>ANALYZE</>.
  781. + </para>
  782. + </sect1>
  783. +
  784. + <sect1 id="catalog-pg-subscription">
  785. + <title><structname>pg_subscription</structname></title>
  786. +
  787. + <indexterm zone="catalog-pg-subscription">
  788. + <primary>pg_subscription</primary>
  789. + </indexterm>
  790. +
  791. + <para>
  792. + The catalog <structname>pg_subscription</structname> contains all existing
  793. + logical replication subscriptions. For more information about logical
  794. + replication see <xref linkend="logical-replication">.
  795. + </para>
  796. +
  797. + <para>
  798. + Unlike most system catalogs, <structname>pg_subscription</structname> is
  799. + shared across all databases of a cluster: There is only one copy
  800. + of <structname>pg_subscription</structname> per cluster, not one per
  801. + database.
  802. + </para>
  803. +
  804. + <para>
  805. + Access to the column <structfield>subconninfo</structfield> is revoked from
  806. + normal users, because it could contain plain-text passwords.
  807. + </para>
  808. +
  809. + <table>
  810. + <title><structname>pg_subscription</structname> Columns</title>
  811. +
  812. + <tgroup cols="4">
  813. + <thead>
  814. + <row>
  815. + <entry>Name</entry>
  816. + <entry>Type</entry>
  817. + <entry>References</entry>
  818. + <entry>Description</entry>
  819. + </row>
  820. + </thead>
  821. +
  822. + <tbody>
  823. + <row>
  824. + <entry><structfield>oid</structfield></entry>
  825. + <entry><type>oid</type></entry>
  826. + <entry></entry>
  827. + <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
  828. + </row>
  829. +
  830. + <row>
  831. + <entry><structfield>subdbid</structfield></entry>
  832. + <entry><type>oid</type></entry>
  833. + <entry><literal><link linkend="catalog-pg-database"><structname>pg_database</structname></link>.oid</literal></entry>
  834. + <entry>OID of the database which the subscription resides in</entry>
  835. + </row>
  836. +
  837. + <row>
  838. + <entry><structfield>subname</structfield></entry>
  839. + <entry><type>name</type></entry>
  840. + <entry></entry>
  841. + <entry>Name of the subscription</entry>
  842. + </row>
  843. +
  844. + <row>
  845. + <entry><structfield>subowner</structfield></entry>
  846. + <entry><type>oid</type></entry>
  847. + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
  848. + <entry>Owner of the subscription</entry>
  849. + </row>
  850. +
  851. + <row>
  852. + <entry><structfield>subenabled</structfield></entry>
  853. + <entry><type>bool</type></entry>
  854. + <entry></entry>
  855. + <entry>If true, the subscription is enabled and should be replicating.</entry>
  856. + </row>
  857. +
  858. + <row>
  859. + <entry><structfield>subsynccommit</structfield></entry>
  860. + <entry><type>text</type></entry>
  861. + <entry></entry>
  862. + <entry>
  863. + Contains the value of the <varname>synchronous_commit</varname>
  864. + setting for the subscription workers.
  865. + </entry>
  866. + </row>
  867. +
  868. + <row>
  869. + <entry><structfield>subconninfo</structfield></entry>
  870. + <entry><type>text</type></entry>
  871. + <entry></entry>
  872. + <entry>Connection string to the upstream database</entry>
  873. + </row>
  874. +
  875. + <row>
  876. + <entry><structfield>subslotname</structfield></entry>
  877. + <entry><type>name</type></entry>
  878. + <entry></entry>
  879. + <entry>Name of the replication slot in the upstream database. Also used
  880. + for local replication origin name.</entry>
  881. + </row>
  882. +
  883. + <row>
  884. + <entry><structfield>subpublications</structfield></entry>
  885. + <entry><type>text[]</type></entry>
  886. + <entry></entry>
  887. + <entry>Array of subscribed publication names. These reference the
  888. + publications on the publisher server. For more on publications
  889. + see <xref linkend="logical-replication-publication">.
  890. + </entry>
  891. + </row>
  892. + </tbody>
  893. + </tgroup>
  894. + </table>
  895. + </sect1>
  896. +
  897. + <sect1 id="catalog-pg-subscription-rel">
  898. + <title><structname>pg_subscription_rel</structname></title>
  899. +
  900. + <indexterm zone="catalog-pg-subscription-rel">
  901. + <primary>pg_subscription_rel</primary>
  902. + </indexterm>
  903. +
  904. + <para>
  905. + The catalog <structname>pg_subscription_rel</structname> contains the
  906. + state for each replicated relation in each subscription. This is a
  907. + many-to-many mapping.
  908. + </para>
  909. +
  910. + <para>
  911. + This catalog only contains tables known to the subscription after running
  912. + either <command>CREATE SUBSCRIPTION</command> or
  913. + <command>ALTER SUBSCRIPTION ... REFRESH</command>.
  914. + </para>
  915. +
  916. + <table>
  917. + <title><structname>pg_subscription_rel</structname> Columns</title>
  918. +
  919. + <tgroup cols="4">
  920. + <thead>
  921. + <row>
  922. + <entry>Name</entry>
  923. + <entry>Type</entry>
  924. + <entry>References</entry>
  925. + <entry>Description</entry>
  926. + </row>
  927. + </thead>
  928. +
  929. + <tbody>
  930. + <row>
  931. + <entry><structfield>srsubid</structfield></entry>
  932. + <entry><type>oid</type></entry>
  933. + <entry><literal><link linkend="catalog-pg-subscription"><structname>pg_subscription</structname></link>.oid</literal></entry>
  934. + <entry>Reference to subscription</entry>
  935. + </row>
  936. +
  937. + <row>
  938. + <entry><structfield>srrelid</structfield></entry>
  939. + <entry><type>oid</type></entry>
  940. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
  941. + <entry>Reference to relation</entry>
  942. + </row>
  943. +
  944. + <row>
  945. + <entry><structfield>srsubstate</structfield></entry>
  946. + <entry><type>char</type></entry>
  947. + <entry></entry>
  948. + <entry>
  949. + State code:
  950. + <literal>i</> = initialize,
  951. + <literal>d</> = data is being copied,
  952. + <literal>s</> = synchronized,
  953. + <literal>r</> = ready (normal replication)
  954. + </entry>
  955. + </row>
  956. +
  957. + <row>
  958. + <entry><structfield>srsublsn</structfield></entry>
  959. + <entry><type>pg_lsn</type></entry>
  960. + <entry></entry>
  961. + <entry>
  962. + End LSN for <literal>s</> and <literal>r</> states.
  963. + </entry>
  964. + </row>
  965. + </tbody>
  966. + </tgroup>
  967. + </table>
  968. + </sect1>
  969.  
  970. <sect1 id="catalog-pg-tablespace">
  971. <title><structname>pg_tablespace</structname></title>
  972. @@ -6231,6 +6966,22 @@
  973. representation) for the trigger's <literal>WHEN</> condition, or null
  974. if none</entry>
  975. </row>
  976. +
  977. + <row>
  978. + <entry><structfield>tgoldtable</structfield></entry>
  979. + <entry><type>name</type></entry>
  980. + <entry></entry>
  981. + <entry><literal>REFERENCING</> clause name for <literal>OLD TABLE</>,
  982. + or null if none</entry>
  983. + </row>
  984. +
  985. + <row>
  986. + <entry><structfield>tgnewtable</structfield></entry>
  987. + <entry><type>name</type></entry>
  988. + <entry></entry>
  989. + <entry><literal>REFERENCING</> clause name for <literal>NEW TABLE</>,
  990. + or null if none</entry>
  991. + </row>
  992. </tbody>
  993. </tgroup>
  994. </table>
  995. @@ -7324,6 +8075,11 @@
  996. </row>
  997.  
  998. <row>
  999. + <entry><link linkend="view-pg-hba-file-rules"><structname>pg_hba_file_rules</structname></link></entry>
  1000. + <entry>summary of client authentication configuration file contents</entry>
  1001. + </row>
  1002. +
  1003. + <row>
  1004. <entry><link linkend="view-pg-indexes"><structname>pg_indexes</structname></link></entry>
  1005. <entry>indexes</entry>
  1006. </row>
  1007. @@ -7354,6 +8110,11 @@
  1008. </row>
  1009.  
  1010. <row>
  1011. + <entry><link linkend="view-pg-publication-tables"><structname>pg_publication_tables</structname></link></entry>
  1012. + <entry>publications and their associated tables</entry>
  1013. + </row>
  1014. +
  1015. + <row>
  1016. <entry><link linkend="view-pg-replication-origin-status"><structname>pg_replication_origin_status</structname></link></entry>
  1017. <entry>information about replication origins, including replication progress</entry>
  1018. </row>
  1019. @@ -7379,6 +8140,11 @@
  1020. </row>
  1021.  
  1022. <row>
  1023. + <entry><link linkend="view-pg-sequences"><structname>pg_sequences</structname></link></entry>
  1024. + <entry>sequences</entry>
  1025. + </row>
  1026. +
  1027. + <row>
  1028. <entry><link linkend="view-pg-settings"><structname>pg_settings</structname></link></entry>
  1029. <entry>parameter settings</entry>
  1030. </row>
  1031. @@ -7913,6 +8679,114 @@
  1032.  
  1033. </sect1>
  1034.  
  1035. + <sect1 id="view-pg-hba-file-rules">
  1036. + <title><structname>pg_hba_file_rules</structname></title>
  1037. +
  1038. + <indexterm zone="view-pg-hba-file-rules">
  1039. + <primary>pg_hba_file_rules</primary>
  1040. + </indexterm>
  1041. +
  1042. + <para>
  1043. + The view <structname>pg_hba_file_rules</structname> provides a summary of
  1044. + the contents of the client authentication configuration
  1045. + file, <filename>pg_hba.conf</>. A row appears in this view for each
  1046. + non-empty, non-comment line in the file, with annotations indicating
  1047. + whether the rule could be applied successfully.
  1048. + </para>
  1049. +
  1050. + <para>
  1051. + This view can be helpful for checking whether planned changes in the
  1052. + authentication configuration file will work, or for diagnosing a previous
  1053. + failure. Note that this view reports on the <emphasis>current</> contents
  1054. + of the file, not on what was last loaded by the server.
  1055. + </para>
  1056. +
  1057. + <para>
  1058. + By default, the <structname>pg_hba_file_rules</structname> view can be read
  1059. + only by superusers.
  1060. + </para>
  1061. +
  1062. + <table>
  1063. + <title><structname>pg_hba_file_rules</> Columns</title>
  1064. +
  1065. + <tgroup cols="3">
  1066. + <thead>
  1067. + <row>
  1068. + <entry>Name</entry>
  1069. + <entry>Type</entry>
  1070. + <entry>Description</entry>
  1071. + </row>
  1072. + </thead>
  1073. + <tbody>
  1074. + <row>
  1075. + <entry><structfield>line_number</structfield></entry>
  1076. + <entry><structfield>integer</structfield></entry>
  1077. + <entry>
  1078. + Line number of this rule in <filename>pg_hba.conf</>
  1079. + </entry>
  1080. + </row>
  1081. + <row>
  1082. + <entry><structfield>type</structfield></entry>
  1083. + <entry><structfield>text</structfield></entry>
  1084. + <entry>Type of connection</entry>
  1085. + </row>
  1086. + <row>
  1087. + <entry><structfield>database</structfield></entry>
  1088. + <entry><structfield>text[]</structfield></entry>
  1089. + <entry>List of database name(s) to which this rule applies</entry>
  1090. + </row>
  1091. + <row>
  1092. + <entry><structfield>user_name</structfield></entry>
  1093. + <entry><structfield>text[]</structfield></entry>
  1094. + <entry>List of user and group name(s) to which this rule applies</entry>
  1095. + </row>
  1096. + <row>
  1097. + <entry><structfield>address</structfield></entry>
  1098. + <entry><structfield>text</structfield></entry>
  1099. + <entry>
  1100. + Host name or IP address, or one
  1101. + of <literal>all</literal>, <literal>samehost</literal>,
  1102. + or <literal>samenet</literal>, or null for local connections
  1103. + </entry>
  1104. + </row>
  1105. + <row>
  1106. + <entry><structfield>netmask</structfield></entry>
  1107. + <entry><structfield>text</structfield></entry>
  1108. + <entry>IP address mask, or null if not applicable</entry>
  1109. + </row>
  1110. + <row>
  1111. + <entry><structfield>auth_method</structfield></entry>
  1112. + <entry><type>text</type></entry>
  1113. + <entry>Authentication method</entry>
  1114. + </row>
  1115. + <row>
  1116. + <entry><structfield>options</structfield></entry>
  1117. + <entry><type>text[]</type></entry>
  1118. + <entry>Options specified for authentication method, if any</entry>
  1119. + </row>
  1120. + <row>
  1121. + <entry><structfield>error</structfield></entry>
  1122. + <entry><structfield>text</structfield></entry>
  1123. + <entry>
  1124. + If not null, an error message indicating why this
  1125. + line could not be processed
  1126. + </entry>
  1127. + </row>
  1128. + </tbody>
  1129. + </tgroup>
  1130. + </table>
  1131. +
  1132. + <para>
  1133. + Usually, a row reflecting an incorrect entry will have values for only
  1134. + the <structfield>line_number</> and <structfield>error</> fields.
  1135. + </para>
  1136. +
  1137. + <para>
  1138. + See <xref linkend="client-authentication"> for more information about
  1139. + client authentication configuration.
  1140. + </para>
  1141. + </sect1>
  1142. +
  1143. <sect1 id="view-pg-indexes">
  1144. <title><structname>pg_indexes</structname></title>
  1145.  
  1146. @@ -8417,6 +9291,12 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
  1147. <entry>Name of policy</entry>
  1148. </row>
  1149. <row>
  1150. + <entry><structfield>polpermissive</structfield></entry>
  1151. + <entry><type>text</type></entry>
  1152. + <entry></entry>
  1153. + <entry>Is the policy permissive or restrictive?</entry>
  1154. + </row>
  1155. + <row>
  1156. <entry><structfield>roles</structfield></entry>
  1157. <entry><type>name[]</type></entry>
  1158. <entry></entry>
  1159. @@ -8624,6 +9504,61 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
  1160.  
  1161. </sect1>
  1162.  
  1163. + <sect1 id="view-pg-publication-tables">
  1164. + <title><structname>pg_publication_tables</structname></title>
  1165. +
  1166. + <indexterm zone="view-pg-publication-tables">
  1167. + <primary>pg_publication_tables</primary>
  1168. + </indexterm>
  1169. +
  1170. + <para>
  1171. + The view <structname>pg_publication_tables</structname> provides
  1172. + information about the mapping between publications and the tables they
  1173. + contain. Unlike the underlying
  1174. + catalog <structname>pg_publication_rel</structname>, this view expands
  1175. + publications defined as <literal>FOR ALL TABLES</literal>, so for such
  1176. + publications there will be a row for each eligible table.
  1177. + </para>
  1178. +
  1179. + <table>
  1180. + <title><structname>pg_publication_tables</structname> Columns</title>
  1181. +
  1182. + <tgroup cols="4">
  1183. + <thead>
  1184. + <row>
  1185. + <entry>Name</entry>
  1186. + <entry>Type</entry>
  1187. + <entry>References</entry>
  1188. + <entry>Description</entry>
  1189. + </row>
  1190. + </thead>
  1191. +
  1192. + <tbody>
  1193. + <row>
  1194. + <entry><structfield>pubname</structfield></entry>
  1195. + <entry><type>name</type></entry>
  1196. + <entry><literal><link linkend="catalog-pg-publication"><structname>pg_publication</structname></link>.pubname</literal></entry>
  1197. + <entry>Name of publication</entry>
  1198. + </row>
  1199. +
  1200. + <row>
  1201. + <entry><structfield>schemaname</structfield></entry>
  1202. + <entry><type>name</type></entry>
  1203. + <entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.nspname</literal></entry>
  1204. + <entry>Name of schema containing table</entry>
  1205. + </row>
  1206. +
  1207. + <row>
  1208. + <entry><structfield>tablename</structfield></entry>
  1209. + <entry><type>name</type></entry>
  1210. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.relname</literal></entry>
  1211. + <entry>Name of table</entry>
  1212. + </row>
  1213. + </tbody>
  1214. + </tgroup>
  1215. + </table>
  1216. + </sect1>
  1217. +
  1218. <sect1 id="view-pg-replication-origin-status">
  1219. <title><structname>pg_replication_origin_status</structname></title>
  1220.  
  1221. @@ -8760,6 +9695,15 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
  1222. </row>
  1223.  
  1224. <row>
  1225. + <entry><structfield>temporary</structfield></entry>
  1226. + <entry><type>boolean</type></entry>
  1227. + <entry></entry>
  1228. + <entry>True if this is a temporary replication slot. Temporary slots are
  1229. + not saved to disk and are automatically dropped on error or when
  1230. + the session has finished.</entry>
  1231. + </row>
  1232. +
  1233. + <row>
  1234. <entry><structfield>active</structfield></entry>
  1235. <entry><type>boolean</type></entry>
  1236. <entry></entry>
  1237. @@ -9119,6 +10063,107 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
  1238. </table>
  1239. </sect1>
  1240.  
  1241. + <sect1 id="view-pg-sequences">
  1242. + <title><structname>pg_sequences</structname></title>
  1243. +
  1244. + <indexterm zone="view-pg-sequences">
  1245. + <primary>pg_sequences</primary>
  1246. + </indexterm>
  1247. +
  1248. + <para>
  1249. + The view <structname>pg_sequences</structname> provides access to
  1250. + useful information about each sequence in the database.
  1251. + </para>
  1252. +
  1253. + <table>
  1254. + <title><structname>pg_sequences</> Columns</title>
  1255. +
  1256. + <tgroup cols="4">
  1257. + <thead>
  1258. + <row>
  1259. + <entry>Name</entry>
  1260. + <entry>Type</entry>
  1261. + <entry>References</entry>
  1262. + <entry>Description</entry>
  1263. + </row>
  1264. + </thead>
  1265. + <tbody>
  1266. + <row>
  1267. + <entry><structfield>schemaname</structfield></entry>
  1268. + <entry><type>name</type></entry>
  1269. + <entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.nspname</literal></entry>
  1270. + <entry>Name of schema containing sequence</entry>
  1271. + </row>
  1272. + <row>
  1273. + <entry><structfield>sequencename</structfield></entry>
  1274. + <entry><type>name</type></entry>
  1275. + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.relname</literal></entry>
  1276. + <entry>Name of sequence</entry>
  1277. + </row>
  1278. + <row>
  1279. + <entry><structfield>sequenceowner</structfield></entry>
  1280. + <entry><type>name</type></entry>
  1281. + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.rolname</literal></entry>
  1282. + <entry>Name of sequence's owner</entry>
  1283. + </row>
  1284. + <row>
  1285. + <entry><structfield>data_type</structfield></entry>
  1286. + <entry><type>regtype</type></entry>
  1287. + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_type</structname></link>.oid</literal></entry>
  1288. + <entry>Data type of the sequence</entry>
  1289. + </row>
  1290. + <row>
  1291. + <entry><structfield>start_value</structfield></entry>
  1292. + <entry><type>bigint</type></entry>
  1293. + <entry></entry>
  1294. + <entry>Start value of the sequence</entry>
  1295. + </row>
  1296. + <row>
  1297. + <entry><structfield>min_value</structfield></entry>
  1298. + <entry><type>bigint</type></entry>
  1299. + <entry></entry>
  1300. + <entry>Minimum value of the sequence</entry>
  1301. + </row>
  1302. + <row>
  1303. + <entry><structfield>max_value</structfield></entry>
  1304. + <entry><type>bigint</type></entry>
  1305. + <entry></entry>
  1306. + <entry>Maximum value of the sequence</entry>
  1307. + </row>
  1308. + <row>
  1309. + <entry><structfield>increment_by</structfield></entry>
  1310. + <entry><type>bigint</type></entry>
  1311. + <entry></entry>
  1312. + <entry>Increment value of the sequence</entry>
  1313. + </row>
  1314. + <row>
  1315. + <entry><structfield>cycle</structfield></entry>
  1316. + <entry><type>boolean</type></entry>
  1317. + <entry></entry>
  1318. + <entry>Whether the sequence cycles</entry>
  1319. + </row>
  1320. + <row>
  1321. + <entry><structfield>cache_size</structfield></entry>
  1322. + <entry><type>bigint</type></entry>
  1323. + <entry></entry>
  1324. + <entry>Cache size of the sequence</entry>
  1325. + </row>
  1326. + <row>
  1327. + <entry><structfield>last_value</structfield></entry>
  1328. + <entry><type>bigint</type></entry>
  1329. + <entry></entry>
  1330. + <entry>The last sequence value written to disk. If caching is used,
  1331. + this value can be greater than the last value handed out from the
  1332. + sequence. Null if the sequence has not been read from yet. Also, if
  1333. + the current user does not have <literal>USAGE</literal>
  1334. + or <literal>SELECT</literal> privilege on the sequence, the value is
  1335. + null.</entry>
  1336. + </row>
  1337. + </tbody>
  1338. + </tgroup>
  1339. + </table>
  1340. + </sect1>
  1341. +
  1342. <sect1 id="view-pg-settings">
  1343. <title><structname>pg_settings</structname></title>
  1344.  
  1345. @@ -9230,15 +10275,17 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
  1346. <entry><type>text</type></entry>
  1347. <entry>Configuration file the current value was set in (null for
  1348. values set from sources other than configuration files, or when
  1349. - examined by a non-superuser);
  1350. - helpful when using <literal>include</> directives in configuration files</entry>
  1351. + examined by a user who is neither a superuser or a member of
  1352. + <literal>pg_read_all_settings</literal>); helpful when using
  1353. + <literal>include</> directives in configuration files</entry>
  1354. </row>
  1355. <row>
  1356. <entry><structfield>sourceline</structfield></entry>
  1357. <entry><type>integer</type></entry>
  1358. <entry>Line number within the configuration file the current value was
  1359. set at (null for values set from sources other than configuration files,
  1360. - or when examined by a non-superuser)
  1361. + or when examined by a user who is neither a superuser or a member of
  1362. + <literal>pg_read_all_settings</literal>).
  1363. </entry>
  1364. </row>
  1365. <row>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!