OTL 4.0, Examples for PostgreSQL / ODBC
The examples below work with PostgreSQL via ODBC. In general, all of
these examples should work with any PostgreSQL 7.0 and higher, when
ODBC is enabled in OTL by setting
#define OTL_ODBC, or #define OTL_ODBC_POSTGRESQL.
For more
examples, see the Generic ODBC
examples.
- Example 140 (Simple
Insert/Select/Update)
- Example 141 ("Incompatible
datatypes in stream operation" exception)
- Example 142 (otl_datetime
container and DATE/TIME/TIMESTAMP table columns)
- Example 143 (otl_long_string
container and a TEXT column)
- Example 144 (std::string and
STL-compliant stream iterators)
- Example 145
(otl_stream::describe_select() with a simple Select)
- Example 146 (otl_stream and NULLs)
- Example 214
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, PostgreSQL)
- Example 342
(otl_stream_read_iterator, "get by name" functions, PostgreSQL)
- Example 345
(Insert/Update/Select
with TEXT in stream mode and
otl_stream_read_iterator)
- Example 346
(Insert/Update/Select
with BYTEA in stream mode and
otl_stream_read_iterator)
- Example 347 (Strict numeric type
checking on SELECTs)
- Example 348 (Simple
Unicode Insert/Select and VARCHAR strings)
- Example 349 (Simple Unicode
Insert/Select with TEXT)
- Example 350 (Simple
Insert/Select/Update with a BOOL column)
- Example
361 (Unicode VARCHAR Insert/Select and #define OTL_UNICODE_CHAR_TYPE)
- Example
362 (Unicode VARCHAR Insert/Select and #define OTL_UNICODE_STRING_TYPE)
- Example
369 (Unicode TEXT Insert/Select and #define OTL_UNICODE_STRING_TYPE)
- Example 376
(Simple Insert/Select,
otl_connect::operator<<, <<=, >>)
- Example 383
(Insert/Update/Select, PostgreSQL TEXT in stream mode, and
std:strings)
- Example 393
(Insert/Update/Select
with PostgreSQL TEXT in stream mode, without
otl_lob_stream::set_len())
- Example 454 (Simple
Insert/Select
with BYTEA datatype)
- Example 465 (Simple
Insert/Select
with BYTEA datatype and otl_stream_read_iterator)
Prev NextContentsGo Home
Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.com, skuchin@gmail.com
.
Permission to use, copy, modify and redistribute this document
for any purpose is hereby granted without fee, provided that the above
copyright notice appear in all copies.