PostgresqlTable
class PostgresqlTable extends AbstractTable (View source)
Class PostgresqlTable
Methods
create($schema, bool $ifNotExists = true, array $options = array())
create
$this
from AbstractTable
$this
rename(string $newName, boolean $returnNew = true)
rename
mixed
getColumnDetails(bool $refresh = false)
getColumnDetails
addColumn(string $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
addColumn
modifyColumn(string|Column $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
modifyColumn
changeColumn(string $oldName, string|Column $newName, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
changeColumn
addIndex(string $type, array $columns = array(), string $name = null, string $comment = null, array $options = array())
addIndex
dropIndex(string $name, bool $constraint = false)
dropIndex
array
getIndexes()
getIndexes
from AbstractTable
array
getTableSequences(string $table)
Get the details list of sequences for a table.
Details
in AbstractTable at line line 64
__construct(string $table, AbstractDatabaseDriver $db)
Constructor.
at line line 32
AbstractTable
create($schema, bool $ifNotExists = true, array $options = array())
create
in AbstractTable at line line 89
AbstractTable
update(callable|Schema $schema)
update
in AbstractTable at line line 115
$this
save(callable|Schema $schema, bool $ifNotExists = true, array $options = array())
save
in AbstractTable at line line 142
AbstractTable
drop(bool $ifExists = true, string $option = '')
drop
in AbstractTable at line line 158
boolean
exists()
exists
at line line 490
$this
rename(string $newName, boolean $returnNew = true)
rename
in AbstractTable at line line 183
AbstractTable
lock()
Locks a table in the database.
in AbstractTable at line line 197
AbstractTable
unlock()
unlock
in AbstractTable at line line 212
AbstractTable
truncate()
Method to truncate a table.
in AbstractTable at line line 224
array|boolean
getDetail()
getDetail
in AbstractTable at line line 236
array
getColumns(bool $refresh = false)
Get table columns.
at line line 516
mixed
getColumnDetails(bool $refresh = false)
getColumnDetails
in AbstractTable at line line 257
stdClass
getColumnDetail(string $column)
getColumnDetail
in AbstractTable at line line 271
boolean
hasColumn(string $column)
hasColumn
at line line 125
AbstractTable
addColumn(string $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
addColumn
in AbstractTable at line line 298
AbstractTable
dropColumn(string $name)
dropColumn
at line line 200
AbstractTable
modifyColumn(string|Column $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
modifyColumn
at line line 280
AbstractTable
changeColumn(string $oldName, string|Column $newName, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())
changeColumn
at line line 406
AbstractTable
addIndex(string $type, array $columns = array(), string $name = null, string $comment = null, array $options = array())
addIndex
at line line 461
AbstractTable
dropIndex(string $name, bool $constraint = false)
dropIndex
at line line 602
array
getIndexes()
getIndexes
in AbstractTable at line line 381
boolean
hasIndex(string $name)
hasIndex
in AbstractTable at line line 401
string
getName()
Method to get property Table
in AbstractTable at line line 418
AbstractTable
setName(string $name)
Method to set property table
in AbstractTable at line line 430
AbstractDatabaseDriver
getDriver()
Method to get property Db
in AbstractTable at line line 442
AbstractTable
setDriver(AbstractDatabaseDriver $db)
Method to set property db
in AbstractTable at line line 454
Schema
getSchema()
getSchema
in AbstractTable at line line 490
AbstractDatabase
getDatabase()
Method to get property Database
in AbstractTable at line line 502
AbstractTable
setDatabase(AbstractDatabase $database)
Method to set property database
in AbstractTable at line line 519
DataType
getDataType()
getTypeMapper
in AbstractTable at line line 579
AbstractTable
reset()
reset
at line line 655
array
getTableSequences(string $table)
Get the details list of sequences for a table.