Inheritance diagram for ADODB_postgres7:

Public Member Functions
	__construct ()

	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)

	MetaForeignKeys ($table, $owner=false, $upper=false)

	_old_MetaForeignKeys ($table, $owner=false, $upper=false)

	_query ($sql, $inputarr=false)

	GetCharSet ()

	SetCharSet ($charset_name)

Public Member Functions inherited from ADODB_postgres64
	__construct ()

	ServerInfo ()

	IfNull ( $field, $ifNull)

	pg_insert_id ($tablename, $fieldname)

	_insertid ($table, $column)

	_affectedrows ()

	BeginTrans ()

	RowLock ($tables, $where, $col='1 as adodbignore')

	CommitTrans ($ok=true)

	RollbackTrans ()

	MetaTables ($ttype=false, $showSchema=false, $mask=false)

	qstr ($s, $magic_quotes=false)

	SQLDate ($fmt, $col=false)

	UpdateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')

	BlobDelete ( $blob)

	GuessOID ($oid)

	BlobDecode ($blob, $maxsize=false, $hastrans=true)

	BlobEncode ($blob)

	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')

	OffsetDate ($dayFraction, $date=false)

	MetaColumns ($table, $normalize=true)

	Param ($name, $type='C')

	MetaIndexes ($table, $primary=FALSE, $owner=false)

	_connect ($str, $user='', $pwd='', $db='', $ctype=0)

	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabaseName)

	_pconnect ($str, $user='', $pwd='', $db='')

	_query ($sql, $inputarr=false)

	_errconnect ()

	ErrorMsg ()

	ErrorNo ()

	_close ()

	CharMax ()

	TextMax ()

Public Attributes
	$databaseType = 'postgres7'

	$hasLimit = true

	$ansiOuter = true

	$charSet = true

	$metaColumnsSQL

	$metaColumnsSQL1

Public Attributes inherited from ADODB_postgres64
	$databaseType = 'postgres64'

	$dataProvider = 'postgres'

	$hasInsertID = true

	$_resultid = false

	$concat_operator ='\|\|'

	$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"

	$metaTablesSQL

	$isoDates = true

	$sysDate = "CURRENT_DATE"

	$sysTimeStamp = "CURRENT_TIMESTAMP"

	$blobEncodeType = 'C'

	$metaColumnsSQL

	$metaColumnsSQL1

	$metaKeySQL

	$hasAffectedRows = true

	$hasLimit = false

	$true = 'TRUE'

	$false = 'FALSE'

	$fmtDate = "'Y-m-d'"

	$fmtTimeStamp = "'Y-m-d H:i:s'"

	$hasMoveFirst = true

	$hasGenID = true

	$_genIDSQL = "SELECT NEXTVAL('%s')"

	$_genSeqSQL = "CREATE SEQUENCE %s START %s"

	$_dropSeqSQL = "DROP SEQUENCE %s"

	$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"

	$random = 'random()'

	$autoRollback = true
	random function More...

	$uniqueIisR = true

	$_bindInputArray = false

	$disableBlobs = false

	$_pnum = 0

Detailed Description

Definition at line 19 of file adodb-postgres7.inc.php.

Constructor & Destructor Documentation

◆ __construct()

ADODB_postgres7::__construct ( )

Definition at line 78 of file adodb-postgres7.inc.php.

Member Function Documentation

◆ _old_MetaForeignKeys()

ADODB_postgres7::_old_MetaForeignKeys	(	$table,
		$owner = `false`,
		$upper = `false`
	)

Definition at line 163 of file adodb-postgres7.inc.php.

References $sql.

◆ _query()

ADODB_postgres7::_query	(	$sql,
		$inputarr = `false`
	)

Definition at line 196 of file adodb-postgres7.inc.php.

◆ GetCharSet()

ADODB_postgres7::GetCharSet ( )

Definition at line 239 of file adodb-postgres7.inc.php.

References $charSet.

Referenced by SetCharSet().

◆ MetaForeignKeys()

ADODB_postgres7::MetaForeignKeys	(	$table,
		$owner = `false`,
		$upper = `false`
	)

Definition at line 118 of file adodb-postgres7.inc.php.

References $rs, and $sql.

◆ SelectLimit()

ADODB_postgres7::SelectLimit	(	$sql,
		$nrows = `-1`,
		$offset = `-1`,
		$inputarr = `false`,
		$secs2cache = `0`
	)

Definition at line 90 of file adodb-postgres7.inc.php.

References $rs, and $sql.

◆ SetCharSet()

ADODB_postgres7::SetCharSet ( $charset_name )

Definition at line 251 of file adodb-postgres7.inc.php.

References GetCharSet().

Member Data Documentation

◆ $ansiOuter

ADODB_postgres7::$ansiOuter = true

Definition at line 22 of file adodb-postgres7.inc.php.

◆ $charSet

ADODB_postgres7::$charSet = true

Definition at line 23 of file adodb-postgres7.inc.php.

Referenced by GetCharSet().

◆ $databaseType

ADODB_postgres7::$databaseType = 'postgres7'

Definition at line 20 of file adodb-postgres7.inc.php.

◆ $hasLimit

ADODB_postgres7::$hasLimit = true

Definition at line 21 of file adodb-postgres7.inc.php.

◆ $metaColumnsSQL

ADODB_postgres7::$metaColumnsSQL

Initial value:

=
                         "SELECT a.attname,
                                    CASE
                                               WHEN x.sequence_name != '' THEN 'SERIAL'
                                               ELSE t.typname
                                    END AS typname,
                                    a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
                         FROM pg_class c, pg_attribute a
                         JOIN pg_type t ON a.atttypid = t.oid
                         LEFT JOIN
                                    (SELECT c.relname as sequence_name,
                                                  c1.relname as related_table,
                                                  a.attname as related_column
                                    FROM pg_class c
                                       JOIN pg_depend d ON d.objid = c.oid
                                       LEFT JOIN pg_class c1 ON d.refobjid = c1.oid
                                       LEFT JOIN pg_attribute a ON (d.refobjid, d.refobjsubid) = (a.attrelid, a.attnum)
                                    WHERE c.relkind = 'S' AND c1.relname = '%s') x
                                    ON x.related_column= a.attname
                         WHERE c.relkind in ('r','v') AND
                                    (c.relname='%s' or c.relname = lower('%s')) AND
                                    a.attname not like '....%%' AND
                                    a.attnum > 0 AND
                                    a.attrelid = c.oid
                         ORDER BY a.attnum"

Definition at line 25 of file adodb-postgres7.inc.php.

◆ $metaColumnsSQL1

ADODB_postgres7::$metaColumnsSQL1