createQueryBuilder() public method Creates a query builder for the PostgreSQL database. public yii\db\pgsql\QueryBuilder createQueryBuilder ( )return yii\db\pgsql\QueryBuilder Query builder instance

$viewNames public read-only property All view names in the database. public string[] getViewNames ( $schema = '', $refresh = false )

$typeMap public property Mapping from physical column types (keys) to abstract column types (values) See also http://www.postgresql.org/docs/current/static/datatype.html#DATATYPE-TABLE. public array $typeMap = ['bit' => self::TYPE_INTEGER, 'bit varying' => self::TYPE_INTEGER, 'varbit' => self::TYPE_INTEGER, 'bool' => self::TYPE_BOOLEAN, 'boolean' => self::TYPE_BOOLEAN, 'box' => self::TYPE_STRING, 'circle' => self::TYPE_STRING, 'point' => self::TYPE_STRING, 'line' =&

$defaultSchema public property The default schema used for the current session. public string $defaultSchema = 'public'

update() public method Creates an UPDATE SQL statement. For example, $params = []; $sql = $queryBuilder->update('user', ['status' => 1], 'age > 30', $params); The method will properly escape the table and column names. public string update ( $table, $columns, $condition, &$params )$table string The table to be updated. $columns array The column data (name => value) to be updated. $condition array|string The condition that will be put in the WHERE part. Please refer

resetSequence() public method Creates a SQL statement for resetting the sequence value of a table's primary key. The sequence will be reset such that the primary key of the next new row inserted will have the specified value or 1. public string resetSequence ( $tableName, $value = null )$tableName string The name of the table whose primary key sequence will be reset $value mixed The value for the primary key of the next new row inserted. If this is not set, the next new row's primary k

renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $oldName, $newName )$oldName string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return string The SQL statement for renaming a DB table.

insert() public method Creates an INSERT SQL statement. For example, $sql = $queryBuilder->insert('user', [ 'name' => 'Sam', 'age' => 30, ], $params); The method will properly escape the table and column names. public string insert ( $table, $columns, &$params )$table string The table that new rows will be inserted into. $columns array The column data (name => value) to be inserted into the table. $params array The binding parameters that will be generated by

dropIndex() public method Builds a SQL statement for dropping an index. public string dropIndex ( $name, $table )$name string The name of the index to be dropped. The name will be properly quoted by the method. $table string The table whose index is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping an index.

createIndex() public method Builds a SQL statement for creating a new index. See also http://www.postgresql.org/docs/8.2/static/sql-createindex.html. public string createIndex ( $name, $table, $columns, $unique = false )$name string The name of the index. The name will be properly quoted by the method. $table string The table that the new index will be created for. The table name will be properly quoted by the method. $columns string|array The column(s) that should be included in t