Db\Dialect\Postgresql::dropPrimaryKey

public dropPrimaryKey (mixed $tableName, mixed $schemaName) Generates SQL to delete primary key from a table

Db\Dialect\Postgresql::dropIndex

public dropIndex (mixed $tableName, mixed $schemaName, mixed $indexName) Generates SQL to delete an index from a table

Db\Dialect\Postgresql::dropForeignKey

public dropForeignKey (mixed $tableName, mixed $schemaName, mixed $referenceName) Generates SQL to delete a foreign key from a table

Db\Dialect\Postgresql::dropColumn

public dropColumn (mixed $tableName, mixed $schemaName, mixed $columnName) Generates SQL to delete a column from a table

Db\Dialect\Postgresql::describeReferences

public describeReferences (mixed $table, [mixed $schema]) Generates SQL to query foreign keys on a table

Db\Dialect\Postgresql::describeIndexes

public describeIndexes (mixed $table, [mixed $schema]) Generates SQL to query indexes on a table

Db\Dialect\Postgresql::describeColumns

public describeColumns (mixed $table, [mixed $schema]) Generates SQL describing a table print_r($dialect->describeColumns("posts"));

Db\Dialect\Postgresql::createView

public createView (mixed $viewName, array $definition, [mixed $schemaName]) Generates SQL to create a view

Db\Dialect\Postgresql::createTable

public createTable (mixed $tableName, mixed $schemaName, array $definition) Generates SQL to create a table

Db\Dialect\Postgresql::addPrimaryKey

public addPrimaryKey (mixed $tableName, mixed $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add the primary key to a table