Installation guide

Contents
.setinputsizes(sizes) ................................................................ 113
.setoutputsize(size[, column]) ................................................. 113
.__iter__()................................................................................ 113
.__enter__()............................................................................. 113
.__exit__(exc_type, exc_value, exc_tb) .................................... 113
7.6.1 Catalog Methods ............................................................................... 113
Common Interface ....................................................................... 114
Result Set Layouts ........................................................................ 114
Search Pattern Parameters............................................................ 114
Case-sensitivity of Search Patterns .......................................... 114
Switching between Search Patterns and Identifier Matching.... 115
Unicode ....................................................................................... 115
Available Catalog Methods ........................................................... 115
.columns(qualifier=None, owner=None, table=None,
column=None)....................................................................... 115
.columnprivileges(qualifier=None, owner=None, table=None,
column=None)....................................................................... 118
.foreignkeys(primary_qualifier=None, primary_owner=None,
pimary_table=None, foreign_qualifier=None,
foreign_owner=None, foreign_table=None) .......................... 119
primary_table.......................................................................... 119
foreign_table ........................................................................... 119
.gettypeinfo(sqltype) ............................................................... 120
.primarykeys(qualifier=None, owner=None, table=None)..... 123
.procedures(qualifier=None, owner=None, procedure=None)124
.procedurecolumns(qualifier=None, owner=None,
procedure=None, column=None).......................................... 125
.specialcolumns(qualifier=None, owner=None, table=None,
coltype=SQL.BEST_ROWID, scope=SQL.SCOPE_SESSION,
nullable=SQL.NO_NULLS) ..................................................... 128
SQL_BEST_ROWID ................................................................. 128
SQL_ROWVER ........................................................................ 128
SQL.SCOPE_CURROW ........................................................... 128
SQL.SCOPE_TRANSACTION ................................................... 128
SQL.SCOPE_SESSION............................................................. 128
SQL.NO_NULLS...................................................................... 128
SQL.NULLABLE ....................................................................... 128
.statistics(qualifier=None, owner=None, table=None,
unique=SQL.INDEX_ALL, accuracy=SQL.QUICK).................. 130
SQL.INDEX_UNIQUE.............................................................. 130
SQL.INDEX_ALL ...................................................................... 130
SQL.ENSURE........................................................................... 130
SQL.QUICK............................................................................. 130
.tables(qualifier=None, owner=None, table=None, type=None)132
.tableprivileges(qualifier=None, owner=None, table=None) . 133