Class Phalcon\Db\Dialect\Postgresql¶
extends abstract class Phalcon\Db\Dialect
implements Phalcon\Db\DialectInterface
Generates database specific SQL for the PostgreSQL RDBMS
Methods¶
public getColumnDefinition (unknown $column)
Gets the column name in PostgreSQL
public addColumn (unknown $tableName, unknown $schemaName, unknown $column)
Generates SQL to add a column to a table
public modifyColumn (unknown $tableName, unknown $schemaName, unknown $column, [unknown $currentColumn])
Generates SQL to modify a column in a table
public dropColumn (unknown $tableName, unknown $schemaName, unknown $columnName)
Generates SQL to delete a column from a table
public addIndex (unknown $tableName, unknown $schemaName, unknown $index)
Generates SQL to add an index to a table
public dropIndex (unknown $tableName, unknown $schemaName, unknown $indexName)
Generates SQL to delete an index from a table
public addPrimaryKey (unknown $tableName, unknown $schemaName, unknown $index)
Generates SQL to add the primary key to a table
public dropPrimaryKey (unknown $tableName, unknown $schemaName)
Generates SQL to delete primary key from a table
public addForeignKey (unknown $tableName, unknown $schemaName, unknown $reference)
Generates SQL to add an index to a table
public dropForeignKey (unknown $tableName, unknown $schemaName, unknown $referenceName)
Generates SQL to delete a foreign key from a table
public createTable (unknown $tableName, unknown $schemaName, unknown $definition)
Generates SQL to create a table
public dropTable (unknown $tableName, [unknown $schemaName], [unknown $ifExists])
Generates SQL to drop a view
public createView (unknown $viewName, unknown $definition, [unknown $schemaName])
Generates SQL to create a view
public dropView (unknown $viewName, [unknown $schemaName], [unknown $ifExists])
Generates SQL to drop a view
public tableExists (unknown $tableName, [unknown $schemaName])
Generates SQL checking for the existence of a schema.table
<?php
echo $dialect->tableExists("posts", "blog");
echo $dialect->tableExists("posts");
public viewExists (unknown $viewName, [unknown $schemaName])
Generates SQL checking for the existence of a schema.view
public describeColumns (unknown $table, [unknown $schema])
Generates SQL describing a table
<?php
print_r($dialect->describeColumns("posts"));
public listTables ([unknown $schemaName])
List all tables in database
<?php
print_r($dialect->listTables("blog"))
public string listViews ([string $schemaName])
Generates the SQL to list all views of a schema or user
public describeIndexes (unknown $table, [unknown $schema])
Generates SQL to query indexes on a table
public describeReferences (unknown $table, [unknown $schema])
Generates SQL to query foreign keys on a table
public tableOptions (unknown $table, [unknown $schema])
Generates the SQL to describe the table creation options
protected _getTableOptions (unknown $definition)
...
public registerCustomFunction (unknown $name, unknown $customFunction) inherited from Phalcon\Db\Dialect
Registers custom SQL functions
public getCustomFunctions () inherited from Phalcon\Db\Dialect
Returns registered functions
final public escape (unknown $str, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Escape identifiers
public limit (unknown $sqlQuery, unknown $number) inherited from Phalcon\Db\Dialect
Generates the SQL for LIMIT clause
<?php
$sql = $dialect->limit('SELECT * FROM robots', 10);
echo $sql; // SELECT * FROM robots LIMIT 10
$sql = $dialect->limit('SELECT * FROM robots', [10, 50]);
echo $sql; // SELECT * FROM robots LIMIT 10 OFFSET 50
public forUpdate (unknown $sqlQuery) inherited from Phalcon\Db\Dialect
Returns a SQL modified with a FOR UPDATE clause
<?php
$sql = $dialect->forUpdate('SELECT * FROM robots');
echo $sql; // SELECT * FROM robots FOR UPDATE
public sharedLock (unknown $sqlQuery) inherited from Phalcon\Db\Dialect
Returns a SQL modified with a LOCK IN SHARE MODE clause
<?php
$sql = $dialect->sharedLock('SELECT * FROM robots');
echo $sql; // SELECT * FROM robots LOCK IN SHARE MODE
final public getColumnList (unknown $columnList, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Gets a list of columns with escaped identifiers
<?php
echo $dialect->getColumnList(array('column1', 'column'));
final public getSqlColumn (unknown $column, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve Column expressions
public getSqlExpression (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Transforms an intermediate representation for a expression into a database system valid expression
final public getSqlTable (unknown $table, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Transform an intermediate representation of a schema/table into a database system valid expression
public select (unknown $definition) inherited from Phalcon\Db\Dialect
Builds a SELECT statement
public supportsSavepoints () inherited from Phalcon\Db\Dialect
Checks whether the platform supports savepoints
public supportsReleaseSavepoints () inherited from Phalcon\Db\Dialect
Checks whether the platform supports releasing savepoints.
public createSavepoint (unknown $name) inherited from Phalcon\Db\Dialect
Generate SQL to create a new savepoint
public releaseSavepoint (unknown $name) inherited from Phalcon\Db\Dialect
Generate SQL to release a savepoint
public rollbackSavepoint (unknown $name) inherited from Phalcon\Db\Dialect
Generate SQL to rollback a savepoint
final protected getSqlExpressionScalar (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve Column expressions
final protected getSqlExpressionObject (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve object expressions
final protected getSqlExpressionQualified (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Resolve qualified expressions
final protected getSqlExpressionBinaryOperations (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve binary operations expressions
final protected getSqlExpressionUnaryOperations (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve unary operations expressions
final protected getSqlExpressionFunctionCall (unknown $expression, unknown $escapeChar, [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve function calls
final protected getSqlExpressionList (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve Lists
final protected getSqlExpressionAll (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Resolve *
final protected getSqlExpressionCastValue (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve CAST of values
final protected getSqlExpressionConvertValue (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve CONVERT of values encodings
final protected getSqlExpressionCase (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve CASE expressions
final protected getSqlExpressionFrom (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Resolve a FROM clause
final protected getSqlExpressionJoins (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a JOINs clause
final protected getSqlExpressionWhere (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a WHERE clause
final protected getSqlExpressionGroupBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a GROUP BY clause
final protected getSqlExpressionHaving (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a HAVING clause
final protected getSqlExpressionOrderBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a ORDER BY clause
final protected getSqlExpressionLimit (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect
Resolve a LIMIT clause
protected prepareColumnAlias (unknown $qualified, [unknown $alias], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Prepares column for this RDBMS
protected prepareTable (unknown $table, [unknown $schema], [unknown $alias], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Prepares table for this RDBMS
protected prepareQualified (unknown $column, [unknown $domain], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect
Prepares qualified for this RDBMS