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

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-collation-character-set-applicability.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-06-14 09:53:29 UTC
  • mto: (6.1.1 sid) (10.1.1 oneiric-proposed) (1.2.1)
  • mto: This revision was merged to the branch mainline in revision 5.
  • Revision ID: james.westby@ubuntu.com-20110614095329-71gfhjywyp2c27au
Tags: upstream-9.1~beta2
ImportĀ upstreamĀ versionĀ 9.1~beta2

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
 
>collation_character_set_applicability</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="collations"
19
 
HREF="infoschema-collations.html"><LINK
20
 
REL="NEXT"
21
 
TITLE="column_domain_usage"
22
 
HREF="infoschema-column-domain-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="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="collations"
57
 
HREF="infoschema-collations.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="column_domain_usage"
90
 
HREF="infoschema-column-domain-usage.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-COLLATION-CHARACTER-SET-APPLICABILITY"
105
 
>34.11. <TT
106
 
CLASS="LITERAL"
107
 
>collation_character_set_applicability</TT
108
 
></A
109
 
></H1
110
 
><P
111
 
>   The view <TT
112
 
CLASS="LITERAL"
113
 
>collation_character_set_applicability</TT
114
 
>
115
 
   identifies which character set the available collations are
116
 
   applicable to.  In PostgreSQL, there is only one character set per
117
 
   database (see explanation
118
 
   in <A
119
 
HREF="infoschema-character-sets.html"
120
 
>Section 34.7</A
121
 
>), so this view does
122
 
   not provide much useful information.
123
 
  </P
124
 
><DIV
125
 
CLASS="TABLE"
126
 
><A
127
 
NAME="AEN45062"
128
 
></A
129
 
><P
130
 
><B
131
 
>Table 34-9. <TT
132
 
CLASS="LITERAL"
133
 
>collation_character_set_applicability</TT
134
 
> Columns</B
135
 
></P
136
 
><TABLE
137
 
BORDER="1"
138
 
CLASS="CALSTABLE"
139
 
><COL><COL><COL><THEAD
140
 
><TR
141
 
><TH
142
 
>Name</TH
143
 
><TH
144
 
>Data Type</TH
145
 
><TH
146
 
>Description</TH
147
 
></TR
148
 
></THEAD
149
 
><TBODY
150
 
><TR
151
 
><TD
152
 
><TT
153
 
CLASS="LITERAL"
154
 
>collation_catalog</TT
155
 
></TD
156
 
><TD
157
 
><TT
158
 
CLASS="LITERAL"
159
 
>sql_identifier</TT
160
 
></TD
161
 
><TD
162
 
>Name of the database containing the collation (always the current database)</TD
163
 
></TR
164
 
><TR
165
 
><TD
166
 
><TT
167
 
CLASS="LITERAL"
168
 
>collation_schema</TT
169
 
></TD
170
 
><TD
171
 
><TT
172
 
CLASS="LITERAL"
173
 
>sql_identifier</TT
174
 
></TD
175
 
><TD
176
 
>Name of the schema containing the collation</TD
177
 
></TR
178
 
><TR
179
 
><TD
180
 
><TT
181
 
CLASS="LITERAL"
182
 
>collation_name</TT
183
 
></TD
184
 
><TD
185
 
><TT
186
 
CLASS="LITERAL"
187
 
>sql_identifier</TT
188
 
></TD
189
 
><TD
190
 
>Name of the default collation</TD
191
 
></TR
192
 
><TR
193
 
><TD
194
 
><TT
195
 
CLASS="LITERAL"
196
 
>character_set_catalog</TT
197
 
></TD
198
 
><TD
199
 
><TT
200
 
CLASS="LITERAL"
201
 
>sql_identifier</TT
202
 
></TD
203
 
><TD
204
 
>Character sets are currently not implemented as schema objects, so this column is null</TD
205
 
></TR
206
 
><TR
207
 
><TD
208
 
><TT
209
 
CLASS="LITERAL"
210
 
>character_set_schema</TT
211
 
></TD
212
 
><TD
213
 
><TT
214
 
CLASS="LITERAL"
215
 
>sql_identifier</TT
216
 
></TD
217
 
><TD
218
 
>Character sets are currently not implemented as schema objects, so this column is null</TD
219
 
></TR
220
 
><TR
221
 
><TD
222
 
><TT
223
 
CLASS="LITERAL"
224
 
>character_set_name</TT
225
 
></TD
226
 
><TD
227
 
><TT
228
 
CLASS="LITERAL"
229
 
>sql_identifier</TT
230
 
></TD
231
 
><TD
232
 
>Name of the character set</TD
233
 
></TR
234
 
></TBODY
235
 
></TABLE
236
 
></DIV
237
 
></DIV
238
 
><DIV
239
 
CLASS="NAVFOOTER"
240
 
><HR
241
 
ALIGN="LEFT"
242
 
WIDTH="100%"><TABLE
243
 
SUMMARY="Footer navigation table"
244
 
WIDTH="100%"
245
 
BORDER="0"
246
 
CELLPADDING="0"
247
 
CELLSPACING="0"
248
 
><TR
249
 
><TD
250
 
WIDTH="33%"
251
 
ALIGN="left"
252
 
VALIGN="top"
253
 
><A
254
 
HREF="infoschema-collations.html"
255
 
ACCESSKEY="P"
256
 
>Prev</A
257
 
></TD
258
 
><TD
259
 
WIDTH="34%"
260
 
ALIGN="center"
261
 
VALIGN="top"
262
 
><A
263
 
HREF="index.html"
264
 
ACCESSKEY="H"
265
 
>Home</A
266
 
></TD
267
 
><TD
268
 
WIDTH="33%"
269
 
ALIGN="right"
270
 
VALIGN="top"
271
 
><A
272
 
HREF="infoschema-column-domain-usage.html"
273
 
ACCESSKEY="N"
274
 
>Next</A
275
 
></TD
276
 
></TR
277
 
><TR
278
 
><TD
279
 
WIDTH="33%"
280
 
ALIGN="left"
281
 
VALIGN="top"
282
 
><TT
283
 
CLASS="LITERAL"
284
 
>collations</TT
285
 
></TD
286
 
><TD
287
 
WIDTH="34%"
288
 
ALIGN="center"
289
 
VALIGN="top"
290
 
><A
291
 
HREF="information-schema.html"
292
 
ACCESSKEY="U"
293
 
>Up</A
294
 
></TD
295
 
><TD
296
 
WIDTH="33%"
297
 
ALIGN="right"
298
 
VALIGN="top"
299
 
><TT
300
 
CLASS="LITERAL"
301
 
>column_domain_usage</TT
302
 
></TD
303
 
></TR
304
 
></TABLE
305
 
></DIV
306
 
></BODY
307
 
></HTML
308
 
>
 
 
b'\\ No newline at end of file'