public getDefaultIdValue () Returns the default identity value to be inserted in an identity column //Inserting a new robot with a valid default value for the column 'id' $success = $connection->insert( "robots", array($connection->getDefaultIdValue(), "Astro Boy", 1952), array("id", "name", "year") );

public describeColumns (mixed $table, [mixed $schema]) Returns an array of Phalcon\Db\Column objects describing a table print_r($connection->describeColumns("posts"));

public createTable (mixed $tableName, mixed $schemaName, array $definition) Creates a table

public connect ([array $descriptor]) This method is automatically called in Phalcon\Db\Adapter\Pdo constructor. Call it when you need to restore a database connection.

extends abstract class Phalcon\Db\Adapter\Pdo implements Phalcon\Events\EventsAwareInterface, Phalcon\Db\AdapterInterface Source on GitHub Specific functions for the Postgresql database system use Phalcon\Db\Adapter\Pdo\Postgresql; $config = [ 'host' => 'localhost', 'dbname' => 'blog', 'port' => 5432, 'username' => 'postgres', 'password' => 'secret' ]; $connection = new Postgresql($config); Methods public connect ([array $descriptor]) This method is

public escapeIdentifier (mixed $identifier) Escapes a column/table/schema name echo $connection->escapeIdentifier('my_table'); // `my_table` echo $connection->escapeIdentifier(['companies', 'name']); // `companies`.`name` @param string|array identifier

public describeReferences (mixed $table, [mixed $schema]) Lists table references print_r($connection->describeReferences('robots_parts'));

public Phalcon\Db\IndexInterface[] describeIndexes (string $table, [string $schema]) Lists table indexes print_r($connection->describeIndexes('robots_parts'));

public describeColumns (mixed $table, [mixed $schema]) Returns an array of Phalcon\Db\Column objects describing a table print_r($connection->describeColumns("posts"));

extends abstract class Phalcon\Db\Adapter\Pdo implements Phalcon\Events\EventsAwareInterface, Phalcon\Db\AdapterInterface Source on GitHub Specific functions for the Mysql database system use Phalcon\Db\Adapter\Pdo\Mysql; $config = [ 'host' => 'localhost', 'dbname' => 'blog', 'port' => 3306, 'username' => 'sigma', 'password' => 'secret' ]; $connection = new Mysql($config); Methods public escapeIdentifier (mixed $identifier) Escapes a column/table/sc