Class ilDBPdoPostgreSQL. More...

Inheritance diagram for ilDBPdoPostgreSQL:

Collaboration diagram for ilDBPdoPostgreSQL:

Public Member Functions

generateDSN ()

connect ($return_false_for_error=false)

initHelpers ()

getPrimaryKeyIdentifier ()

Primary key identifier. More...

supportsFulltext ()

supportsTransactions ()

constraintName ($a_table, $a_constraint)

getIndexName ($index_name_base)

replace ($a_table, $a_pk_columns, $a_other_columns)

lockTables ($a_tables)

unlockTables ()

getStorageEngine ()

setStorageEngine ($storage_engine)

nextId ($table_name)

dropTable ($table_name, $error_if_not_existing=false)

quoteIdentifier ($identifier, $check_option=false)

tableExists ($table_name)

tableColumnExists ($table_name, $column_name)

renameTable ($a_name, $a_new_name)

createSequence ($table_name, $start=1)

createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false)

addPrimaryKey ($table_name, $primary_keys)

addIndex ($table_name, $fields, $index_name='', $fulltext=false)

addUniqueConstraint ($table, $fields, $name="con")

dropPrimaryKey ($table_name)

Public Member Functions inherited from ilDBPdo

connect ($return_false_for_error=false)

initHelpers ()

getFieldDefinition ()

setFieldDefinition ($field_definition)

createDatabase ($a_name, $a_charset="utf8", $a_collation="")

getLastErrorCode ()

initFromIniFile ($tmpClientIniFile=null)

generateDSN ()

quoteIdentifier ($identifier, $check_option=false)

nextId ($table_name)

createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false)

checkColumnName ($a_name)

addPrimaryKey ($table_name, $primary_keys)

dropIndexByFields ($table_name, $fields)

getPrimaryKeyIdentifier ()

createSequence ($table_name, $start=1)

tableExists ($table_name)

tableColumnExists ($table_name, $column_name)

addTableColumn ($table_name, $column_name, $attributes)

dropTable ($table_name, $error_if_not_existing=true)

query ($query)

dropSequence ($table_name)

dropTableColumn ($table_name, $column_name)

renameTableColumn ($table_name, $column_old_name, $column_new_name)

insert ($table_name, $values)

fetchObject ($query_result)

update ($table_name, $columns, $where)

manipulate ($query)

fetchAssoc ($query_result)

numRows ($query_result)

quote ($value, $type=null)

indexExistsByFields ($table_name, $fields)

addIndex ($table_name, $fields, $index_name='', $fulltext=false)

addFulltextIndex ($a_table, $a_fields, $a_name="in")

dropFulltextIndex ($a_table, $a_name)

Drop fulltext index. More...

isFulltextIndex ($a_table, $a_name)

Is index a fulltext index? More...

getIndexName ($index_name_base)

getSequenceName ($table_name)

constraintName ($a_table, $a_constraint)

Determine contraint name by table name and constraint name. More...

getDSN ()

getDBType ()

setDBType ($type)

lockTables ($tables)

unlockTables ()

in ($field, $values, $negate=false, $type="")

queryF ($query, $types, $values)

manipulateF ($query, $types, $values)

useSlave ($bool)

setLimit ($limit, $offset=0)

Set the Limit for the next Query. More...

like ($column, $type, $value="?", $case_insensitive=true)

now ()

replace ($table, $primaryKeys, $otherColumns)

Replace into method. More...

equals ($columns, $value, $type, $emptyOrNull=false)

getHost ()

setHost ($host)

getDbname ()

setDbname ($dbname)

getCharset ()

setCharset ($charset)

getUsername ()

setUsername ($username)

getPassword ()

setPassword ($password)

getPort ()

setPort ($port)

setDBUser ($user)

setDBPort ($port)

setDBPassword ($password)

setDBHost ($host)

upper ($a_exp)

lower ($a_exp)

substr ($a_exp, $a_pos=1, $a_len=-1)

prepareManip ($query, $types=null)

prepare ($query, $types=null, $result_types=null)

enableResultBuffering ($a_status)

supportsSlave ()

supportsFulltext ()

supportsTransactions ()

supports ($feature)

listTables ()

loadModule ($module)

getAllowedAttributes ()

Returns: array

More...

sequenceExists ($sequence)

listSequences ()

concat (array $values, $allow_null=true)

locate ($a_needle, $a_string, $a_start_pos=1)

modifyTableColumn ($table, $a_column, $a_attributes)

renameTable ($a_name, $a_new_name)

checkTableName ($a_name)

beginTransaction ()

commit ()

rollback ()

dropIndex ($a_table, $a_name="i1")

setStorageEngine ($storage_engine)

getStorageEngine ()

queryCol ($query, $type=PDO::FETCH_ASSOC, $colnum=0)

queryRow ($query, $types=null, $fetchmode=ilDBConstants::FETCHMODE_DEFAULT)

getServerVersion ($native=false)

escape ($value, $escape_wildcards=false)

escapePattern ($text)

migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)

migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)

supportsCollationMigration ()

supportsEngineMigration ()

checkIndexName ($name)

addUniqueConstraint ($table, $fields, $name="con")

dropUniqueConstraint ($a_table, $a_name="con")

dropUniqueConstraintByFields ($a_table, $a_fields)

getLastInsertId ()

buildAtomQuery ()

uniqueConstraintExists ($table, array $fields)

dropPrimaryKey ($table_name)

executeMultiple ($stmt, $a_data)

fromUnixtime ($a_expr, $a_to_text=true)

unixTimestamp ()

autoExecute ($tablename, $fields, $mode=ilDBConstants::AUTOQUERY_INSERT, $where=false)

Generate an insert, update or delete query and call prepare() and execute() on it. More...

getDBVersion ()

sanitizeMB4StringIfNotSupported ($query)

Parameters

$query string to sanitize, all MB4-Characters like emojis will re replaced with ???

Returns: string sanitized query

More...

doesCollationSupportMB4Strings ()

groupConcat ($a_field_name, $a_seperator=",", $a_order=null)

Parameters

string	$a_field_name
string	$a_seperator
string	$a_order

Returns: string

More...

cast ($a_field_name, $a_dest_type)

Parameters

string	$a_field_name
string	$a_dest_type

Returns: string;

More...

primaryExistsByFields (string $table_name, array $fields)

Parameters

string	$table_name
array	$fields

Returns: bool

More...

Public Member Functions inherited from ilDBInterface

fetchAll ($query_result, $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)

substr ($a_exp)

execute ($stmt, $data=array())

free ($a_st)

Data Fields
const	POSTGRE_STD_PORT = 5432

Data Fields inherited from ilDBPdo
const	FEATURE_TRANSACTIONS = 'transactions'

const	FEATURE_FULLTEXT = 'fulltext'

const	FEATURE_SLAVE = 'slave'

Protected Member Functions
	getAdditionalAttributes ()

	appendLimit ($query)

Protected Member Functions inherited from ilDBPdo
	initSQLMode ()

	getAttributes ()

	getAdditionalAttributes ()

	checkTableColumns ($a_cols)

	checkColumn ($a_col, $a_def)

	checkColumnDefinition ($a_def, $a_modify_mode=false)

	appendLimit ($query)

	autoPrepare ($table, $table_fields, $mode=ilDBConstants::AUTOQUERY_INSERT, $where=false, $types=null, $result_types=ilDBConstants::PREPARE_MANIP)

	buildManipSQL ($table, $table_fields, $mode, $where=false)

Protected Attributes
	$port = self::POSTGRE_STD_PORT

	$storage_engine = null

	$manager

Protected Attributes inherited from ilDBPdo
	$host = ''

	$dbname = ''

	$charset = 'utf8'

	$username = ''

	$password = ''

	$port = 3306

	$pdo

	$manager

	$reverse

	$limit = null

	$offset = null

	$storage_engine = 'MyISAM'

	$dsn = ''

	$attributes

	$db_type = ''

	$error_code = 0

	$field_definition

Additional Inherited Members
Static Public Member Functions inherited from ilDBPdo
static	isReservedWord ($a_word)

Static Public Member Functions inherited from ilDBInterface
static	getReservedWords ()
	Get reserved words. More...

Detailed Description

Class ilDBPdoPostgreSQL.

Author: Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 9 of file class.ilDBPdoPostgreSQL.php.

Member Function Documentation

◆ addIndex()

ilDBPdoPostgreSQL::addIndex	(	$table_name,
		$fields,
		$index_name = `''`,
		$fulltext = `false`
	)

Parameters

	$table_name
	$fields
string	$index_name
bool	$fulltext

Returns: bool

Implements ilDBInterface.

Definition at line 431 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e, and constraintName().

     {
         $indices = $this->manager->listTableIndexes($table_name);
         if (in_array($this->constraintName($table_name, $index_name), $indices)) {
             return true;
         }
         try {
             return parent::addIndex($table_name, $fields, $index_name, $fulltext); // TODO: Change the autogenerated stub
         } catch (Exception $e) {
             return true;
         }
     }

Here is the call graph for this function:

◆ addPrimaryKey()

ilDBPdoPostgreSQL::addPrimaryKey	(	$table_name,
		$primary_keys
	)

Parameters

string	$table_name
array	$primary_keys

Returns: bool

Implements ilDBInterface.

Definition at line 417 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e.

     {
         $ilDBAnalyzer = new ilDBAnalyzer($this);
         if ($ilDBAnalyzer->getPrimaryKeyInformation($table_name)) {
             return true;
         }
         try {
             return parent::addPrimaryKey($table_name, $primary_keys); // TODO: Change the autogenerated stub
         } catch (Exception $e) {
             return true;
         }
     }

◆ addUniqueConstraint()

ilDBPdoPostgreSQL::addUniqueConstraint	(	$table,
		$fields,
		$name = `"con"`
	)

Parameters

	$table
	$fields
string	$name

Returns: bool

Implements ilDBPdoInterface.

Definition at line 445 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e, and $name.

     {
         try {
             return parent::addUniqueConstraint($table, $fields, $name); // TODO: Change the autogenerated stub
         } catch (Exception $e) {
             return true;
         }
     }

◆ appendLimit()

ilDBPdoPostgreSQL::appendLimit ( $query )

protected

Parameters

$query

Returns: string

Definition at line 316 of file class.ilDBPdoPostgreSQL.php.

References ilDBPdo\$offset, and $query.

     {
         if ($this->limit !== null && $this->offset !== null) {
             $query .= ' LIMIT ' . (int) $this->limit . ' OFFSET ' . (int) $this->offset;
             $this->limit = null;
             $this->offset = null;
 
             return $query;
         }
 
         return $query;
     }

◆ connect()

ilDBPdoPostgreSQL::connect ( $return_false_for_error = false )

Parameters

bool $return_false_for_error

Returns: bool

Exceptions

Implements ilDBInterface.

Definition at line 41 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e, generateDSN(), ilDBPdo\getAttributes(), ilDBPdo\getDSN(), ilDBPdo\getPassword(), ilDBPdo\getUsername(), and initHelpers().

     {
         $this->generateDSN();
         try {
             $this->pdo = new PDO($this->getDSN(), $this->getUsername(), $this->getPassword(), $this->getAttributes());
             $this->initHelpers();
         } catch (Exception $e) {
             $this->error_code = $e->getCode();
             if ($return_false_for_error) {
                 return false;
             }
             throw $e;
         }
 
         return ($this->pdo->errorCode() == PDO::ERR_NONE);
     }

Here is the call graph for this function:

◆ constraintName()

ilDBPdoPostgreSQL::constraintName	(	$a_table,
		$a_constraint
	)

Parameters

$a_table
$a_constraint

Returns: string

Implements ilDBInterface.

Definition at line 107 of file class.ilDBPdoPostgreSQL.php.

Referenced by addIndex().

     {
         $a_constraint = str_replace($a_table . '_', '', $a_constraint);
 
         return $a_table . '_' . $a_constraint;
     }

Here is the caller graph for this function:

◆ createSequence()

ilDBPdoPostgreSQL::createSequence	(	$table_name,
		$start = `1`
	)

Parameters

	$table_name
int	$start

Returns: bool

Implements ilDBInterface.

Definition at line 378 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e.

     {
         if (in_array($table_name, $this->manager->listSequences())) {
             return true;
         }
         try {
             parent::createSequence($table_name, $start); // TODO: Change the autogenerated stub
         } catch (Exception $e) {
             return true;
         }
     }

◆ createTable()

ilDBPdoPostgreSQL::createTable	(	$table_name,
		$fields,
		$drop_table = `false`,
		$ignore_erros = `false`
	)

Parameters

	$table_name
	$fields
bool	$drop_table
bool	$ignore_erros

Returns: bool|mixed

Exceptions

Implements ilDBInterface.

Definition at line 399 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e, and tableExists().

     {
         if ($this->tableExists($table_name)) {
             return true;
         }
         try {
             return parent::createTable($table_name, $fields, $drop_table, $ignore_erros); // TODO: Change the autogenerated stub
         } catch (Exception $e) {
             return true;
         }
     }

Here is the call graph for this function:

◆ dropPrimaryKey()

ilDBPdoPostgreSQL::dropPrimaryKey ( $table_name )

Parameters

$table_name

Returns: bool

Implements ilDBPdoInterface.

Definition at line 458 of file class.ilDBPdoPostgreSQL.php.

     {
         return $this->manager->dropConstraint($table_name, "pk", true);
     }

◆ dropTable()

ilDBPdoPostgreSQL::dropTable	(	$table_name,
		$error_if_not_existing = `false`
	)

Parameters

	$table_name
bool	$error_if_not_existing

Returns: int

Implements ilDBInterface.

Definition at line 267 of file class.ilDBPdoPostgreSQL.php.

     {
         try {
             $this->pdo->exec("DROP TABLE $table_name");
         } catch (PDOException $PDOException) {
             if ($error_if_not_existing) {
                 throw $PDOException;
             }
 
             return false;
         }
 
         return true;
     }

◆ generateDSN()

ilDBPdoPostgreSQL::generateDSN ( )

Definition at line 26 of file class.ilDBPdoPostgreSQL.php.

References ilDBPdo\getDbname(), ilDBPdo\getHost(), ilDBPdo\getPassword(), ilDBPdo\getPort(), ilDBPdo\getUsername(), and ilDBPdo\setPort().

Referenced by connect().

     {
         if (!$this->getPort()) {
             $this->setPort(self::POSTGRE_STD_PORT);
         }
         $this->dsn = 'pgsql:host=' . $this->getHost() . ';port=' . $this->getPort() . ';dbname=' . $this->getDbname() . ';user='
                      . $this->getUsername() . ';password=' . $this->getPassword() . '';
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAdditionalAttributes()

ilDBPdoPostgreSQL::getAdditionalAttributes ( )

protected

Definition at line 59 of file class.ilDBPdoPostgreSQL.php.

     {
         return array(
             PDO::ATTR_EMULATE_PREPARES => true,
         );
     }

◆ getIndexName()

ilDBPdoPostgreSQL::getIndexName ( $index_name_base )

Parameters

$index_name_base

Returns: string

Definition at line 119 of file class.ilDBPdoPostgreSQL.php.

     {
         return parent::getIndexName($index_name_base); // TODO: Change the autogenerated stub
     }

◆ getPrimaryKeyIdentifier()

ilDBPdoPostgreSQL::getPrimaryKeyIdentifier ( )

Primary key identifier.

Implements ilDBInterface.

Definition at line 78 of file class.ilDBPdoPostgreSQL.php.

     {
         return "pk";
     }

◆ getStorageEngine()

ilDBPdoPostgreSQL::getStorageEngine ( )

Returns: string

Implements ilDBInterface.

Definition at line 231 of file class.ilDBPdoPostgreSQL.php.

     {
         return null;
     }

◆ initHelpers()

ilDBPdoPostgreSQL::initHelpers ( )

Definition at line 67 of file class.ilDBPdoPostgreSQL.php.

Referenced by connect().

     {
         $this->manager = new ilDBPdoManagerPostgres($this->pdo, $this);
         $this->reverse = new ilDBPdoReversePostgres($this->pdo, $this);
         $this->field_definition = new ilDBPdoPostgresFieldDefinition($this);
     }

Here is the caller graph for this function:

◆ lockTables()

ilDBPdoPostgreSQL::lockTables ( $a_tables )

Parameters

array $a_tables

Deprecated:: Use ilAtomQuery instead

Returns: bool

Implements ilDBInterface.

Definition at line 188 of file class.ilDBPdoPostgreSQL.php.

References ilDBPdo\beginTransaction(), ilDBConstants\LOCK_READ, ilDBConstants\LOCK_WRITE, and ilDBPdo\query().

     {
         $locks = array();
 
         $counter = 0;
         foreach ($a_tables as $table) {
             if (!isset($table['sequence']) && $table['sequence']) {
                 $lock = 'LOCK TABLE ' . $table['name'];
 
                 switch ($table['type']) {
                     case ilDBConstants::LOCK_READ:
                         $lock .= ' IN SHARE MODE ';
                         break;
 
                     case ilDBConstants::LOCK_WRITE:
                         $lock .= ' IN EXCLUSIVE MODE ';
                         break;
                 }
 
                 $locks[] = $lock;
             }
         }
 
         // @TODO use and store a unique identifier to allow nested lock/unlocks
         $this->beginTransaction();
         foreach ($locks as $lock) {
             $this->query($lock);
         }
 
         return true;
     }

Here is the call graph for this function:

◆ nextId()

ilDBPdoPostgreSQL::nextId ( $table_name )

Parameters

string $table_name

Returns: mixed

Exceptions

Implements ilDBInterface.

Definition at line 251 of file class.ilDBPdoPostgreSQL.php.

References $data, $query, $result, and ilDBPdo\query().

     {
         $sequence_name = $table_name . '_seq';
         $query = "SELECT NEXTVAL('$sequence_name')";
         $result = $this->query($query, 'integer');
         $data = $result->fetchObject();
 
         return $data->nextval;
     }

Here is the call graph for this function:

◆ quoteIdentifier()

ilDBPdoPostgreSQL::quoteIdentifier	(	$identifier,
		$check_option = `false`
	)

Parameters

	$identifier
bool	$check_option

Returns: mixed

Implements ilDBInterface.

Definition at line 288 of file class.ilDBPdoPostgreSQL.php.

     {
         return '"' . $identifier . '"';
     }

◆ renameTable()

ilDBPdoPostgreSQL::renameTable	(	$a_name,
		$a_new_name
	)

Parameters

$a_name
$a_new_name

Returns: bool

Exceptions

Implements ilDBInterface.

Definition at line 348 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$e, ilDBPdo\checkTableName(), ilDBPdo\getSequenceName(), ilDBPdo\sequenceExists(), and tableExists().

     {
         // check table name
         try {
             $this->checkTableName($a_new_name);
         } catch (ilDatabaseException $e) {
             return true;
         }
 
         if ($this->tableExists($a_new_name)) {
             return true;
         }
         try {
             $this->manager->alterTable($a_name, [ "name" => $a_new_name ], false);
             if ($this->sequenceExists($a_name)) {
                 $this->manager->alterTable($this->getSequenceName($a_name), [ "name" => $this->getSequenceName($a_new_name) ], false);
             }
         } catch (Exception $e) {
             return true;
         }
 
         return true;
     }

Here is the call graph for this function:

◆ replace()

ilDBPdoPostgreSQL::replace	(	$a_table,
		$a_pk_columns,
		$a_other_columns
	)

Parameters

$a_table
$a_pk_columns
$a_other_columns

Returns: bool

Exceptions

Implements ilDBInterface.

Definition at line 132 of file class.ilDBPdoPostgreSQL.php.

References Vendor\Package\$a, Vendor\Package\$b, ilDBPdo\insert(), ilDBPdo\manipulate(), and ilDBPdo\quote().

     {
         $a_columns = array_merge($a_pk_columns, $a_other_columns);
         $fields = array();
         $field_values = array();
         $placeholders = array();
         $types = array();
         $values = array();
         $lobs = false;
         $lob = array();
         $val_field = array();
         $a = array();
         $b = array();
         foreach ($a_columns as $k => $col) {
             if ($col[0] == 'clob' or $col[0] == 'blob') {
                 $val_field[] = $this->quote($col[1], 'text') . " " . $k;
             } else {
                 $val_field[] = $this->quote($col[1], $col[0]) . " " . $k;
             }
             $fields[] = $k;
             $placeholders[] = "%s";
             $placeholders2[] = ":$k";
             $types[] = $col[0];
             $values[] = $col[1];
             $field_values[$k] = $col[1];
             if ($col[0] == "blob" || $col[0] == "clob") {
                 $lobs = true;
                 $lob[$k] = $k;
             }
             $a[] = "a." . $k;
             $b[] = "b." . $k;
         }
         $abpk = array();
         $aboc = array();
         $delwhere = array();
         foreach ($a_pk_columns as $k => $col) {
             $abpk[] = "a." . $k . " = b." . $k;
             $delwhere[] = $k . " = " . $this->quote($col[1], $col[0]);
         }
         foreach ($a_other_columns as $k => $col) {
             $aboc[] = "a." . $k . " = b." . $k;
         }
         //              if ($lobs)      // lobs -> use prepare execute (autoexecute broken in PEAR 2.4.1)
         //              {
         $this->manipulate("DELETE FROM " . $a_table . " WHERE " . implode(" AND ", $delwhere));
         $this->insert($a_table, $a_columns);
 
         return true;
     }

Here is the call graph for this function:

◆ setStorageEngine()

ilDBPdoPostgreSQL::setStorageEngine ( $storage_engine )

Parameters

$storage_engine

Implements ilDBInterface.

Definition at line 237 of file class.ilDBPdoPostgreSQL.php.

     {
         return false;
     }

◆ supportsFulltext()

ilDBPdoPostgreSQL::supportsFulltext ( )

Returns: bool

Implements ilDBInterface.

Definition at line 87 of file class.ilDBPdoPostgreSQL.php.

     {
         return false;
     }

◆ supportsTransactions()

ilDBPdoPostgreSQL::supportsTransactions ( )

Returns: bool

Implements ilDBInterface.

Definition at line 96 of file class.ilDBPdoPostgreSQL.php.

     {
         return true;
     }

◆ tableColumnExists()

ilDBPdoPostgreSQL::tableColumnExists	(	$table_name,
		$column_name
	)

Parameters

$table_name	string
$column_name	string

Returns: bool

Implements ilDBInterface.

Definition at line 336 of file class.ilDBPdoPostgreSQL.php.

     {
         return in_array($column_name, $this->manager->listTableFields($table_name));
     }

◆ tableExists()

ilDBPdoPostgreSQL::tableExists ( $table_name )

Parameters

string $table_name

Returns: bool

Implements ilDBInterface.

Definition at line 298 of file class.ilDBPdoPostgreSQL.php.

References ilDBPdo\listTables().

Referenced by createTable(), and renameTable().

     {
         $tables = $this->listTables();
 
         if (is_array($tables)) {
             if (in_array($table_name, $tables)) {
                 return true;
             }
         }
 
         return false;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ unlockTables()

ilDBPdoPostgreSQL::unlockTables ( )

Exceptions

Implements ilDBInterface.

Definition at line 225 of file class.ilDBPdoPostgreSQL.php.

References ilDBPdo\commit().

     {
         $this->commit();
     }

Here is the call graph for this function:

Field Documentation

◆ $manager

ilDBPdoPostgreSQL::$manager

protected

Definition at line 23 of file class.ilDBPdoPostgreSQL.php.

◆ $port

ilDBPdoPostgreSQL::$port = self::POSTGRE_STD_PORT

protected

Definition at line 15 of file class.ilDBPdoPostgreSQL.php.

◆ $storage_engine

ilDBPdoPostgreSQL::$storage_engine = null

protected

Definition at line 19 of file class.ilDBPdoPostgreSQL.php.

◆ POSTGRE_STD_PORT

const ilDBPdoPostgreSQL::POSTGRE_STD_PORT = 5432

Definition at line 11 of file class.ilDBPdoPostgreSQL.php.

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

Services/Database/classes/PDO/class.ilDBPdoPostgreSQL.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ addIndex()

◆ addPrimaryKey()

◆ addUniqueConstraint()

◆ appendLimit()

◆ connect()

◆ constraintName()

◆ createSequence()

◆ createTable()

◆ dropPrimaryKey()

◆ dropTable()

◆ generateDSN()

◆ getAdditionalAttributes()

◆ getIndexName()

◆ getPrimaryKeyIdentifier()

◆ getStorageEngine()

◆ initHelpers()

◆ lockTables()

◆ nextId()

◆ quoteIdentifier()

◆ renameTable()

◆ replace()

◆ setStorageEngine()

◆ supportsFulltext()

◆ supportsTransactions()

◆ tableColumnExists()

◆ tableExists()

◆ unlockTables()

Field Documentation

◆ $manager

◆ $port

◆ $storage_engine

◆ POSTGRE_STD_PORT