~ubuntu-branches/debian/sid/postgresql-9.3/sid

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-user-mappings.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2013-05-08 05:39:52 UTC
  • Revision ID: package-import@ubuntu.com-20130508053952-1j7uilp7mjtrvq8q
Tags: upstream-9.3~beta1
ImportĀ upstreamĀ versionĀ 9.3~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>user_mappings</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.3beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="The Information Schema"
 
16
HREF="information-schema.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="user_mapping_options"
 
19
HREF="infoschema-user-mapping-options.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="view_column_usage"
 
22
HREF="infoschema-view-column-usage.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2013-05-06T21:00:50"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.3beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="user_mapping_options"
 
57
HREF="infoschema-user-mapping-options.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
HREF="information-schema.html"
 
67
ACCESSKEY="U"
 
68
>Up</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 34. The Information Schema</TD
 
75
><TD
 
76
WIDTH="20%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="view_column_usage"
 
81
HREF="infoschema-view-column-usage.html"
 
82
ACCESSKEY="N"
 
83
>Next</A
 
84
></TD
 
85
></TR
 
86
></TABLE
 
87
><HR
 
88
ALIGN="LEFT"
 
89
WIDTH="100%"></DIV
 
90
><DIV
 
91
CLASS="SECT1"
 
92
><H1
 
93
CLASS="SECT1"
 
94
><A
 
95
NAME="INFOSCHEMA-USER-MAPPINGS"
 
96
>34.59. <TT
 
97
CLASS="LITERAL"
 
98
>user_mappings</TT
 
99
></A
 
100
></H1
 
101
><P
 
102
>   The view <TT
 
103
CLASS="LITERAL"
 
104
>user_mappings</TT
 
105
> contains all user
 
106
   mappings defined in the current database.  Only those user mappings
 
107
   are shown where the current user has access to the corresponding
 
108
   foreign server (by way of being the owner or having some
 
109
   privilege).
 
110
  </P
 
111
><DIV
 
112
CLASS="TABLE"
 
113
><A
 
114
NAME="AEN52124"
 
115
></A
 
116
><P
 
117
><B
 
118
>Table 34-57. <TT
 
119
CLASS="LITERAL"
 
120
>user_mappings</TT
 
121
> Columns</B
 
122
></P
 
123
><TABLE
 
124
BORDER="1"
 
125
CLASS="CALSTABLE"
 
126
><COL><COL><COL><THEAD
 
127
><TR
 
128
><TH
 
129
>Name</TH
 
130
><TH
 
131
>Data Type</TH
 
132
><TH
 
133
>Description</TH
 
134
></TR
 
135
></THEAD
 
136
><TBODY
 
137
><TR
 
138
><TD
 
139
><TT
 
140
CLASS="LITERAL"
 
141
>authorization_identifier</TT
 
142
></TD
 
143
><TD
 
144
><TT
 
145
CLASS="TYPE"
 
146
>sql_identifier</TT
 
147
></TD
 
148
><TD
 
149
>Name of the user being mapped,
 
150
      or <TT
 
151
CLASS="LITERAL"
 
152
>PUBLIC</TT
 
153
> if the mapping is public</TD
 
154
></TR
 
155
><TR
 
156
><TD
 
157
><TT
 
158
CLASS="LITERAL"
 
159
>foreign_server_catalog</TT
 
160
></TD
 
161
><TD
 
162
><TT
 
163
CLASS="TYPE"
 
164
>sql_identifier</TT
 
165
></TD
 
166
><TD
 
167
>Name of the database that the foreign server used by this
 
168
      mapping is defined in (always the current database)</TD
 
169
></TR
 
170
><TR
 
171
><TD
 
172
><TT
 
173
CLASS="LITERAL"
 
174
>foreign_server_name</TT
 
175
></TD
 
176
><TD
 
177
><TT
 
178
CLASS="TYPE"
 
179
>sql_identifier</TT
 
180
></TD
 
181
><TD
 
182
>Name of the foreign server used by this mapping</TD
 
183
></TR
 
184
></TBODY
 
185
></TABLE
 
186
></DIV
 
187
></DIV
 
188
><DIV
 
189
CLASS="NAVFOOTER"
 
190
><HR
 
191
ALIGN="LEFT"
 
192
WIDTH="100%"><TABLE
 
193
SUMMARY="Footer navigation table"
 
194
WIDTH="100%"
 
195
BORDER="0"
 
196
CELLPADDING="0"
 
197
CELLSPACING="0"
 
198
><TR
 
199
><TD
 
200
WIDTH="33%"
 
201
ALIGN="left"
 
202
VALIGN="top"
 
203
><A
 
204
HREF="infoschema-user-mapping-options.html"
 
205
ACCESSKEY="P"
 
206
>Prev</A
 
207
></TD
 
208
><TD
 
209
WIDTH="34%"
 
210
ALIGN="center"
 
211
VALIGN="top"
 
212
><A
 
213
HREF="index.html"
 
214
ACCESSKEY="H"
 
215
>Home</A
 
216
></TD
 
217
><TD
 
218
WIDTH="33%"
 
219
ALIGN="right"
 
220
VALIGN="top"
 
221
><A
 
222
HREF="infoschema-view-column-usage.html"
 
223
ACCESSKEY="N"
 
224
>Next</A
 
225
></TD
 
226
></TR
 
227
><TR
 
228
><TD
 
229
WIDTH="33%"
 
230
ALIGN="left"
 
231
VALIGN="top"
 
232
><TT
 
233
CLASS="LITERAL"
 
234
>user_mapping_options</TT
 
235
></TD
 
236
><TD
 
237
WIDTH="34%"
 
238
ALIGN="center"
 
239
VALIGN="top"
 
240
><A
 
241
HREF="information-schema.html"
 
242
ACCESSKEY="U"
 
243
>Up</A
 
244
></TD
 
245
><TD
 
246
WIDTH="33%"
 
247
ALIGN="right"
 
248
VALIGN="top"
 
249
><TT
 
250
CLASS="LITERAL"
 
251
>view_column_usage</TT
 
252
></TD
 
253
></TR
 
254
></TABLE
 
255
></DIV
 
256
></BODY
 
257
></HTML
 
258
>
 
 
b'\\ No newline at end of file'