Class JDatabaseImporterPostgresql

PostgreSQL import driver.

JDatabaseImporterPostgresql

Package: Joomla\Platform\Database
Copyright: Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.
License: General Public License version 2 or later; see LICENSE
Since: 12.1
Located at joomla/database/importer/postgresql.php

Methods summary

`public JDatabaseImporterPostgresql`	# `check( )` Checks if all data and options are in order prior to exporting. Checks if all data and options are in order prior to exporting. Returns `JDatabaseImporterPostgresql` - Method supports chaining. Throws `Exception` - if an error is encountered. Since 12.1
`protected string`	# `getAddColumnSql( string $table, SimpleXMLElement $field )` Get the SQL syntax to add a column. Get the SQL syntax to add a column. Parameters `$table` `string` - $table The table name. `$field` `SimpleXMLElement` - $field The XML field definition. Returns `string` Since 12.1
`protected string`	# `getAddIndexSql( SimpleXMLElement $field )` Get the SQL syntax to add an index. Get the SQL syntax to add an index. Parameters `$field` `SimpleXMLElement` - $field The XML index definition. Returns `string` Since 12.1
`protected array`	# `getAlterTableSql( SimpleXMLElement $structure )` Get alters for table if there is a difference. Get alters for table if there is a difference. Parameters `$structure` `SimpleXMLElement` - $structure The XML structure of the table. Returns `array` Since 12.1
`protected string`	# `getDropSequenceSql( string $name )` Get the SQL syntax to drop a sequence. Get the SQL syntax to drop a sequence. Parameters `$name` `string` - $name The name of the sequence to drop. Returns `string` Since 12.1
`protected string`	# `getAddSequenceSql( SimpleXMLElement $field )` Get the syntax to add a sequence. Get the syntax to add a sequence. Parameters `$field` `SimpleXMLElement` - $field The XML definition for the sequence. Returns `string` Since 12.1
`protected string`	# `getChangeSequenceSql( SimpleXMLElement $field )` Get the syntax to alter a sequence. Get the syntax to alter a sequence. Parameters `$field` `SimpleXMLElement` - $field The XML definition for the sequence. Returns `string` Since 12.1
`protected string`	# `getChangeColumnSql( string $table, SimpleXMLElement $field )` Get the syntax to alter a column. Get the syntax to alter a column. Parameters `$table` `string` - $table The name of the database table to alter. `$field` `SimpleXMLElement` - $field The XML definition for the field. Returns `string` Since 12.1
`protected string`	# `getAlterColumnSql( string $table, SimpleXMLElement $field )` Get the SQL syntax for a single column that would be included in a table create statement. Get the SQL syntax for a single column that would be included in a table create statement. Parameters `$table` `string` - $table The name of the database table to alter. `$field` `SimpleXMLElement` - $field The XML field definition. Returns `string` Since 12.1
`protected string`	# `getColumnSql( SimpleXMLElement $field )` Get the SQL syntax for a single column that would be included in a table create statement. Get the SQL syntax for a single column that would be included in a table create statement. Parameters `$field` `SimpleXMLElement` - $field The XML field definition. Returns `string` Since 12.1
`protected string`	# `getDropIndexSql( string $name )` Get the SQL syntax to drop an index. Get the SQL syntax to drop an index. Parameters `$name` `string` - $name The name of the key to drop. Returns `string` Since 12.1
`protected string`	# `getDropPrimaryKeySql( string $table, string $name )` Get the SQL syntax to drop a key. Get the SQL syntax to drop a key. Parameters `$table` `string` - $table The table name. `$name` `string` - $name The constraint name. Returns `string` Since 12.1
`protected array`	# `getIdxLookup( array $keys )` Get the details list of keys for a table. Get the details list of keys for a table. Parameters `$keys` `array` - $keys An array of objects that comprise the keys for the table. Returns `array` - The lookup array. array({key name} => array(object, ...)) Throws `Exception` Since 12.1
`protected array`	# `getSeqLookup( array $sequences )` Get the details list of sequences for a table. Get the details list of sequences for a table. Parameters `$sequences` `array` - $sequences An array of objects that comprise the sequences for the table. Returns `array` - The lookup array. array({key name} => array(object, ...)) Throws `Exception` Since 12.1

Methods inherited from JDatabaseImporter

__construct(), asXml(), from(), getDropColumnSql(), getRealTableName(), mergeStructure(), setDbo(), withStructure()

Magic methods summary

Properties summary

Properties inherited from JDatabaseImporter

$asFormat, $cache, $db, $from, $options

Namespaces

Classes

Interfaces

Exceptions

Constants

Functions

Class JDatabaseImporterPostgresql

Methods summary

Returns

Throws

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Since

Parameters

Returns

Throws

Since

Parameters

Returns

Throws

Since

Methods inherited from JDatabaseImporter

Magic methods summary

Properties summary

Properties inherited from JDatabaseImporter