|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.192 2009/01/27 12:40:14 petere Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.193 2009/02/02 09:49:29 petere Exp $ --> |
2 | 2 | <!-- |
3 | 3 | Documentation of the system catalogs, directed toward PostgreSQL developers |
4 | 4 | --> |
|
2764 | 2764 | </sect1> |
2765 | 2765 |
|
2766 | 2766 |
|
2767 | | - <sect1 id="catalog-pg-user-mapping"> |
2768 | | - <title><structname>pg_user_mapping</structname></title> |
2769 | | - |
2770 | | - <indexterm zone="catalog-pg-user-mapping"> |
2771 | | - <primary>pg_user_mapping</primary> |
2772 | | - </indexterm> |
2773 | | - |
2774 | | - <para> |
2775 | | - The catalog <structname>pg_user_mapping</structname> stores |
2776 | | - the mappings from local user to remote. Access to this catalog is |
2777 | | - restricted from normal users, use the view |
2778 | | - <link linkend="view-pg-user-mappings"><structname>pg_user_mappings</structname></link> |
2779 | | - instead. |
2780 | | - </para> |
2781 | | - |
2782 | | - <table> |
2783 | | - <title><structname>pg_user_mapping</> Columns</title> |
2784 | | - |
2785 | | - <tgroup cols=4> |
2786 | | - <thead> |
2787 | | - <row> |
2788 | | - <entry>Name</entry> |
2789 | | - <entry>Type</entry> |
2790 | | - <entry>References</entry> |
2791 | | - <entry>Description</entry> |
2792 | | - </row> |
2793 | | - </thead> |
2794 | | - |
2795 | | - <tbody> |
2796 | | - <row> |
2797 | | - <entry><structfield>umuser</structfield></entry> |
2798 | | - <entry><type>oid</type></entry> |
2799 | | - <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry> |
2800 | | - <entry>OID of the local role being mapped, 0 if the user mapping is public</entry> |
2801 | | - </row> |
2802 | | - |
2803 | | - <row> |
2804 | | - <entry><structfield>umserver</structfield></entry> |
2805 | | - <entry><type>oid</type></entry> |
2806 | | - <entry><literal><link linkend="catalog-pg-foreign-server"><structname>pg_foreign_server</structname></link>.oid</literal></entry> |
2807 | | - <entry> |
2808 | | - The OID of the foreign server that contains this mapping |
2809 | | - </entry> |
2810 | | - </row> |
2811 | | - |
2812 | | - <row> |
2813 | | - <entry><structfield>umoptions</structfield></entry> |
2814 | | - <entry><type>text[]</type></entry> |
2815 | | - <entry></entry> |
2816 | | - <entry> |
2817 | | - User mapping specific options, as <quote>keyword=value</> strings. |
2818 | | - </entry> |
2819 | | - </row> |
2820 | | - </tbody> |
2821 | | - </tgroup> |
2822 | | - </table> |
2823 | | - </sect1> |
2824 | | - |
2825 | | - |
2826 | 2767 | <sect1 id="catalog-pg-index"> |
2827 | 2768 | <title><structname>pg_index</structname></title> |
2828 | 2769 |
|
|
5648 | 5589 |
|
5649 | 5590 | </sect1> |
5650 | 5591 |
|
| 5592 | + |
| 5593 | + <sect1 id="catalog-pg-user-mapping"> |
| 5594 | + <title><structname>pg_user_mapping</structname></title> |
| 5595 | + |
| 5596 | + <indexterm zone="catalog-pg-user-mapping"> |
| 5597 | + <primary>pg_user_mapping</primary> |
| 5598 | + </indexterm> |
| 5599 | + |
| 5600 | + <para> |
| 5601 | + The catalog <structname>pg_user_mapping</structname> stores |
| 5602 | + the mappings from local user to remote. Access to this catalog is |
| 5603 | + restricted from normal users, use the view |
| 5604 | + <link linkend="view-pg-user-mappings"><structname>pg_user_mappings</structname></link> |
| 5605 | + instead. |
| 5606 | + </para> |
| 5607 | + |
| 5608 | + <table> |
| 5609 | + <title><structname>pg_user_mapping</> Columns</title> |
| 5610 | + |
| 5611 | + <tgroup cols=4> |
| 5612 | + <thead> |
| 5613 | + <row> |
| 5614 | + <entry>Name</entry> |
| 5615 | + <entry>Type</entry> |
| 5616 | + <entry>References</entry> |
| 5617 | + <entry>Description</entry> |
| 5618 | + </row> |
| 5619 | + </thead> |
| 5620 | + |
| 5621 | + <tbody> |
| 5622 | + <row> |
| 5623 | + <entry><structfield>umuser</structfield></entry> |
| 5624 | + <entry><type>oid</type></entry> |
| 5625 | + <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry> |
| 5626 | + <entry>OID of the local role being mapped, 0 if the user mapping is public</entry> |
| 5627 | + </row> |
| 5628 | + |
| 5629 | + <row> |
| 5630 | + <entry><structfield>umserver</structfield></entry> |
| 5631 | + <entry><type>oid</type></entry> |
| 5632 | + <entry><literal><link linkend="catalog-pg-foreign-server"><structname>pg_foreign_server</structname></link>.oid</literal></entry> |
| 5633 | + <entry> |
| 5634 | + The OID of the foreign server that contains this mapping |
| 5635 | + </entry> |
| 5636 | + </row> |
| 5637 | + |
| 5638 | + <row> |
| 5639 | + <entry><structfield>umoptions</structfield></entry> |
| 5640 | + <entry><type>text[]</type></entry> |
| 5641 | + <entry></entry> |
| 5642 | + <entry> |
| 5643 | + User mapping specific options, as <quote>keyword=value</> strings. |
| 5644 | + </entry> |
| 5645 | + </row> |
| 5646 | + </tbody> |
| 5647 | + </tgroup> |
| 5648 | + </table> |
| 5649 | + </sect1> |
| 5650 | + |
| 5651 | + |
5651 | 5652 | <sect1 id="views-overview"> |
5652 | 5653 | <title>System Views</title> |
5653 | 5654 |
|
|