Database independent query interface This is a wrapper for the PHP PDO

Located in /lib/Roundcube/rcube_db_pgsql.php (line 27)

rcube_db
   |
   --rcube_db_pgsql

mixed $db_provider = 'postgres' (line 29)

• access: public

---

Redefinition of:

rcube_db::$db_provider

Inherited Variables

Inherited from rcube_db

rcube_db::$conn_failure
rcube_db::$dbh
rcube_db::$db_connected
rcube_db::$db_dsnr
rcube_db::$db_dsnw
rcube_db::$db_error
rcube_db::$db_error_msg
rcube_db::$db_index
rcube_db::$db_mode
rcube_db::$last_result
rcube_db::$options
rcube_db::$tables
rcube_db::$variables

get_variable (line 112)

Get database runtime variables

• return: Variable value or default
• access: public

mixed get_variable (string $varname, [mixed $default = null])

• string $varname: Variable name
• mixed $default: Default value if variable is not set

---

Redefinition of:

rcube_db::get_variable()

Get database runtime variables

ilike (line 99)

Return SQL statement for case insensitive LIKE

• return: SQL statement to use in query
• access: public

string ilike (string $column, string $value)

• string $column: Field name
• string $value: Search value

---

Redefinition of:

rcube_db::ilike()

Return SQL statement for case insensitive LIKE

insert_id (line 38)

Get last inserted record ID

• return: ID or false on failure
• access: public

mixed insert_id ([string $table = null])

• string $table: Table name (to find the incremented sequence)

---

Redefinition of:

rcube_db::insert_id()

Get last inserted record ID

sequence_name (line 60)

Return correct name for a specific database sequence

• return: Translated sequence name
• access: protected

string sequence_name (string $table)

• string $table: Table name

unixtimestamp (line 86)

Return SQL statement to convert a field value into a unix timestamp

This method is deprecated and should not be used anymore due to limitations of timestamp functions in Mysql (year 2038 problem)

• return: SQL statement to use in query
• deprecated:
• access: public

string unixtimestamp (string $field)

• string $field: Field name

---

Redefinition of:

rcube_db::unixtimestamp()

Return SQL statement to convert a field value into a unix timestamp

Inherited Methods

Inherited From rcube_db

rcube_db::__construct()
rcube_db::affected_rows()
rcube_db::array2list()
rcube_db::concat()
rcube_db::conn_configure()
rcube_db::conn_prepare()
rcube_db::db_connect()
rcube_db::debug()
rcube_db::decode()
rcube_db::dsn_connect()
rcube_db::dsn_options()
rcube_db::dsn_string()
rcube_db::encode()
rcube_db::escape()
rcube_db::escapeSimple()
rcube_db::factory()
rcube_db::fetch_array()
rcube_db::fetch_assoc()
rcube_db::fromunixtime()
rcube_db::get_variable()
rcube_db::ilike()
rcube_db::init()
rcube_db::insert_id()
rcube_db::is_connected()
rcube_db::is_error()
rcube_db::is_replicated()
rcube_db::limitquery()
rcube_db::list_cols()
rcube_db::list_tables()
rcube_db::now()
rcube_db::num_rows()
rcube_db::parse_dsn()
rcube_db::query()
rcube_db::quote()
rcube_db::quoteIdentifier()
rcube_db::quote_identifier()
rcube_db::set_charset()
rcube_db::set_debug()
rcube_db::set_limit()
rcube_db::table_name()
rcube_db::unixtimestamp()
rcube_db::_fetch_row()
rcube_db::_query()