Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.

Differences Between: [Versions 310 and 402] [Versions 311 and 402] [Versions 39 and 402] [Versions 400 and 402] [Versions 401 and 402] [Versions 402 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: 1163 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: Name  - X-Ref

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