<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>Wt: Wt::Dbo::backend::Postgres Class Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="doxygen.css" rel="stylesheet" type="text/css" /> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="search/search.js"></script> <script type="text/javascript"> $(document).ready(function() { searchBox.OnSelectItem(0); }); </script> </head> <body> <div id="top"><!-- do not remove this div! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td style="padding-left: 0.5em;"> <div id="projectname">Wt  <span id="projectnumber">3.2.3</span> </div> </td> </tr> </tbody> </table> </div> <!-- Generated by Doxygen 1.7.5.1 --> <script type="text/javascript"> var searchBox = new SearchBox("searchBox", "search",false,'Search'); </script> <div id="navrow1" class="tabs"> <ul class="tablist"> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li class="current"><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li> <div id="MSearchBox" class="MSearchBoxInactive"> <span class="left"> <img id="MSearchSelect" src="search/mag_sel.png" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" alt=""/> <input type="text" id="MSearchField" value="Search" accesskey="S" onfocus="searchBox.OnSearchFieldFocus(true)" onblur="searchBox.OnSearchFieldFocus(false)" onkeyup="searchBox.OnSearchFieldChange(event)"/> </span><span class="right"> <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> </span> </div> </li> </ul> </div> <div id="navrow2" class="tabs2"> <ul class="tablist"> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="inherits.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> <div id="nav-path" class="navpath"> <ul> <li class="navelem"><a class="el" href="namespaceWt.html">Wt</a> </li> <li class="navelem"><a class="el" href="namespaceWt_1_1Dbo.html">Dbo</a> </li> <li class="navelem"><b>backend</b> </li> <li class="navelem"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html">Postgres</a> </li> </ul> </div> </div> <div class="header"> <div class="summary"> <a href="#pub-methods">Public Member Functions</a> </div> <div class="headertitle"> <div class="title">Wt::Dbo::backend::Postgres Class Reference<div class="ingroups"><a class="el" href="group__dbo.html">Database Objects (Wt::Dbo)</a></div></div> </div> </div> <div class="contents"> <!-- doxytag: class="Wt::Dbo::backend::Postgres" --><!-- doxytag: inherits="Wt::Dbo::SqlConnection" --> <p>A PostgreSQL connection. <a href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#details">More...</a></p> <p><code>#include <Wt/Dbo/backend/Postgres></code></p> <div class="dynheader"> Inheritance diagram for Wt::Dbo::backend::Postgres:</div> <div class="dyncontent"> <div class="center"><img src="classWt_1_1Dbo_1_1backend_1_1Postgres__inherit__graph.png" border="0" usemap="#Wt_1_1Dbo_1_1backend_1_1Postgres_inherit__map" alt="Inheritance graph"/></div> <map name="Wt_1_1Dbo_1_1backend_1_1Postgres_inherit__map" id="Wt_1_1Dbo_1_1backend_1_1Postgres_inherit__map"> <area shape="rect" href="classWt_1_1Dbo_1_1SqlConnection.html" title="Abstract base class for an SQL connection." alt="" coords="19,5,179,32"/></map> <center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div> <p><a href="classWt_1_1Dbo_1_1backend_1_1Postgres-members.html">List of all members.</a></p> <table class="memberdecls"> <tr><td colspan="2"><h2><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a5699b228685c11aaf3293e1ec6243f35">Postgres</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Creates new PostgreSQL backend connection. <a href="#a5699b228685c11aaf3293e1ec6243f35"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a3fd006b93f9eb7d8c88d9f01d339606d">Postgres</a> (const std::string &db)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Opens a new PostgreSQL backend connection. <a href="#a3fd006b93f9eb7d8c88d9f01d339606d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ae032939fe1a5e5007179d5c52e9074c1">Postgres</a> (const <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html">Postgres</a> &other)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Copies a PostgreSQL connection. <a href="#ae032939fe1a5e5007179d5c52e9074c1"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a6b7dbc604df8610791e6cfdc57b55443">~Postgres</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Destructor. <a href="#a6b7dbc604df8610791e6cfdc57b55443"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html">Postgres</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ae905567f9ed51f9b200222a995c4894f">clone</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Clones the connection. <a href="#ae905567f9ed51f9b200222a995c4894f"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a003ae8b797aea816669d4f02a34c6806">connect</a> (const std::string &db)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Tries to connect. <a href="#a003ae8b797aea816669d4f02a34c6806"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a025dd7452d7f25cdca2088999d37e238"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::connection" ref="a025dd7452d7f25cdca2088999d37e238" args="()" --> PGconn * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a025dd7452d7f25cdca2088999d37e238">connection</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the underlying connection. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a9eaa769e442138ed02a0caed39cfd7f6">executeSql</a> (const std::string &sql)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Executes an SQL statement. <a href="#a9eaa769e442138ed02a0caed39cfd7f6"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ac1148a180204342f6ca910d106b58b00">startTransaction</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Starts a transaction. <a href="#ac1148a180204342f6ca910d106b58b00"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a81966e0110e7d3c2076cf27a7e08e236">commitTransaction</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Commits a transaction. <a href="#a81966e0110e7d3c2076cf27a7e08e236"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#aea0742af53f3306a3302647014a8e3e2">rollbackTransaction</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Rolls back a transaction. <a href="#aea0742af53f3306a3302647014a8e3e2"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#aa899b3109ba4400bf348384744a31e8f">prepareStatement</a> (const std::string &sql)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Prepares a statement. <a href="#aa899b3109ba4400bf348384744a31e8f"></a><br/></td></tr> <tr><td colspan="2"><div class="groupHeader">Methods that return dialect information</div></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a92adbae7113272038f0ceb6ca6a93ccc">autoincrementSql</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type modifier. <a href="#a92adbae7113272038f0ceb6ca6a93ccc"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::vector< std::string > </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ab6ea8bdba8d248a593df1e66548ff567">autoincrementCreateSequenceSql</a> (const std::string &table, const std::string &id) const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to create an id sequence. <a href="#ab6ea8bdba8d248a593df1e66548ff567"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::vector< std::string > </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#af82c7852c789cfc8dc79dd17a88f9fe2">autoincrementDropSequenceSql</a> (const std::string &table, const std::string &id) const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to drop an id sequence. <a href="#af82c7852c789cfc8dc79dd17a88f9fe2"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a5671d18ab68b492d590485458cca5122">autoincrementType</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type. <a href="#a5671d18ab68b492d590485458cca5122"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#af05af24a4bd0c20a090387056d724745">autoincrementInsertSuffix</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the suffix for an 'autoincrement' insert statement. <a href="#af05af24a4bd0c20a090387056d724745"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a1e978200ba52918f2e2fd26a32dad456">dateTimeType</a> (<a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type) const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the date/time type. <a href="#a1e978200ba52918f2e2fd26a32dad456"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a81acebb9e839ed7f976602396ae6ed0a">blobType</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the blob type. <a href="#a81acebb9e839ed7f976602396ae6ed0a"></a><br/></td></tr> </table> <hr/><a name="details" id="details"></a><h2>Detailed Description</h2> <div class="textblock"><p>A PostgreSQL connection. </p> <p>This class provides the backend implementation for PostgreSQL databases.</p> <p>When applicable, exceptions from the backend will return the five-character SQLSTATE error codes, as in <a href="http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html,">http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html,</a> in <a class="el" href="classWt_1_1Dbo_1_1Exception.html#a99b6fe5450191fe4767d3f21167445a9" title="A (backend-specific) error code.">Exception::code()</a>. </p> </div><hr/><h2>Constructor & Destructor Documentation</h2> <a class="anchor" id="a5699b228685c11aaf3293e1ec6243f35"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::Postgres" ref="a5699b228685c11aaf3293e1ec6243f35" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">Wt::Dbo::backend::Postgres::Postgres </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Creates new PostgreSQL backend connection. </p> <p>The connection is not yet open, and requires a <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a003ae8b797aea816669d4f02a34c6806" title="Tries to connect.">connect()</a> before it can be used. </p> </div> </div> <a class="anchor" id="a3fd006b93f9eb7d8c88d9f01d339606d"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::Postgres" ref="a3fd006b93f9eb7d8c88d9f01d339606d" args="(const std::string &db)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">Wt::Dbo::backend::Postgres::Postgres </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>db</em></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Opens a new PostgreSQL backend connection. </p> <p>The <code>db</code> may be any of the values supported by PQconnectdb(). </p> </div> </div> <a class="anchor" id="ae032939fe1a5e5007179d5c52e9074c1"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::Postgres" ref="ae032939fe1a5e5007179d5c52e9074c1" args="(const Postgres &other)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">Wt::Dbo::backend::Postgres::Postgres </td> <td>(</td> <td class="paramtype">const <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html">Postgres</a> & </td> <td class="paramname"><em>other</em></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Copies a PostgreSQL connection. </p> <p>This creates a new connection with the same settings as another connection.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ae905567f9ed51f9b200222a995c4894f" title="Clones the connection.">clone()</a> </dd></dl> </div> </div> <a class="anchor" id="a6b7dbc604df8610791e6cfdc57b55443"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::~Postgres" ref="a6b7dbc604df8610791e6cfdc57b55443" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">Wt::Dbo::backend::Postgres::~Postgres </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Destructor. </p> <p>Closes the connection. </p> </div> </div> <hr/><h2>Member Function Documentation</h2> <a class="anchor" id="ab6ea8bdba8d248a593df1e66548ff567"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::autoincrementCreateSequenceSql" ref="ab6ea8bdba8d248a593df1e66548ff567" args="(const std::string &table, const std::string &id) const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::vector< std::string > Wt::Dbo::backend::Postgres::autoincrementCreateSequenceSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>table</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the SQL statement(s) required to create an id sequence. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a7922dac3fd8a808dbbeef97a5a772e3f">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="af82c7852c789cfc8dc79dd17a88f9fe2"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::autoincrementDropSequenceSql" ref="af82c7852c789cfc8dc79dd17a88f9fe2" args="(const std::string &table, const std::string &id) const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::vector< std::string > Wt::Dbo::backend::Postgres::autoincrementDropSequenceSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>table</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the SQL statement(s) required to drop an id sequence. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#a4c1fedb21e4e1cc44b182a34e8ebb4ef" title="Drops the database schema.">Session::dropTables()</a> to drop the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a188acc931dd1d3dbd3a21e28783f7bd2">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="af05af24a4bd0c20a090387056d724745"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::autoincrementInsertSuffix" ref="af05af24a4bd0c20a090387056d724745" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::string Wt::Dbo::backend::Postgres::autoincrementInsertSuffix </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the suffix for an 'autoincrement' insert statement. </p> <p>This is appended to the <code>insert</code> statement, since some back-ends need to be indicated that they should return the autoincrement id. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aec6a5227e676cf373f842e4d1ac75f12">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a92adbae7113272038f0ceb6ca6a93ccc"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::autoincrementSql" ref="a92adbae7113272038f0ceb6ca6a93ccc" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::string Wt::Dbo::backend::Postgres::autoincrementSql </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the 'autoincrement' SQL type modifier. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the <em>id</em> column. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a8c00fd64eb82999880cc813ef3866f5d">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a5671d18ab68b492d590485458cca5122"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::autoincrementType" ref="a5671d18ab68b492d590485458cca5122" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::string Wt::Dbo::backend::Postgres::autoincrementType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the 'autoincrement' SQL type. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the <em>id</em> column. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aff293ff5ad586e15143729eb38300ad6">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a81acebb9e839ed7f976602396ae6ed0a"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::blobType" ref="a81acebb9e839ed7f976602396ae6ed0a" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char * Wt::Dbo::backend::Postgres::blobType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the blob type. </p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ae2bbddef8fd8c11687d23187920dc4da" title="Binds a value to a column.">SqlStatement::bind(int, const std::vector<unsigned char>&)</a> </dd></dl> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a68a272eaafeef5e04912914f0662da39">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="ae905567f9ed51f9b200222a995c4894f"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::clone" ref="ae905567f9ed51f9b200222a995c4894f" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html">Postgres</a> * Wt::Dbo::backend::Postgres::clone </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Clones the connection. </p> <p>Returns a new connection object that is configured like this object. This is used by connection pool implementations to create its connections. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a60168581b0fdeb4a6404358455a2ac8d">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a81966e0110e7d3c2076cf27a7e08e236"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::commitTransaction" ref="a81966e0110e7d3c2076cf27a7e08e236" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::backend::Postgres::commitTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Commits a transaction. </p> <p>This function commits a transaction. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a38ed9ab4831a0bfd8694f250813803bf">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a003ae8b797aea816669d4f02a34c6806"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::connect" ref="a003ae8b797aea816669d4f02a34c6806" args="(const std::string &db)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">bool Wt::Dbo::backend::Postgres::connect </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>db</em></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Tries to connect. </p> <p>Throws an exception if there was a problem, otherwise true. </p> </div> </div> <a class="anchor" id="a1e978200ba52918f2e2fd26a32dad456"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::dateTimeType" ref="a1e978200ba52918f2e2fd26a32dad456" args="(SqlDateTimeType type) const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char * Wt::Dbo::backend::Postgres::dateTimeType </td> <td>(</td> <td class="paramtype"><a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> </td> <td class="paramname"><em>type</em></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the date/time type. </p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a94c43852e586bbcba7077352588fe1a2" title="Binds a value to a column.">SqlStatement::bind(int, const boost::posix_time::ptime&, SqlDateTimeType)</a> </dd></dl> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#af1f3290a984288175c6d82d088d0636c">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="a9eaa769e442138ed02a0caed39cfd7f6"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::executeSql" ref="a9eaa769e442138ed02a0caed39cfd7f6" args="(const std::string &sql)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::backend::Postgres::executeSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>sql</em></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Executes an SQL statement. </p> <p>This is a convenience method for preparing a statement, executing it, and deleting it. </p> <p>Reimplemented from <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a2c45628057f538e8a706eff6d4d9f559">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="aa899b3109ba4400bf348384744a31e8f"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::prepareStatement" ref="aa899b3109ba4400bf348384744a31e8f" args="(const std::string &sql)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * Wt::Dbo::backend::Postgres::prepareStatement </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>sql</em></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Prepares a statement. </p> <p>Returns the prepared statement. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#afbebcc0007aef36f6aa02b61f514b853">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="aea0742af53f3306a3302647014a8e3e2"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::rollbackTransaction" ref="aea0742af53f3306a3302647014a8e3e2" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::backend::Postgres::rollbackTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Rolls back a transaction. </p> <p>This function rolls back a transaction. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aee5a42b2f3b452d32360a1c31f59f22d">Wt::Dbo::SqlConnection</a>.</p> </div> </div> <a class="anchor" id="ac1148a180204342f6ca910d106b58b00"></a><!-- doxytag: member="Wt::Dbo::backend::Postgres::startTransaction" ref="ac1148a180204342f6ca910d106b58b00" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::backend::Postgres::startTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Starts a transaction. </p> <p>This function starts a transaction. </p> <p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#abcddbb27f50192113d14c66a5ca10731">Wt::Dbo::SqlConnection</a>.</p> </div> </div> </div> <!-- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Enumerator</a></div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="javascript:void(0)" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <hr size="1"><address style="text-align: right; margin: 3px"><small> Generated on Thu Nov 1 2012 for <a href="http://www.webtoolkit.eu/wt">the C++ Web Toolkit (Wt)</a> by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" border="0" style="vertical-align: middle; display: inline-block; height: 2em"></a> 1.7.5.1</small></address> </body> </html>