Class Phalcon\Db\Dialect\Postgresql

extends abstract class Phalcon\Db\Dialect

implements Phalcon\Db\DialectInterface

Generates database specific SQL for the PostgreSQL RBDMS

Methods

public string getColumnDefinition (Phalcon\Db\ColumnInterface $column)

Gets the column name in PostgreSQL

public string addColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column)

Generates SQL to add a column to a table

public string modifyColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column)

Generates SQL to modify a column in a table

public string dropColumn (string $tableName, string $schemaName, string $columnName)

Generates SQL to delete a column from a table

public string addIndex (string $tableName, string $schemaName, Phalcon\Db\Index $index)

Generates SQL to add an index to a table

public string dropIndex (string $tableName, string $schemaName, string $indexName)

Generates SQL to delete an index from a table

public string addPrimaryKey (string $tableName, string $schemaName, Phalcon\Db\Index $index)

Generates SQL to add the primary key to a table

public string dropPrimaryKey (string $tableName, string $schemaName)

Generates SQL to delete primary key from a table

public string addForeignKey (string $tableName, string $schemaName, Phalcon\Db\ReferenceInterface $reference)

Generates SQL to add an index to a table

public string dropForeignKey (string $tableName, string $schemaName, string $referenceName)

Generates SQL to delete a foreign key from a table

protected array _getTableOptions ()

Generates SQL to add the table creation options

public string createTable (string $tableName, string $schemaName, array $definition)

Generates SQL to create a table in PostgreSQL

public boolean dropTable (string $tableName, string $schemaName)

Generates SQL to drop a table

public string createView (string $viewName, array $definition, string $schemaName)

Generates SQL to create a view

public string dropView (string $viewName, string $schemaName, [boolean $ifExists])

Generates SQL to drop a view

public string tableExists (string $tableName, [string $schemaName])

Generates SQL checking for the existence of a schema.table <code>echo $dialect->tableExists(“posts”, “blog”) <code>echo $dialect->tableExists(“posts”)

public string viewExists (string $viewName, [string $schemaName])

Generates SQL checking for the existence of a schema.view

public string describeColumns (string $table, [string $schema])

Generates a SQL describing a table <code>print_r($dialect->describeColumns(“posts”) ?>

public array listTables ([string $schemaName])

List all tables on database

<?php

print_r($dialect->listTables("blog")) ?>

public array listViews ([string $schemaName])

Generates the SQL to list all views of a schema or user

public string describeIndexes (string $table, [string $schema])

Generates SQL to query indexes on a table

public string describeReferences (string $table, [string $schema])

Generates SQL to query foreign keys on a table

public string tableOptions (string $table, [string $schema])

Generates the SQL to describe the table creation options

public string limit (string $sqlQuery, int $number) inherited from Phalcon\Db\Dialect

Generates the SQL for LIMIT clause

$sql = $dialect->limit('SELECT * FROM robots', 10);
 echo $sql; // SELECT * FROM robots LIMIT 10

public string forUpdate (string $sqlQuery) inherited from Phalcon\Db\Dialect

Returns a SQL modified with a FOR UPDATE clause

$sql = $dialect->forUpdate('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots FOR UPDATE

public string sharedLock (string $sqlQuery) inherited from Phalcon\Db\Dialect

Returns a SQL modified with a LOCK IN SHARE MODE clause

$sql = $dialect->sharedLock('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots LOCK IN SHARE MODE

public string getColumnList (array $columnList) inherited from Phalcon\Db\Dialect

Gets a list of columns with escaped identifiers

echo $dialect->getColumnList(array('column1', 'column'));

public string getSqlExpression (array $expression, [string $escapeChar]) inherited from Phalcon\Db\Dialect

Transforms an intermediate representation for a expression into a database system valid expression

public string getSqlTable (array $table, [string $escapeChar]) inherited from Phalcon\Db\Dialect

Transform an intermediate representation for a schema/table into a database system valid expression

public string select (array $definition) inherited from Phalcon\Db\Dialect

Builds a SELECT statement

public boolean supportsSavepoints () inherited from Phalcon\Db\Dialect

Checks whether the platform supports savepoints

public boolean supportsReleaseSavepoints () inherited from Phalcon\Db\Dialect

Checks whether the platform supports releasing savepoints.

public string createSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to create a new savepoint

public string releaseSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to release a savepoint

public string rollbackSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to rollback a savepoint