Db\Dialect\Sqlite

extends abstract class Phalcon\Db\Dialect implements Phalcon\Db\DialectInterface Source on GitHub Generates database specific SQL for the Sqlite RDBMS Methods public getColumnDefinition (Phalcon\Db\ColumnInterface $column) Gets the column name in SQLite public addColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column) Generates SQL to add a column to a table public modifyColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnI

Db\Dialect\Postgresql::viewExists

public viewExists (mixed $viewName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.view

Db\Dialect\Postgresql::tableOptions

public tableOptions (mixed $table, [mixed $schema]) Generates the SQL to describe the table creation options

Db\Dialect\Postgresql::tableExists

public tableExists (mixed $tableName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.table echo $dialect->tableExists("posts", "blog"); echo $dialect->tableExists("posts");

Db\Dialect\Postgresql::modifyColumn

public modifyColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnInterface $currentColumn]) Generates SQL to modify a column in a table

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

public getColumnDefinition (Phalcon\Db\ColumnInterface $column) Gets the column name in PostgreSQL

Db\Dialect\Postgresql::dropView

public dropView (mixed $viewName, [mixed $schemaName], [mixed $ifExists]) Generates SQL to drop a view

Db\Dialect\Postgresql::dropTable

public dropTable (mixed $tableName, [mixed $schemaName], [mixed $ifExists]) Generates SQL to drop a view