Class \Prado\Data\Common\Pgsql\TPgsqlMetaData

TPgsqlMetaData loads PostgreSQL database table and column information.

Class hierarchy

\Prado\Data\Common\Pgsql\TPgsqlMetaData

Extended by

\Prado\Data\Common\TDbMetaData

Extended by

\Prado\TComponent

Author: Wei Zhuo <weizho[at]gmail[dot]com>
Since: 3.1

Methods summary
`public`	`findTableNames([string $schema = 'public' ]) : array<string\|int, mixed>` Returns all table names in the database.
`public`	`getDefaultSchema() : string`
`public`	`quoteColumnAlias(string $name) : string` Quotes a column alias for use in a query.
`public`	`quoteColumnName(string $name) : string` Quotes a column name for use in a query.
`public`	`quoteTableName(string $name) : string` Quotes a table name for use in a query.
`public`	`setDefaultSchema(string $schema) : mixed`
`protected`	`assertIdentifier(string $name) : string`
`protected`	`createNewTableInfo(string $schemaName, string $tableName) : TPgsqlTableInfo`
`protected`	`createTableInfo(string $table) : TPgsqlTableInfo` Get the column definitions for given table.
`protected`	`getConstraintKeys(string $schemaName, string $tableName) : array<string\|int, mixed>` Gets the primary and foreign key column details for the given table.
`protected`	`getForeignKeys(string $src) : null\|array<string\|int, mixed>` Gets foreign relationship constraint keys and table name
`protected`	`getIsView(string $schemaName, string $tableName) : bool`
`protected`	`getPrimaryKeys(string $tableName, string $schemaName, string $columnIndex) : array<string\|int, mixed>` Gets the primary key field names
`protected`	`getSchemaTableName(string $table) : array<string\|int, mixed>`
`protected`	`getSequenceName(TPgsqlTableInfo $tableInfo, mixed $src) : null\|string`
`protected`	`getTableInfoClass() : string`
`protected`	`isForeignKeyColumn(string $columnId, TPgsqlTableInfo $tableInfo) : bool`
`protected`	`isPrecisionType(mixed $type) : bool`
`protected`	`processColumn(TPgsqlTableInfo $tableInfo, array<string\|int, mixed> $col) : mixed`

Inherited methods
__call, __callStatic, __clone, __construct, __destruct, __get, __isset, __set, __sleep, __unset, __wakeup, addParsedObject, asa, attachBehavior, attachBehaviors, attachClassBehavior, attachEventHandler, callBehaviorsMethod, canGetProperty, canSetProperty, clearBehaviors, createCommandBuilder, createdOnTemplate, detachBehavior, detachBehaviors, detachClassBehavior, detachEventHandler, disableBehavior, disableBehaviors, enableBehavior, enableBehaviors, evaluateExpression, evaluateStatements, findTableNames, fxAttachClassBehavior, fxDetachClassBehavior, getAutoGlobalListen, getBehaviors, getBehaviorsEnabled, getClassHierarchy, getDbConnection, getEventHandlers, getInstance, getListeningToGlobalEvents, getSubProperty, getTableInfo, hasEvent, hasEventHandler, hasMethod, hasProperty, isa, listen, quoteColumnAlias, quoteColumnName, quoteTableName, raiseEvent, setSubProperty, unlisten, _getZappableSleepProps, createTableInfo, getCallChain, getClassFxEvents, getTableInfoClass, instanceBehavior, filter_prado_fx

Inherited constants
`\Prado\TComponent::GLOBAL_RAISE_EVENT_LISTENER`