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" | |
| character set to use - only for interbase, postgres and oci8 | |
| $metaTablesSQL | |
| $isoDates = true | |
| error function to call | |
| $sysDate = "CURRENT_DATE" | |
| Use 'true' to store the item compressed (uses zlib). | |
| $sysTimeStamp = "CURRENT_TIMESTAMP" | |
| name of function that returns the current date | |
| $blobEncodeType = 'C' | |
| $metaColumnsSQL | |
| $metaColumnsSQL1 | |
| $metaKeySQL | |
| $hasAffectedRows = true | |
| supports autoincrement ID? | |
| $hasLimit = false | |
| support mssql/access SELECT TOP 10 * FROM TABLE | |
| $true = 't' | |
| used by DBTimeStamp as the default timestamp fmt. | |
| $false = 'f' | |
| string that represents TRUE for a database | |
| $fmtDate = "'Y-m-d'" | |
| uppercase function | |
| $fmtTimeStamp = "'Y-m-d G:i:s'" | |
| used by DBDate() as the default date format used by the database | |
| $hasMoveFirst = true | |
| this is a readonly database - used by phpLens | |
| $hasGenID = true | |
| has ability to run MoveFirst(), scrolling backwards | |
| $_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()' | |
| string length ofperator | |
| $concat_operator = '||' | |
| random function | |
Definition at line 12 of file adodb-pdo_pgsql.inc.php.
| ADODB_pdo_pgsql::ServerInfo | ( | ) |
Get server version info...
Reimplemented from ADODB_pdo.
Definition at line 65 of file adodb-pdo_pgsql.inc.php.
| & ADODB_pdo_pgsql::SelectLimit | ( | $ | sql, | |
| $ | nrows = -1, |
|||
| $ | offset = -1, |
|||
| $ | inputarr = false, |
|||
| $ | secs2cache = 0 | |||
| ) |
Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based)
Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set
| sql | ||
| [offset] | is the row to start calculations from (1-based) | |
| [nrows] | is the number of rows to get | |
| [inputarr] | array of bind variables | |
| [secs2cache] | is a private parameter only used by jlim |
Reimplemented from ADODB_pdo.
Definition at line 72 of file adodb-pdo_pgsql.inc.php.
| & ADODB_pdo_pgsql::MetaTables | ( | $ | ttype = false, |
|
| $ | showSchema = false, |
|||
| $ | mask = false | |||
| ) |
| ttype | can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables | |
| showSchema | returns the schema/user with the table name, eg. USER.TABLE | |
| mask | is the input mask - only supported by oci8 and postgresql |
Reimplemented from ADODB_pdo.
Definition at line 84 of file adodb-pdo_pgsql.inc.php.
| & ADODB_pdo_pgsql::MetaColumns | ( | $ | table, | |
| $ | normalize = true | |||
| ) |
List columns in a database as an array of ADOFieldObjects. See top of file for definition of object.
| $table | table name to query | |
| $normalize | makes table name case-insensitive (required by some databases) is optional database schema to use - not supported by all databases. |
Reimplemented from ADODB_pdo.
Definition at line 115 of file adodb-pdo_pgsql.inc.php.