← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-foreign-table-options.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/infoschema-foreign-table-options.html
 
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
>foreign_table_options</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.1beta1 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="foreign_servers"
 
19
HREF="infoschema-foreign-servers.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="foreign_tables"
 
22
HREF="infoschema-foreign-tables.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="2011-04-27T21:20:33"></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.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="foreign_servers"
 
57
HREF="infoschema-foreign-servers.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="The Information Schema"
 
67
HREF="information-schema.html"
 
68
>Fast Backward</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="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="The Information Schema"
 
81
HREF="information-schema.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="foreign_tables"
 
90
HREF="infoschema-foreign-tables.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="SECT1"
 
101
><H1
 
102
CLASS="SECT1"
 
103
><A
 
104
NAME="INFOSCHEMA-FOREIGN-TABLE-OPTIONS"
 
105
>34.28. <TT
 
106
CLASS="LITERAL"
 
107
>foreign_table_options</TT
 
108
></A
 
109
></H1
 
110
><P
 
111
>   The view <TT
 
112
CLASS="LITERAL"
 
113
>foreign_table_options</TT
 
114
> contains all the
 
115
   options defined for foreign tables in the current database.  Only
 
116
   those foreign tables are shown that the current user has access to
 
117
   (by way of being the owner or having some privilege).
 
118
  </P
 
119
><DIV
 
120
CLASS="TABLE"
 
121
><A
 
122
NAME="AEN46526"
 
123
></A
 
124
><P
 
125
><B
 
126
>Table 34-26. <TT
 
127
CLASS="LITERAL"
 
128
>foreign_table_options</TT
 
129
> Columns</B
 
130
></P
 
131
><TABLE
 
132
BORDER="1"
 
133
CLASS="CALSTABLE"
 
134
><COL><COL><COL><THEAD
 
135
><TR
 
136
><TH
 
137
>Name</TH
 
138
><TH
 
139
>Data Type</TH
 
140
><TH
 
141
>Description</TH
 
142
></TR
 
143
></THEAD
 
144
><TBODY
 
145
><TR
 
146
><TD
 
147
><TT
 
148
CLASS="LITERAL"
 
149
>foreign_table_catalog</TT
 
150
></TD
 
151
><TD
 
152
><TT
 
153
CLASS="TYPE"
 
154
>sql_identifier</TT
 
155
></TD
 
156
><TD
 
157
>Name of the database that contains the foreign table (always the current database)</TD
 
158
></TR
 
159
><TR
 
160
><TD
 
161
><TT
 
162
CLASS="LITERAL"
 
163
>foreign_table_schema</TT
 
164
></TD
 
165
><TD
 
166
><TT
 
167
CLASS="TYPE"
 
168
>sql_identifier</TT
 
169
></TD
 
170
><TD
 
171
>Name of the schema that contains the foreign table</TD
 
172
></TR
 
173
><TR
 
174
><TD
 
175
><TT
 
176
CLASS="LITERAL"
 
177
>foreign_table_name</TT
 
178
></TD
 
179
><TD
 
180
><TT
 
181
CLASS="TYPE"
 
182
>sql_identifier</TT
 
183
></TD
 
184
><TD
 
185
>Name of the foreign table</TD
 
186
></TR
 
187
><TR
 
188
><TD
 
189
><TT
 
190
CLASS="LITERAL"
 
191
>foreign_server_catalog</TT
 
192
></TD
 
193
><TD
 
194
><TT
 
195
CLASS="TYPE"
 
196
>sql_identifier</TT
 
197
></TD
 
198
><TD
 
199
>Name of the database that the foreign server is defined in (always the current database)</TD
 
200
></TR
 
201
><TR
 
202
><TD
 
203
><TT
 
204
CLASS="LITERAL"
 
205
>foreign_server_name</TT
 
206
></TD
 
207
><TD
 
208
><TT
 
209
CLASS="TYPE"
 
210
>sql_identifier</TT
 
211
></TD
 
212
><TD
 
213
>Name of the foreign server</TD
 
214
></TR
 
215
><TR
 
216
><TD
 
217
><TT
 
218
CLASS="LITERAL"
 
219
>option_name</TT
 
220
></TD
 
221
><TD
 
222
><TT
 
223
CLASS="TYPE"
 
224
>sql_identifier</TT
 
225
></TD
 
226
><TD
 
227
>Name of an option</TD
 
228
></TR
 
229
><TR
 
230
><TD
 
231
><TT
 
232
CLASS="LITERAL"
 
233
>option_value</TT
 
234
></TD
 
235
><TD
 
236
><TT
 
237
CLASS="TYPE"
 
238
>character_data</TT
 
239
></TD
 
240
><TD
 
241
>Value of the option</TD
 
242
></TR
 
243
></TBODY
 
244
></TABLE
 
245
></DIV
 
246
></DIV
 
247
><DIV
 
248
CLASS="NAVFOOTER"
 
249
><HR
 
250
ALIGN="LEFT"
 
251
WIDTH="100%"><TABLE
 
252
SUMMARY="Footer navigation table"
 
253
WIDTH="100%"
 
254
BORDER="0"
 
255
CELLPADDING="0"
 
256
CELLSPACING="0"
 
257
><TR
 
258
><TD
 
259
WIDTH="33%"
 
260
ALIGN="left"
 
261
VALIGN="top"
 
262
><A
 
263
HREF="infoschema-foreign-servers.html"
 
264
ACCESSKEY="P"
 
265
>Prev</A
 
266
></TD
 
267
><TD
 
268
WIDTH="34%"
 
269
ALIGN="center"
 
270
VALIGN="top"
 
271
><A
 
272
HREF="index.html"
 
273
ACCESSKEY="H"
 
274
>Home</A
 
275
></TD
 
276
><TD
 
277
WIDTH="33%"
 
278
ALIGN="right"
 
279
VALIGN="top"
 
280
><A
 
281
HREF="infoschema-foreign-tables.html"
 
282
ACCESSKEY="N"
 
283
>Next</A
 
284
></TD
 
285
></TR
 
286
><TR
 
287
><TD
 
288
WIDTH="33%"
 
289
ALIGN="left"
 
290
VALIGN="top"
 
291
><TT
 
292
CLASS="LITERAL"
 
293
>foreign_servers</TT
 
294
></TD
 
295
><TD
 
296
WIDTH="34%"
 
297
ALIGN="center"
 
298
VALIGN="top"
 
299
><A
 
300
HREF="information-schema.html"
 
301
ACCESSKEY="U"
 
302
>Up</A
 
303
></TD
 
304
><TD
 
305
WIDTH="33%"
 
306
ALIGN="right"
 
307
VALIGN="top"
 
308
><TT
 
309
CLASS="LITERAL"
 
310
>foreign_tables</TT
 
311
></TD
 
312
></TR
 
313
></TABLE
 
314
></DIV
 
315
></BODY
 
316
></HTML
 
317
>
 
 
b'\\ No newline at end of file'