Namespaces

  • Latte
    • Loaders
    • Macros
    • Runtime
  • Nette
    • Application
      • Responses
      • Routers
      • UI
    • Bridges
      • ApplicationLatte
      • ApplicationTracy
      • CacheLatte
      • DatabaseDI
      • DatabaseTracy
      • DITracy
      • FormsLatte
      • Framework
      • HttpTracy
      • SecurityTracy
    • Caching
      • Storages
    • ComponentModel
    • Database
      • Drivers
      • Reflection
      • Table
    • DI
      • Config
        • Adapters
      • Extensions
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
    • Iterators
    • Latte
    • Loaders
    • Localization
    • Mail
    • Neon
    • PhpGenerator
    • Reflection
    • Security
    • Templating
    • Utils
  • NetteModule
  • none
  • Tracy

Classes

  • MsSqlDriver
  • MySqlDriver
  • OciDriver
  • OdbcDriver
  • PgSqlDriver
  • Sqlite2Driver
  • SqliteDriver
  • SqlsrvDriver
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Other releases
  • Nette homepage

Class PgSqlDriver

Supplemental PostgreSQL database driver.

Nette\Object
Extended by Nette\Database\Drivers\PgSqlDriver implements Nette\Database\ISupplementalDriver
Namespace: Nette\Database\Drivers
Author: David Grudl
Located at Database/Drivers/PgSqlDriver.php
Methods summary
public
# __construct( Nette\Database\Connection $connection, array $options )
public string
# delimite( string $name )

Delimites identifier for use in a SQL statement.

Delimites identifier for use in a SQL statement.

Parameters

$name
string

Returns

string

Implementation of

Nette\Database\ISupplementalDriver::delimite()
public mixed
# formatBool( boolean $value )

Formats boolean for use in a SQL statement.

Formats boolean for use in a SQL statement.

Parameters

$value
boolean

Returns

mixed

Implementation of

Nette\Database\ISupplementalDriver::formatBool()
public string
# formatDateTime( $value )

Formats date-time for use in a SQL statement.

Formats date-time for use in a SQL statement.

Returns

string

Implementation of

Nette\Database\ISupplementalDriver::formatDateTime()
public string
# formatLike( string $value, integer $pos )

Encodes string for use in a LIKE statement.

Encodes string for use in a LIKE statement.

Parameters

$value
string
$pos
integer

Returns

string

Implementation of

Nette\Database\ISupplementalDriver::formatLike()
public
# applyLimit( string & $sql, integer $limit, integer $offset )

Injects LIMIT/OFFSET to the SQL query.

Injects LIMIT/OFFSET to the SQL query.

Parameters

$sql
string
SQL query that will be modified.
$limit
integer
$offset
integer

Implementation of

Nette\Database\ISupplementalDriver::applyLimit()
public array
# normalizeRow( array $row )

Normalizes result row.

Normalizes result row.

Parameters

$row
array

Returns

array

Implementation of

Nette\Database\ISupplementalDriver::normalizeRow()
public array
# getTables( )

Returns list of tables.

Returns list of tables.

Returns

array
of [name [, (bool) view]]

Implementation of

Nette\Database\ISupplementalDriver::getTables()
public array
# getColumns( string $table )

Returns metadata for all columns in a table.

Returns metadata for all columns in a table.

Parameters

$table
string

Returns

array
of [name, nativetype, primary [, table, fullname, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (array) vendor]]

Implementation of

Nette\Database\ISupplementalDriver::getColumns()
public array
# getIndexes( string $table )

Returns metadata for all indexes in a table.

Returns metadata for all indexes in a table.

Parameters

$table
string

Returns

array
of [name, (array of names) columns [, (bool) unique, (bool) primary]]

Implementation of

Nette\Database\ISupplementalDriver::getIndexes()
public array
# getForeignKeys( string $table )

Returns metadata for all foreign keys in a table.

Returns metadata for all foreign keys in a table.

Parameters

$table
string

Returns

array

Implementation of

Nette\Database\ISupplementalDriver::getForeignKeys()
public array
# getColumnTypes( PDOStatement $statement )

Returns associative array of detected types (IReflection::FIELD_*) in result set.

Returns associative array of detected types (IReflection::FIELD_*) in result set.

Parameters

$statement
PDOStatement

Returns

array

Implementation of

Nette\Database\ISupplementalDriver::getColumnTypes()
public boolean
# isSupported( string $item )

Parameters

$item
string

Returns

boolean

Implementation of

Nette\Database\ISupplementalDriver::isSupported()
Methods inherited from Nette\Object
__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()
Constants inherited from Nette\Database\ISupplementalDriver
SUPPORT_MULTI_COLUMN_AS_OR_COND, SUPPORT_MULTI_INSERT_AS_SELECT, SUPPORT_SELECT_UNGROUPED_COLUMNS, SUPPORT_SEQUENCE, SUPPORT_SUBSELECT
Magic properties inherited from Nette\Object
$reflection
Nette 2.2 API documentation generated by ApiGen 2.8.0