Search moodle.org's
Developer Documentation
Developer Documentation
See Release Notes
Long Term Support Release
- Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
- Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
- PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/adodb/drivers/ -> adodb-postgres64.inc.php (source)
Differences Between: [Versions 310 and 401] [Versions 311 and 401] [Versions 39 and 401] [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]
ADOdb PostgreSQL 6.4 driver
| Copyright: | 2000-2013 John Lim |
| Copyright: | 2014 Damien Regad, Mark Newnham and the ADOdb community |
| License: | BSD-3-Clause |
| License: | LGPL-2.1-or-later |
| File Size: | 1161 lines (32 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Defines 3 classes
ADODB_postgres64:: (33 methods):
ServerInfo()
IfNull()
pg_insert_id()
_insertID()
_affectedrows()
BeginTrans()
RowLock()
CommitTrans()
RollbackTrans()
MetaTables()
qStr()
SQLDate()
UpdateBlobFile()
BlobDelete()
GuessOID()
BlobDecode()
BlobEncode()
UpdateBlob()
OffsetDate()
_generateMetaColumnsSQL()
MetaColumns()
param()
MetaIndexes()
_connect()
_nconnect()
_pconnect()
_query()
_errconnect()
ErrorMsg()
ErrorNo()
_close()
CharMax()
TextMax()
Name:: (0 methods):
ADORecordSet_postgres64:: (12 methods):
__construct()
GetRowAssoc()
_initRS()
fields()
fetchField()
_seek()
_decode()
_prepFields()
MoveNext()
_fetch()
_close()
MetaType()
Class: ADODB_postgres64 - X-Ref
| ServerInfo($detailed = true) X-Ref |
| Retrieve Server information. In addition to server version and description, the function also returns the client version. param: bool $detailed If true, retrieve detailed version string (executes return: array|bool Server info or false if version could not be retrieved |
| IfNull( $field, $ifNull ) X-Ref |
| No description |
| pg_insert_id($tablename,$fieldname) X-Ref |
| No description |
| _insertID($table = '', $column = '') X-Ref |
| Warning from http://www.php.net/manual/function.pg-getlastoid.php: Using a OID as a unique identifier is not generally wise. Unless you are very careful, you might end up with a tuple having a different OID if a database must be reloaded. |
| _affectedrows() X-Ref |
| No description |
| BeginTrans() X-Ref |
return: bool |
| RowLock($tables,$where,$col='1 as adodbignore') X-Ref |
| No description |
| CommitTrans($ok=true) X-Ref |
| No description |
| RollbackTrans() X-Ref |
| No description |
| MetaTables($ttype=false,$showSchema=false,$mask=false) X-Ref |
| No description |
| qStr($s, $magic_quotes=false) X-Ref |
| Quotes a string to be sent to the database. Relies on pg_escape_string() param: string $s The string to quote param: bool $magic_quotes This param is not used since 5.21.0. return: string Quoted string |
| SQLDate($fmt, $col=false) X-Ref |
| No description |
| UpdateBlobFile($table,$column,$path,$where,$blobtype='BLOB') X-Ref |
| No description |
| BlobDelete( $blob ) X-Ref |
| No description |
| GuessOID($oid) X-Ref |
| No description |
| BlobDecode($blob,$maxsize=false,$hastrans=true) X-Ref |
| No description |
| BlobEncode($blob) X-Ref |
| Encode binary value prior to DB storage. See https://www.postgresql.org/docs/current/static/datatype-binary.html NOTE: SQL string literals (input strings) must be preceded with two backslashes due to the fact that they must pass through two parsers in the PostgreSQL backend. param: string $blob |
| UpdateBlob($table,$column,$val,$where,$blobtype='BLOB') X-Ref |
| No description |
| OffsetDate($dayFraction,$date=false) X-Ref |
| No description |
| _generateMetaColumnsSQL($table, $schema) X-Ref |
| Generate the SQL to retrieve MetaColumns data param: string $table Table name param: string $schema Schema name (can be blank) return: string SQL statement to execute |
| MetaColumns($table,$normalize=true) X-Ref |
| No description |
| param($name, $type='C') X-Ref |
| No description |
| MetaIndexes($table, $primary = FALSE, $owner = false) X-Ref |
| No description |
| _connect($str, $user='', $pwd='', $db='', $ctype=0) X-Ref |
| Connect to a database. Examples: $db->Connect("host=host1 user=user1 password=secret port=4341"); $db->Connect('host1:4341', 'user1', 'secret'); param: string $str pg_connect() Connection string or Hostname[:port] param: string $user (Optional) The username to connect as. param: string $pwd (Optional) The password to connect with. param: string $db (Optional) The name of the database to start in when connected. param: int $ctype Connection type return: bool|null True if connected successfully, false if connection failed, or |
| _nconnect($argHostname, $argUsername, $argPassword, $argDatabaseName) X-Ref |
| No description |
| _pconnect($str,$user='',$pwd='',$db='') X-Ref |
| No description |
| _query($sql,$inputarr=false) X-Ref |
| No description |
| _errconnect() X-Ref |
| No description |
| ErrorMsg() X-Ref |
| No description |
| ErrorNo() X-Ref |
| No description |
| _close() X-Ref |
| No description |
| CharMax() X-Ref |
| No description |
| TextMax() X-Ref |
| No description |
Class: ADORecordSet_postgres64 - X-Ref
| __construct($queryID, $mode=false) X-Ref |
| No description |
| GetRowAssoc($upper = ADODB_ASSOC_CASE) X-Ref |
| No description |
| _initRS() X-Ref |
| No description |
| fields($colname) X-Ref |
| No description |
| fetchField($fieldOffset = 0) X-Ref |
| No description |
| _seek($row) X-Ref |
| No description |
| _decode($blob) X-Ref |
| No description |
| _prepFields() X-Ref |
| Fetches and prepares the RecordSet's fields. Fixes the blobs if there are any. |
| MoveNext() X-Ref |
| No description |
| _fetch() X-Ref |
| No description |
| _close() X-Ref |
| No description |
| MetaType($t,$len=-1,$fieldobj=false) X-Ref |
| No description |
