Db\Dialect\Postgresql::listViews

public string listViews ([string $schemaName]) Generates the SQL to list all views of a schema or user

Db\Dialect\Postgresql::listTables

public listTables ([mixed $schemaName]) List all tables in database print_r($dialect->listTables("blog"))

Db\Dialect\Postgresql::describeReferences

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

Db\Dialect\Postgresql::createTable

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

Db\Dialect\Postgresql::createView

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

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::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::dropColumn

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

Db\Dialect\Postgresql::addIndex

public addIndex (mixed $tableName, mixed $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add an index to a table