6
6
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2">
7
7
<link rel="start" href="index.html" title="GNOME Data Access 4.0 manual">
8
8
<link rel="up" href="libgda-provider-class.html" title="Virtual methods for providers">
9
<link rel="prev" href="ch34s08.html" title="Methods - data representation">
10
<link rel="next" href="ch34s10.html" title="Methods - misc.">
11
<meta name="generator" content="GTK-Doc V1.10 (XML mode)">
9
<link rel="prev" href="ch35s08.html" title="Methods - data representation">
10
<link rel="next" href="ch35s10.html" title="Methods - misc.">
11
<meta name="generator" content="GTK-Doc V1.11 (XML mode)">
12
12
<link rel="stylesheet" href="style.css" type="text/css">
13
13
<link rel="part" href="part_begin.html" title="Part I. Getting started">
14
14
<link rel="chapter" href="introduction.html" title="Introduction">
20
20
<link rel="chapter" href="migration-2.html" title="Migration from 3.X versions">
21
21
<link rel="chapter" href="limitations.html" title="Limitations">
22
22
<link rel="part" href="part_libgda_api.html" title="Part II. Client API reference">
23
<link rel="chapter" href="ch09.html" title="Foreword about abstraction">
23
24
<link rel="chapter" href="howto.html" title="HOWTO for common tasks">
24
<link rel="chapter" href="ch10.html" title="Object Hierarchy">
25
<link rel="chapter" href="ch11.html" title="Object Hierarchy">
25
26
<link rel="chapter" href="init_config.html" title="Initialization and configuration">
26
27
<link rel="chapter" href="connection.html" title="Connections & commands">
27
28
<link rel="chapter" href="virtual_connection.html" title="Virtual connections">
28
29
<link rel="chapter" href="data_models.html" title="Data handling">
29
30
<link rel="chapter" href="data_conv.html" title="Data conversions">
30
31
<link rel="chapter" href="gda-dict.html" title="Dictionary - metadata">
31
<link rel="chapter" href="ch17.html" title="Data definition (DDL) queries">
32
<link rel="chapter" href="ch18.html" title="Data definition (DDL) queries">
32
33
<link rel="chapter" href="misc.html" title="Miscellaneous">
33
34
<link rel="part" href="part_tools.html" title="Part III. GDA Tools">
34
35
<link rel="chapter" href="libgda-tools-introduction.html" title="Introduction">
38
39
<link rel="chapter" href="libgda-list-server-op.html" title="gda-list-server-op-4.0">
39
40
<link rel="part" href="part_libgda-reports.html" title="Part IV. Reports">
40
41
<link rel="chapter" href="libgda-reports-introduction.html" title="Introduction">
41
<link rel="chapter" href="ch25.html" title="API reference">
42
<link rel="chapter" href="ch26.html" title="API reference">
42
43
<link rel="part" href="part_libgda-xslt.html" title="Part V. XSLT extension">
43
44
<link rel="chapter" href="libgda-xslt-introduction.html" title="Introduction">
44
45
<link rel="chapter" href="libgda-xslt-api.html" title="API reference">
45
<link rel="chapter" href="ch28.html" title="Example">
46
<link rel="chapter" href="ch29.html" title="Example">
46
47
<link rel="part" href="gda-sql.html" title="Part VI. Gda SQL console's user manual">
47
48
<link rel="chapter" href="gda-sql-manual-run.html" title="Getting started">
48
49
<link rel="chapter" href="gda-sql-manual-dsn.html" title="DSN management">
55
56
<link rel="chapter" href="libgda-provider-blobop.html" title="Virtual methods for Blob operations">
56
57
<link rel="chapter" href="libgda-provider-parser.html" title="SQL parser">
57
58
<link rel="chapter" href="libgda-provider-pack.html" title="Assembling all the parts">
58
<link rel="part" href="part_index.html" title="Part VIII. Appendix">
59
<link rel="part" href="pt08.html" title="Part VIII. Packaging">
60
<link rel="chapter" href="libgda-packaging.html" title="Packaging Libgda">
61
<link rel="part" href="part_index.html" title="Part IX. Appendix">
59
62
<link rel="appendix" href="fdl.html" title="Appendix A. GNU Free Documentation License">
60
63
<link rel="index" href="ix01.html" title="Index">
62
65
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
63
66
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="2"><tr valign="middle">
64
<td><a accesskey="p" href="ch34s08.html"><img src="left.png" width="24" height="24" border="0" alt="Prev"></a></td>
67
<td><a accesskey="p" href="ch35s08.html"><img src="left.png" width="24" height="24" border="0" alt="Prev"></a></td>
65
68
<td><a accesskey="u" href="libgda-provider-class.html"><img src="up.png" width="24" height="24" border="0" alt="Up"></a></td>
66
69
<td><a accesskey="h" href="index.html"><img src="home.png" width="24" height="24" border="0" alt="Home"></a></td>
67
70
<th width="100%" align="center">GNOME Data Access 4.0 manual</th>
68
<td><a accesskey="n" href="ch34s10.html"><img src="right.png" width="24" height="24" border="0" alt="Next"></a></td>
71
<td><a accesskey="n" href="ch35s10.html"><img src="right.png" width="24" height="24" border="0" alt="Next"></a></td>
70
73
<div class="sect1" lang="en">
71
74
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
116
119
<div class="sect2" lang="en">
117
120
<div class="titlepage"><div><div><h3 class="title">
118
<a name="id2927290"></a>_info()</h3></div></div></div>
121
<a name="id3083502"></a>Important note about SQL identifiers</h3></div></div></div>
123
As mentionned in the <a class="link" href="information_schema.html#information_schema:sql_identifiers" title="SQL identifiers">SQL identifiers</a> section,
124
any SQL identifier in the meta store is represented either:
126
<div class="itemizedlist"><ul type="disc">
127
<li><p>between double quotes if the SQL identifier is case sensitive</p></li>
128
<li><p>all in lower case if the SQL identifier is not case sensitive</p></li>
133
For database engines which internally store case insensitive SQL identifiers in lower case
134
(such as PostgreSQL),
135
the meta data reported by the database engine can be used almost AS IS, but for database
136
engines which internally store case insensitive SQL identifiers in upper case (such as Oracle),
137
the upper case needs to be converted to lower case. Also case sensitive SQL identifiers also need
141
<div class="sect2" lang="en">
142
<div class="titlepage"><div><div><h3 class="title">
143
<a name="id3083547"></a>_info()</h3></div></div></div>
121
146
<pre class="programlisting">
132
157
<div class="sect2" lang="en">
133
158
<div class="titlepage"><div><div><h3 class="title">
134
<a name="id2927318"></a>_btypes()</h3></div></div></div>
159
<a name="id3083574"></a>_btypes()</h3></div></div></div>
137
162
<pre class="programlisting">
147
172
<div class="sect2" lang="en">
148
173
<div class="titlepage"><div><div><h3 class="title">
149
<a name="id2927346"></a>schemata() and _schemata()</h3></div></div></div>
174
<a name="id3083602"></a>schemata() and _schemata()</h3></div></div></div>
152
177
<pre class="programlisting">
164
189
<div class="sect2" lang="en">
165
190
<div class="titlepage"><div><div><h3 class="title">
166
<a name="id2927377"></a>tables_views() and _tables_views()</h3></div></div></div>
191
<a name="id3083028"></a>tables_views() and _tables_views()</h3></div></div></div>
169
194
<pre class="programlisting">
183
208
<div class="sect2" lang="en">
184
209
<div class="titlepage"><div><div><h3 class="title">
185
<a name="id2927415"></a>columns() and _columns()</h3></div></div></div>
210
<a name="id3083066"></a>columns() and _columns()</h3></div></div></div>
188
213
<pre class="programlisting">
201
226
<div class="sect2" lang="en">
202
227
<div class="titlepage"><div><div><h3 class="title">
203
<a name="id2927446"></a>constraints_tab() and _constraints_tab()</h3></div></div></div>
228
<a name="id3083097"></a>constraints_tab() and _constraints_tab()</h3></div></div></div>
206
231
<pre class="programlisting">
220
245
<div class="sect2" lang="en">
221
246
<div class="titlepage"><div><div><h3 class="title">
222
<a name="id2927481"></a>constraints_ref() and _constraints_ref()</h3></div></div></div>
247
<a name="id3083132"></a>constraints_ref() and _constraints_ref()</h3></div></div></div>
225
250
<pre class="programlisting">
240
265
<div class="sect2" lang="en">
241
266
<div class="titlepage"><div><div><h3 class="title">
242
<a name="id2927524"></a>key_columns() and _key_columns()</h3></div></div></div>
267
<a name="id3083175"></a>key_columns() and _key_columns()</h3></div></div></div>
245
270
<pre class="programlisting">