ADODB2_postgres Class Reference

Inheritance diagram for ADODB2_postgres:

List of all members.

Public Member Functions
	MetaType ($t, $len=-1, $fieldobj=false)
	ActualType ($meta)
	AddColumnSQL ($tabname, $flds)
	AlterColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')
	DropColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')
	_recreate_copy_table ($tabname, $dropflds, $tableflds, $tableoptions='')
	DropTableSQL ($tabname)
	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint)
	_DropAutoIncrement ($tabname)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
	_GetSize ($ftype, $ty, $fsize, $fprec)
Public Attributes
	$databaseType = 'postgres'
	$seqField = false
	$seqPrefix = 'SEQ_'
	$addCol = ' ADD COLUMN'
	$quote = '"'
	$renameTable = 'ALTER TABLE %s RENAME TO %s'
	$dropTable = 'DROP TABLE %s CASCADE'

---

Detailed Description

Definition at line 16 of file datadict-postgres.inc.php.

---

Member Function Documentation

ADODB2_postgres._CreateSuffix (  $  fname, &$  ftype, $  fnotnull, $  fdefault, $  fautoinc, $  fconstraint )

Definition at line 267 of file datadict-postgres.inc.php.

ADODB2_postgres._DropAutoIncrement (  $  tabname  )

Reimplemented from ADODB_DataDict. Definition at line 283 of file datadict-postgres.inc.php.

ADODB2_postgres._GetSize (  $  ftype, $  ty, $  fsize, $  fprec )

Reimplemented from ADODB_DataDict. Definition at line 361 of file datadict-postgres.inc.php.

ADODB2_postgres._IndexSQL (  $  idxname, $  tabname, $  flds, $  idxoptions )

Reimplemented from ADODB_DataDict. Definition at line 329 of file datadict-postgres.inc.php.

ADODB2_postgres._recreate_copy_table (  $  tabname, $  dropflds, $  tableflds, $  tableoptions = '' )

Save the content into a temp. table, drop and recreate the original table and copy the content back in We also take care to set the values of the sequenz and recreate the indexes. All this is done in a transaction, to not loose the content of the table, if something went wrong! Definition at line 210 of file datadict-postgres.inc.php.

ADODB2_postgres.ActualType (  $  meta  )

Reimplemented from ADODB_DataDict. Definition at line 90 of file datadict-postgres.inc.php.

ADODB2_postgres.AddColumnSQL (  $  tabname, $  flds )

Adding a new Column reimplementation of the default function as postgres does NOT allow to set the default in the same statement Parameters: string  $tabname table-name string  $flds column-names and types for the changed columns Returns: array with SQL strings Reimplemented from ADODB_DataDict. Definition at line 128 of file datadict-postgres.inc.php.

ADODB2_postgres.AlterColumnSQL (  $  tabname, $  flds, $  tableflds = '', $  tableoptions = '' )

Change the definition of one column Postgres can't do that on it's own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table Parameters: string  $tabname table-name string  $flds column-name and type for the changed column string  $tableflds complete defintion of the new table, eg. for postgres, default '' array/  $tableoptions options for the new table see CreateTableSQL, default '' Returns: array with SQL strings Reimplemented from ADODB_DataDict. Definition at line 165 of file datadict-postgres.inc.php.

ADODB2_postgres.DropColumnSQL (  $  tabname, $  flds, $  tableflds = '', $  tableoptions = '' )

Drop one column Postgres < 7.3 can't do that on it's own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table Parameters: string  $tabname table-name string  $flds column-name and type for the changed column string  $tableflds complete defintion of the new table, eg. for postgres, default '' array/  $tableoptions options for the new table see CreateTableSQL, default '' Returns: array with SQL strings Reimplemented from ADODB_DataDict. Definition at line 185 of file datadict-postgres.inc.php.

ADODB2_postgres.DropTableSQL (  $  tabname  )

Reimplemented from ADODB_DataDict. Definition at line 256 of file datadict-postgres.inc.php.

ADODB2_postgres.MetaType (  $  t, $  len = -1, $  fieldobj = false )

Reimplemented from ADODB_DataDict. Definition at line 26 of file datadict-postgres.inc.php.

---

Member Data Documentation

ADODB2_postgres.$addCol = ' ADD COLUMN'

Reimplemented from ADODB_DataDict. Definition at line 21 of file datadict-postgres.inc.php.

ADODB2_postgres.$databaseType = 'postgres'

Definition at line 18 of file datadict-postgres.inc.php.

ADODB2_postgres.$dropTable = 'DROP TABLE %s CASCADE'

Reimplemented from ADODB_DataDict. Definition at line 24 of file datadict-postgres.inc.php.

ADODB2_postgres.$quote = '"'

Definition at line 22 of file datadict-postgres.inc.php.

ADODB2_postgres.$renameTable = 'ALTER TABLE %s RENAME TO %s'

Reimplemented from ADODB_DataDict. Definition at line 23 of file datadict-postgres.inc.php.

ADODB2_postgres.$seqField = false

Definition at line 19 of file datadict-postgres.inc.php.

ADODB2_postgres.$seqPrefix = 'SEQ_'

Definition at line 20 of file datadict-postgres.inc.php.

---

The documentation for this class was generated from the following file:

• typo3/sysext/adodb/adodb/datadict/datadict-postgres.inc.php

---