creole.drivers.pgsql.metadata

[ ] [ ] [ ]

Packages:
creole
creole.common
creole.drivers.mssql
creole.drivers.mssql.metadata
creole.drivers.mysql
creole.drivers.mysql.metadata
creole.drivers.odbc
creole.drivers.odbc.metadata
creole.drivers.oracle
creole.drivers.oracle.metadata
creole.drivers.pgsql
creole.drivers.pgsql.metadata
creole.drivers.sqlite
creole.drivers.sqlite.metadata
creole.metadata
creole.util
creole.util.sql
jargon

Files:

PgSQLDatabaseInfo.php
PgSQLTableInfo.php

Classes:

PgSQLDatabaseInfo
PgSQLTableInfo

Class: PgSQLTableInfo

Source Location: /creole/drivers/pgsql/metadata/PgSQLTableInfo.php

Class Overview

TableInfo
   |
   --PgSQLTableInfo

PgSQL implementation of TableInfo.

Author(s):

Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.24 $

Methods

Inherited Variables

Class: TableInfo

TableInfo::$colsLoaded
TableInfo::$columns
TableInfo::$conn
TableInfo::$database
TableInfo::$dblink
TableInfo::$dbname
TableInfo::$fksLoaded
TableInfo::$foreignKeys
TableInfo::$indexes
TableInfo::$indexesLoaded
TableInfo::$name
TableInfo::$pkLoaded
TableInfo::$primaryKey

Inherited Methods

Class: TableInfo

TableInfo::__construct()
TableInfo::addColumn(): Adds a column to this table.
TableInfo::columnsLoaded(): Have columns been loaded?
TableInfo::foreignKeysLoaded(): Have foreign keys been loaded?
TableInfo::getColumn(): Get the ColumnInfo object for specified column.
TableInfo::getColumns(): Get array of columns for this table.
TableInfo::getDatabase(): Get the parent DatabaseInfo object.
TableInfo::getForeignKey(): Get specified fk for this table.
TableInfo::getForeignKeys(): Get all foreign keys.
TableInfo::getIndex(): Gets the IndexInfo object for a specified index.
TableInfo::getIndexes(): Get array of IndexInfo objects for this table.
TableInfo::getIndices(): Alias for getIndexes() method.
TableInfo::getName(): Get table name.
TableInfo::getPrimaryKey(): Get parimary key in this table.
TableInfo::indexesLoaded(): Has index information been loaded?
TableInfo::initColumns(): Loads the columns.
TableInfo::initForeignKeys(): Loads the foreign keys for this table.
TableInfo::initIndexes(): Loads the indexes information for this table.
TableInfo::initPrimaryKey(): Loads the primary key information for this table.
TableInfo::primaryKeyLoaded(): Has primary key info been loaded?
TableInfo::toString()
TableInfo::__sleep(): This "magic" method is invoked upon serialize().
TableInfo::__wakeup(): This "magic" method is invoked upon unserialize().

Class Details

[line 40]
PgSQL implementation of TableInfo.

See this Python code by David M. Cook for some good reference on Pgsql metadata functions:

Tags:

version:	$Revision: 1.24 $
author:	Hans Lellelid <hans@xmpl.org>
todo:	-c Eventually move to supporting only Postgres >= 7.4, which has the information_schema
link:	http://developer.postgresql.org/docs/pgsql/src/backend/catalog/information_schema.sql
link:	Here's some more information from postgresql:

[ Top ]

Class Methods

method initColumns [line 43]

void initColumns(
)

Load the columns for this table

Tags:

access:

protected

Overrides TableInfo::initColumns() (Loads the columns.)

[ Top ]

method initForeignKeys [line 97]

void initForeignKeys(
)

Load foreign keys for this table.

Tags:

access:

protected

Overrides TableInfo::initForeignKeys() (Loads the foreign keys for this table.)

[ Top ]

method initIndexes [line 136]

void initIndexes(
)

Load indexes for this table

Tags:

access:

protected

Overrides TableInfo::initIndexes() (Loads the indexes information for this table.)

[ Top ]

method initPrimaryKey [line 166]

void initPrimaryKey(
)

Loads the primary keys for this table.

Tags:

access:

protected

Overrides TableInfo::initPrimaryKey() (Loads the primary key information for this table.)

[ Top ]

Documentation generated on Mon, 23 Aug 2004 21:52:40 -0400 by phpDocumentor 1.3.0RC3