| Pub.PostgreSQL: | Functions | Types | Modinfo | Source |
| Function GetPostgreSQLDBDriver:ISQLDB(bConnect:Int,host:String,user:String,passwd:String,db:String=Null,port:Int=5432,extra_params:String="") | |
| Description | Gets an instance of the PostgreSQL database driver. |
| Information | Pass bConnect as True to connect to the server automatically. Pass the returned value to SetISQLDBDriver to make this the global database driver. |
| Function PQclear(res:Int) | |
| Description | Frees the storage associated with a PGresult. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQcmdTuples$z(res:Int) | |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQconnectdb(s$z) | |
| Description | Makes a New connection To the database server. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQerrorMessage$z(conn:Int) | |
| Description | Returns the error message most recently generated by an operation on the connection. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQescapeBytea:Byte Ptr(from$z,from_length:Int,to_length:Int Ptr) | |
| Description | Escapes binary data for use within an SQL command with the type bytea. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQescapeString:Int(ptrTo:Byte Ptr,from$z,from_length:Int) | |
| Description | Escapes a string for use within an SQL command. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQexec:Int(conn:Int, query_string$z) | |
| Description | Submits a command to the server and waits for the result. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQfinish(conn:Int) | |
| Description | Closes an open PostgreSQL client connection. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQfname$z(res:Int,column_number:Int) | |
| Description | Returns the column name associated with the given column number. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQfnumber:Int(res:Int,column_name$z) | |
| Description | Returns the column number associated with the given column name. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQfreemem(dataptr:Byte Ptr) | |
| Description | Frees the memory returned by PQescapeBytea and PQunescapeBytea. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQfsize:Int(res:Int,column_number:Int) | |
| Description | Returns the size in bytes of the column associated with the given column number. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQgetisnull:Int(res:Int,row_number:Int,column_number:Int) | |
| Description | Tests a field for a null value. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQgetlength:Int(res:Int,row_number:Int,column_number:Int) | |
| Description | Returns the actual length of a field value in bytes. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQgetvalue$z(res:Int,i:Int,n:Int) | |
| Description | Returns a single field value of one row of a PGresult. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQnfields:Int(res:Int) | |
| Description | Returns the number of columns (fields) in each row of the query result. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQntuples:Int(res:Int) | |
| Description | Returns the number of rows (tuples) in the query result. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQoidStatus$z(res:Int) | |
| Description | Returns a string with the OID of the inserted row. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQresultStatus:Int(res:Int) | |
| Description | Returns the result status of the command. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQstatus:Int(conn:Int) | |
| Description | Returns the status of the connection. |
| Information | See the PostgreSQL SDK manual for more information. |
| Function PQunescapeBytea:Byte Ptr(from$z,to_length:Int Ptr) | |
| Description | Converts an escaped string representation of binary data into binary data [mdash ] the reverse of PQescapeBytea. |
| Information | See the PostgreSQL SDK manual for more information. |
| Type IPostgreSQLDB Extends ISQLDB Abstract | |
| Description | Interface for a PostgreSQL database connection. |
| Method escapeBinary:String(stmt:String) Abstract | |
| Description | Escapes a binary string to make it compatible with the PostgreSQL query engine. |
| Method escapeString:String(stmt:String) Abstract | |
| Description | Escapes a string to make it compatible with the PostgreSQL query engine. |
| Method getParams:String() Abstract | |
| Description | Gets the extra parameters passed in the connection string. |
| Method unescapeBinary:String(stmt:String) Abstract | |
| Description | Unescapes a binary string. |
| Name | BlitzMax PostgreSQL Module v1.00 |
|---|---|
| Description | BlitzMax module implementing client support for PostgreSQL |
| License | freebie |
| Authors | gman, original PostgreSQL imports by Chris Camacho |
| History | 2006/1/18 GG - intial release v1.00 |