Inheritance diagram for ADODB_pdo_pgsql:

Collaboration diagram for ADODB_pdo_pgsql:

Public Member Functions
	_init ($parentDriver)
	ServerInfo ()
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	MetaColumns ($table, $normalize=true)
Public Attributes
	$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 = 't'
	$false = 'f'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d G: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()'
	$concat_operator = '\|\|'
	random function

Detailed Description

Definition at line 12 of file adodb-pdo_pgsql.inc.php.

Member Function Documentation

ADODB_pdo_pgsql::_init ( $ parentDriver )

Definition at line 57 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::MetaColumns	(	$	table,
		$	normalize = `true`
	)

Reimplemented from ADODB_pdo.

Definition at line 115 of file adodb-pdo_pgsql.inc.php.

References $false, $rs, and $sql.

ADODB_pdo_pgsql::MetaTables	(	$	ttype = `false`,
		$	showSchema = `false`,
		$	mask = `false`
	)

Reimplemented from ADODB_pdo.

Definition at line 84 of file adodb-pdo_pgsql.inc.php.

References ServerInfo().

Here is the call graph for this function:

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

Reimplemented from ADODB_pdo.

Definition at line 72 of file adodb-pdo_pgsql.inc.php.

References $rs, and $sql.

ADODB_pdo_pgsql::ServerInfo ( )

Reimplemented from ADODB_pdo.

Definition at line 65 of file adodb-pdo_pgsql.inc.php.

Referenced by MetaTables().

Here is the caller graph for this function:

Member Data Documentation

ADODB_pdo_pgsql::$_dropSeqSQL = "DROP SEQUENCE %s"

Definition at line 52 of file adodb-pdo_pgsql.inc.php.

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

Definition at line 50 of file adodb-pdo_pgsql.inc.php.

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

Reimplemented from ADODB_pdo.

Definition at line 51 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$blobEncodeType = 'C'

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

ADODB_pdo_pgsql::$concat_operator = '||'

random function

Definition at line 55 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$false = 'f'

Definition at line 45 of file adodb-pdo_pgsql.inc.php.

Referenced by MetaColumns().

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

Reimplemented from ADODB_pdo.

Definition at line 46 of file adodb-pdo_pgsql.inc.php.

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

Reimplemented from ADODB_pdo.

Definition at line 47 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$hasAffectedRows = true

Reimplemented from ADODB_pdo.

Definition at line 41 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$hasGenID = true

Definition at line 49 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$hasLimit = false

Definition at line 42 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$hasMoveFirst = true

Definition at line 48 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$isoDates = true

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

ADODB_pdo_pgsql::$metaColumnsSQL

Initial value:

"SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum 
                FROM pg_class c, pg_attribute a,pg_type t 
                WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

Definition at line 24 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$metaColumnsSQL1

Initial value:

"SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum 
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n 
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
 and c.relnamespace=n.oid and n.nspname='%s' 
        and a.attname not like '....%%' AND a.attnum > 0 
        AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

Definition at line 30 of file adodb-pdo_pgsql.inc.php.

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

Definition at line 13 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$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"

Definition at line 53 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$metaKeySQL

Initial value:

"SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key 
        FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'"

Definition at line 38 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$metaTablesSQL

Initial value:

"select tablename,'T' from pg_tables where tablename not like 'pg\_%'
        and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
         'sql_packages', 'sql_sizing', 'sql_sizing_profiles') 
        union 
        select viewname,'V' from pg_views where viewname not like 'pg\_%'"

Definition at line 14 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$random = 'random()'

Definition at line 54 of file adodb-pdo_pgsql.inc.php.

ADODB_pdo_pgsql::$sysDate = "CURRENT_DATE"

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

ADODB_pdo_pgsql::$sysTimeStamp = "CURRENT_TIMESTAMP"

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

ADODB_pdo_pgsql::$true = 't'

Definition at line 44 of file adodb-pdo_pgsql.inc.php.

The documentation for this class was generated from the following file:

typo3/sysext/adodb/adodb/drivers/adodb-pdo_pgsql.inc.php

ADODB_pdo_pgsql Class Reference

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

Member Data Documentation