Adodb Dokumentation  V5.14 8 Sept 2011
ADODB_pdo_pgsql Klassenreferenz
Klassendiagramm für ADODB_pdo_pgsql:
Zusammengehörigkeiten von ADODB_pdo_pgsql:

Öffentliche Methoden

 _init ($parentDriver)
 ServerInfo ()
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 MetaColumns ($table, $normalize=true)

Datenfelder

 $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

Ausführliche Beschreibung

Definiert in Zeile 12 der Datei adodb-pdo_pgsql.inc.php.


Dokumentation der Datenelemente

$metaColumnsSQL
Initialisierung:
"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"

Definiert in Zeile 24 der Datei adodb-pdo_pgsql.inc.php.

$metaColumnsSQL1
Initialisierung:
"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"

Definiert in Zeile 30 der Datei adodb-pdo_pgsql.inc.php.

$metaKeySQL
Initialisierung:
"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'"

Definiert in Zeile 38 der Datei adodb-pdo_pgsql.inc.php.

$metaTablesSQL
Initialisierung:
"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\_%'"

Definiert in Zeile 14 der Datei adodb-pdo_pgsql.inc.php.


Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei: