Gitee
\
CodeIgniter
API
Autoloader
Cache
Exceptions
Handlers
CLI
Exceptions
Commands
Database
Server
Sessions
Utilities
Config
Database
Exceptions
MySQLi
Postgre
SQLite3
Debug
Toolbar
Collectors
Email
Encryption
Exceptions
Handlers
Events
Exceptions
Files
Exceptions
Filters
Exceptions
Format
Exceptions
Honeypot
Exceptions
HTTP
Exceptions
Files
I18n
Exceptions
Images
Exceptions
Handlers
Log
Exceptions
Handlers
Pager
Exceptions
Router
Exceptions
Security
Exceptions
Session
Exceptions
Handlers
Test
Filters
Throttle
Typography
Validation
Exceptions
View
Exceptions
Config
My
Field
Book
Phpcmf
Admin
Controllers
Admin
Api
Member
Extend
Field
Home
Library
Member
Model
Bbs
Bdtj
Bdts
Block
Book
Cqx
Fstatus
Hy
Mbdyf
Myapp
Navigator
Order
Page
Sitemap
Sites
Store
Tag
Tixian
Variable
Xcx
Yuedusf
Zone
ThirdParty
Storage
Psr
Log
Xcx
Zend
Escaper
Exception

\CodeIgniter\Database\PostgreUtils

Utils for Postgre

Summary

Methods
Properties
Constants
__construct()
listDatabases()
databaseExists()
optimizeTable()
optimizeDatabase()
repairTable()
getCSVFromResult()
getXMLFromResult()
backup()
_backup()
No public properties found
No constants found
No protected methods found
$db
$listDatabases
$optimizeTable
$repairTable
N/A
No private methods found
No private properties found
N/A

Properties

$db

$db : object

Database object

Type

object

$listDatabases

$listDatabases : string

List databases statement

Type

string

$optimizeTable

$optimizeTable : string

OPTIMIZE TABLE statement

Type

string

$repairTable

$repairTable : string

REPAIR TABLE statement

Type

string

Methods

listDatabases()

listDatabases() : array|boolean

List databases

Throws

\CodeIgniter\Database\Exceptions\DatabaseException

Returns

array|boolean

databaseExists()

databaseExists(string  $database_name) : boolean

Determine if a particular database exists

Parameters

string $database_name

Returns

boolean

optimizeTable()

optimizeTable(string  $table_name) : mixed

Optimize Table

Parameters

string $table_name

Throws

\CodeIgniter\Database\Exceptions\DatabaseException

Returns

mixed

optimizeDatabase()

optimizeDatabase() : mixed

Optimize Database

Throws

\CodeIgniter\Database\Exceptions\DatabaseException

Returns

mixed

repairTable()

repairTable(string  $table_name) : mixed

Repair Table

Parameters

string $table_name

Throws

\CodeIgniter\Database\Exceptions\DatabaseException

Returns

mixed

getCSVFromResult()

getCSVFromResult(\CodeIgniter\Database\ResultInterface  $query, string  $delim = ',', string  $newline = "\n", string  $enclosure = '"') : string

Generate CSV from a query result object

Parameters

\CodeIgniter\Database\ResultInterface $query

Query result object
string $delim

Delimiter (default: ,)
string $newline

Newline character (default: \n)
string $enclosure

Enclosure (default: ")

Returns

string

getXMLFromResult()

getXMLFromResult(\CodeIgniter\Database\ResultInterface  $query, array  $params = array()) : string

Generate XML data from a query result object

Parameters

\CodeIgniter\Database\ResultInterface $query

Query result object
array $params

Any preferences

Returns

string

backup()

backup(array|string  $params = array()) : mixed

Database Backup

Parameters

array|string $params

Throws

\CodeIgniter\Database\Exceptions\DatabaseException

Returns

mixed

_backup()

_backup(array|null  $prefs = null) : mixed

Platform dependent version of the backup function.

Parameters

array|null $prefs

Returns

mixed