Public Member Functions | |
Boolean | AllProceduresAreCallable () |
Can all the procedures returned by getProcedures be called by the current user? | |
Boolean | AllTablesAreSelectable () |
Can all the tables returned by getTable be SELECTed by the current user? | |
ClearCache (const string Key) | |
Clears specific cached metadata. | |
ClearCache () | |
Clears all cached metadata. | |
Boolean | DataDefinitionCausesTransactionCommit () |
Does a data definition statement within a transaction force the transaction to commit? | |
Boolean | DataDefinitionIgnoredInTransactions () |
Is a data definition statement within a transaction ignored? | |
Boolean | DoesMaxRowSizeIncludeBlobs () |
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs? | |
IZResultSet | GetBestRowIdentifier (const string Catalog, const string Schema, const string Table, Integer Scope, Boolean Nullable) |
Gets a description of a table's optimal set of columns that uniquely identifies a row. | |
string | GetBestRowIdentifierCacheKey (const string Catalog, const string Schema, const string Table, const Integer Scope, const Boolean Nullable) |
returns cache key for GetBestRowIdentifier metadata entry | |
GetCacheKeys (TStrings List) | |
fills string list with the keys for the currently cached metadata entries | |
IZResultSet | GetCatalogs () |
Gets the catalog names available in this database. | |
string | GetCatalogsCacheKey () |
returns cache key for GetCatalogs metadata entry | |
string | GetCatalogSeparator () |
What's the separator between catalog and table name? | |
string | GetCatalogTerm () |
What's the database vendor's preferred term for "catalog"? | |
IZResultSet | GetColumnPrivileges (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
Gets a description of the access rights for a table's columns. | |
string | GetColumnPrivilegesCacheKey (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
returns cache key for GetColumnPrivileges metadata entry | |
IZResultSet | GetColumns (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
Gets a description of table columns available in the specified catalog. | |
string | GetColumnsCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
returns cache key for GetColumns metadata entry | |
IZConnection | GetConnection () |
Retrieves the connection that produced this metadata object. | |
IZResultSet | GetCrossReference (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key. | |
string | GetCrossReferenceCacheKey (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
returns cache key for GetCrossReference metadata entry | |
string | GetDatabaseProductName () |
What's the name of this database product? | |
string | GetDatabaseProductVersion () |
What's the version of this database product? | |
TZTransactIsolationLevel | GetDefaultTransactionIsolation () |
What's the database's default transaction isolation level? The values are defined in java.sql.Connection . | |
Integer | GetDriverMajorVersion () |
What's this JDBC driver's major version number? | |
Integer | GetDriverMinorVersion () |
What's this JDBC driver's minor version number? | |
string | GetDriverName () |
What's the name of this JDBC driver? | |
string | GetDriverVersion () |
What's the version of this JDBC driver? | |
IZResultSet | GetExportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). | |
string | GetExportedKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetExportedKeys metadata entry | |
string | GetExtraNameCharacters () |
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). | |
IZIdentifierConvertor | GetIdentifierConvertor () |
Creates ab identifier convertor object. | |
string | GetIdentifierQuoteString () |
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported. | |
IZResultSet | GetImportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). | |
string | GetImportedKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetImportedKeys metadata entry | |
IZResultSet | GetIndexInfo (const string Catalog, const string Schema, const string Table, Boolean Unique, Boolean Approximate) |
Gets a description of a table's indices and statistics. | |
string | GetIndexInfoCacheKey (const string Catalog, const string Schema, const string Table, const Boolean Unique, const Boolean Approximate) |
returns cache key for GetIndexInfo metadata entry | |
Integer | GetMaxBinaryLiteralLength () |
How many hex characters can you have in an inline binary literal? | |
Integer | GetMaxCatalogNameLength () |
What's the maximum length of a catalog name? | |
Integer | GetMaxCharLiteralLength () |
What's the max length for a character literal? | |
Integer | GetMaxColumnNameLength () |
What's the limit on column name length? | |
Integer | GetMaxColumnsInGroupBy () |
What's the maximum number of columns in a "GROUP BY" clause? | |
Integer | GetMaxColumnsInIndex () |
What's the maximum number of columns allowed in an index? | |
Integer | GetMaxColumnsInOrderBy () |
What's the maximum number of columns in an "ORDER BY" clause? | |
Integer | GetMaxColumnsInSelect () |
What's the maximum number of columns in a "SELECT" list? | |
Integer | GetMaxColumnsInTable () |
What's the maximum number of columns in a table? | |
Integer | GetMaxConnections () |
How many active connections can we have at a time to this database? | |
Integer | GetMaxCursorNameLength () |
What's the maximum cursor name length? | |
Integer | GetMaxIndexLength () |
Retrieves the maximum number of bytes for an index, including all of the parts of the index. | |
Integer | GetMaxProcedureNameLength () |
What's the maximum length of a procedure name? | |
Integer | GetMaxRowSize () |
What's the maximum length of a single row? | |
Integer | GetMaxSchemaNameLength () |
What's the maximum length allowed for a schema name? | |
Integer | GetMaxStatementLength () |
What's the maximum length of an SQL statement? | |
Integer | GetMaxStatements () |
How many active statements can we have open at one time to this database? | |
Integer | GetMaxTableNameLength () |
What's the maximum length of a table name? | |
Integer | GetMaxTablesInSelect () |
What's the maximum number of tables in a SELECT statement? | |
Integer | GetMaxUserNameLength () |
What's the maximum length of a user name? | |
string | GetNumericFunctions () |
Gets a comma-separated list of math functions. | |
IZResultSet | GetPrimaryKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's primary key columns. | |
string | GetPrimaryKeysCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetPrimaryKeys metadata entry | |
IZResultSet | GetProcedureColumns (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
Gets a description of a catalog's stored procedure parameters and result columns. | |
string | GetProcedureColumnsCacheKey (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
returns cache key for GetProcedureColumns metadata entry | |
IZResultSet | GetProcedures (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
Gets a description of the stored procedures available in a catalog. | |
string | GetProceduresCacheKey (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
returns cache key for GetProcedures metadata entry | |
string | GetProcedureTerm () |
What's the database vendor's preferred term for "procedure"? | |
IZResultSet | GetSchemas () |
Gets the schema names available in this database. | |
string | GetSchemasCacheKey () |
returns cache key for GetSchemas metadata entry | |
string | GetSchemaTerm () |
What's the database vendor's preferred term for "schema"? | |
string | GetSearchStringEscape () |
Gets the string that can be used to escape wildcard characters. | |
IZResultSet | GetSequences (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
string | GetSequencesCacheKey (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
returns cache key for GetSequences metadata entry | |
string | GetSQLKeywords () |
Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords. | |
string | GetStringFunctions () |
Gets a comma-separated list of string functions. | |
string | GetSystemFunctions () |
Gets a comma-separated list of system functions. | |
IZResultSet | GetTablePrivileges (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
Gets a description of the access rights for each table available in a catalog. | |
string | GetTablePrivilegesCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
returns cache key for GetTablePrivileges metadata entry | |
IZResultSet | GetTables (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
Gets a description of tables available in a catalog. | |
string | GetTablesCacheKey (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
returns cache key for GetTables metadata entry | |
IZResultSet | GetTableTypes () |
Gets the table types available in this database. | |
string | GetTableTypesCacheKey () |
returns cache key for GetTableTypes metadata entry | |
string | GetTimeDateFunctions () |
Gets a comma-separated list of time and date functions. | |
IZResultSet | GetTypeInfo () |
Gets a description of all the standard SQL types supported by this database. | |
string | GetTypeInfoCacheKey () |
returns cache key for GetTypeInfo metadata entry | |
IZResultSet | GetUDTs (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
Gets a description of the user-defined types defined in a particular schema. | |
string | GetUDTsCacheKey (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
returns cache key for GetUDTs metadata entry | |
string | GetURL () |
What's the url for this database? | |
string | GetUserName () |
What's our user name as known to the database? | |
IZResultSet | GetVersionColumns (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's columns that are automatically updated when any value in a row is updated. | |
string | GetVersionColumnsCacheKey (const string Catalog, const string Schema, const string Table) |
returns cache key for GetVersionColumns metadata entry | |
Boolean | IsCatalogAtStart () |
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end). | |
Boolean | IsReadOnly () |
Is the database in read-only mode? | |
Boolean | NullPlusNonNullIsNull () |
Are concatenations between NULL and non-NULL values NULL? For SQL-92 compliance, a JDBC technology-enabled driver will return true . | |
Boolean | NullsAreSortedAtEnd () |
Are NULL values sorted at the end regardless of sort order? | |
Boolean | NullsAreSortedAtStart () |
Are NULL values sorted at the start regardless of sort order? | |
Boolean | NullsAreSortedHigh () |
Are NULL values sorted high? | |
Boolean | NullsAreSortedLow () |
Are NULL values sorted low? | |
Boolean | StoresLowerCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case? | |
Boolean | StoresLowerCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case? | |
Boolean | StoresMixedCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case? | |
Boolean | StoresMixedCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case? | |
Boolean | StoresUpperCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case? | |
Boolean | StoresUpperCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case? | |
Boolean | SupportsAlterTableWithAddColumn () |
Is "ALTER TABLE" with add column supported? | |
Boolean | SupportsAlterTableWithDropColumn () |
Is "ALTER TABLE" with drop column supported? | |
Boolean | SupportsANSI92EntryLevelSQL () |
Is the ANSI92 entry level SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true. | |
Boolean | SupportsANSI92FullSQL () |
Is the ANSI92 full SQL grammar supported? | |
Boolean | SupportsANSI92IntermediateSQL () |
Is the ANSI92 intermediate SQL grammar supported? | |
Boolean | SupportsBatchUpdates () |
Indicates whether the driver supports batch updates. | |
Boolean | SupportsCatalogsInDataManipulation () |
Can a catalog name be used in a data manipulation statement? | |
Boolean | SupportsCatalogsInIndexDefinitions () |
Can a catalog name be used in an index definition statement? | |
Boolean | SupportsCatalogsInPrivilegeDefinitions () |
Can a catalog name be used in a privilege definition statement? | |
Boolean | SupportsCatalogsInProcedureCalls () |
Can a catalog name be used in a procedure call statement? | |
Boolean | SupportsCatalogsInTableDefinitions () |
Can a catalog name be used in a table definition statement? | |
Boolean | SupportsColumnAliasing () |
Is column aliasing supported? | |
Boolean | SupportsConvert () |
Is the CONVERT function between SQL types supported? | |
Boolean | SupportsConvertForTypes (TZSQLType FromType, TZSQLType ToType) |
Is CONVERT between the given SQL types supported? | |
Boolean | SupportsCoreSQLGrammar () |
Is the ODBC Core SQL grammar supported? | |
Boolean | SupportsCorrelatedSubqueries () |
Are correlated subqueries supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsDataDefinitionAndDataManipulationTransactions () |
Boolean | SupportsDataManipulationTransactionsOnly () |
Boolean | SupportsDifferentTableCorrelationNames () |
If table correlation names are supported, are they restricted to be different from the names of the tables? | |
Boolean | SupportsExpressionsInOrderBy () |
Are expressions in "ORDER BY" lists supported? | |
Boolean | SupportsExtendedSQLGrammar () |
Is the ODBC Extended SQL grammar supported? | |
Boolean | SupportsFullOuterJoins () |
Are full nested outer joins supported? | |
Boolean | SupportsGroupBy () |
Is some form of "GROUP BY" clause supported? | |
Boolean | SupportsGroupByBeyondSelect () |
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT? | |
Boolean | SupportsGroupByUnrelated () |
Can a "GROUP BY" clause use columns not in the SELECT? | |
Boolean | SupportsIntegrityEnhancementFacility () |
Is the SQL Integrity Enhancement Facility supported? | |
Boolean | SupportsLikeEscapeClause () |
Is the escape character in "LIKE" clauses supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsLimitedOuterJoins () |
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true. | |
Boolean | SupportsMinimumSQLGrammar () |
Is the ODBC Minimum SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true. | |
Boolean | SupportsMixedCaseIdentifiers () |
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return false. | |
Boolean | SupportsMixedCaseQuotedIdentifiers () |
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return true. | |
Boolean | SupportsMultipleResultSets () |
Are multiple ResultSet from a single execute supported? | |
Boolean | SupportsMultipleTransactions () |
Can we have multiple transactions open at once (on different connections)? | |
Boolean | SupportsNonNullableColumns () |
Can columns be defined as non-nullable? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsOpenCursorsAcrossCommit () |
Can cursors remain open across commits? | |
Boolean | SupportsOpenCursorsAcrossRollback () |
Can cursors remain open across rollbacks? | |
Boolean | SupportsOpenStatementsAcrossCommit () |
Can statements remain open across commits? | |
Boolean | SupportsOpenStatementsAcrossRollback () |
Can statements remain open across rollbacks? | |
Boolean | SupportsOrderByUnrelated () |
Can an "ORDER BY" clause use columns not in the SELECT statement? | |
Boolean | SupportsOuterJoins () |
Is some form of outer join supported? | |
Boolean | SupportsPositionedDelete () |
Is positioned DELETE supported? | |
Boolean | SupportsPositionedUpdate () |
Is positioned UPDATE supported? | |
Boolean | SupportsResultSetConcurrency (TZResultSetType _Type, TZResultSetConcurrency Concurrency) |
Does the database support the concurrency type in combination with the given result set type? | |
Boolean | SupportsResultSetType (TZResultSetType _Type) |
Does the database support the given result set type? | |
Boolean | SupportsSchemasInDataManipulation () |
Can a schema name be used in a data manipulation statement? | |
Boolean | SupportsSchemasInIndexDefinitions () |
Can a schema name be used in an index definition statement? | |
Boolean | SupportsSchemasInPrivilegeDefinitions () |
Can a schema name be used in a privilege definition statement? | |
Boolean | SupportsSchemasInProcedureCalls () |
Can a schema name be used in a procedure call statement? | |
Boolean | SupportsSchemasInTableDefinitions () |
Can a schema name be used in a table definition statement? | |
Boolean | SupportsSelectForUpdate () |
Is SELECT for UPDATE supported? | |
Boolean | SupportsStoredProcedures () |
Are stored procedure calls using the stored procedure escape syntax supported? | |
Boolean | SupportsSubqueriesInComparisons () |
Are subqueries in comparison expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInExists () |
Are subqueries in 'exists' expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInIns () |
Are subqueries in 'in' statements supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsSubqueriesInQuantifieds () |
Are subqueries in quantified expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsTableCorrelationNames () |
Are table correlation names supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true. | |
Boolean | SupportsTransactionIsolationLevel (TZTransactIsolationLevel Level) |
Does this database support the given transaction isolation level? | |
Boolean | SupportsTransactions () |
Are transactions supported? If not, invoking the method commit is a noop and the isolation level is TRANSACTION_NONE. | |
Boolean | SupportsUnion () |
Is SQL UNION supported? | |
Boolean | SupportsUnionAll () |
Is SQL UNION ALL supported? | |
TZPostgreSQLDatabaseMetadata (TZAbstractConnection Connection, string Url, TStrings Info) | |
Constructs this object and assignes the main properties. | |
Boolean | UsesLocalFilePerTable () |
Does the database use a file for each table? | |
Boolean | UsesLocalFiles () |
Does the database store tables in a local file? | |
~TZPostgreSQLDatabaseMetadata () | |
Destroys this object and cleanups the memory. | |
Protected Types | |
typedef array< char > | WildcardsArray |
Protected Member Functions | |
string | AddEscapeCharToWildcards (const string Pattern) |
Add escape character in the pattern that has wildcards character. | |
AddResultSetToCache (const string Key, IZResultSet ResultSet) | |
Adds resultset to the internal cache. | |
IZResultSet | CloneCachedResultSet (IZResultSet ResultSet) |
Clones the cached resultset. | |
IZVirtualResultSet | ConstructVirtualResultSet (TZMetadataColumnDefs ColumnsDefs) |
Constructs a virtual result set object. | |
IZVirtualResultSet | CopyToVirtualResultSet (IZResultSet SrcResultSet, IZVirtualResultSet DestResultSet) |
Copies on result set to another one from the current position. | |
FillWildcards () | |
Set the Wildcards character for WildcardsArray variable. | |
Integer | GetMaxIndexKeys () |
Integer | GetMaxNameLength () |
string | GetPostgreSQLType (Integer Oid) |
string | GetPrivilegeName (char Permission) |
IZResultSet | GetResultSetFromCache (const string Key) |
Gets a resultset interface from the internal cache by key. | |
TZSQLType | GetSQLTypeByName (string TypeName) |
TZSQLType | GetSQLTypeByOid (Integer Oid) |
TZWildcardsSet | GetWildcardsSet () |
Get the Wildscards in set of char type. | |
Boolean | HaveMinimumServerVersion (Integer MajorVersion, Integer MinorVersion) |
ParseACLArray (TStrings List, string AclString) | |
string | TableTypeSQLExpression (string TableType, Boolean UseSchemas) |
IZResultSet | UncachedGetBestRowIdentifier (const string Catalog, const string Schema, const string Table, Integer Scope, Boolean Nullable) |
Gets a description of a table's optimal set of columns that uniquely identifies a row. | |
IZResultSet | UncachedGetCatalogs () |
Gets the catalog names available in this database. | |
IZResultSet | UncachedGetColumnPrivileges (const string Catalog, const string Schema, const string Table, const string ColumnNamePattern) |
Gets a description of the access rights for a table's columns. | |
IZResultSet | UncachedGetColumns (const string Catalog, const string SchemaPattern, const string TableNamePattern, const string ColumnNamePattern) |
Gets a description of table columns available in the specified catalog. | |
IZResultSet | UncachedGetCrossReference (const string PrimaryCatalog, const string PrimarySchema, const string PrimaryTable, const string ForeignCatalog, const string ForeignSchema, const string ForeignTable) |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key. | |
IZResultSet | UncachedGetExportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). | |
IZResultSet | UncachedGetImportedKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). | |
IZResultSet | UncachedGetIndexInfo (const string Catalog, const string Schema, const string Table, Boolean Unique, Boolean Approximate) |
Gets a description of a table's indices and statistics. | |
IZResultSet | UncachedGetPrimaryKeys (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's primary key columns. | |
IZResultSet | UncachedGetProcedureColumns (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern, const string ColumnNamePattern) |
Gets a description of a catalog's stored procedure parameters and result columns. | |
IZResultSet | UncachedGetProcedures (const string Catalog, const string SchemaPattern, const string ProcedureNamePattern) |
Gets a description of the stored procedures available in a catalog. | |
IZResultSet | UncachedGetSchemas () |
Gets the schema names available in this database. | |
IZResultSet | UncachedGetSequences (const string Catalog, const string SchemaPattern, const string SequenceNamePattern) |
IZResultSet | UncachedGetTablePrivileges (const string Catalog, const string SchemaPattern, const string TableNamePattern) |
Gets a description of the access rights for each table available in a catalog. | |
IZResultSet | UncachedGetTables (const string Catalog, const string SchemaPattern, const string TableNamePattern, const TStringDynArray Types) |
Gets a description of tables available in a catalog. | |
IZResultSet | UncachedGetTableTypes () |
Gets the table types available in this database. | |
IZResultSet | UncachedGetTypeInfo () |
Gets a description of all the standard SQL types supported by this database. | |
IZResultSet | UncachedGetUDTs (const string Catalog, const string SchemaPattern, const string TypeNamePattern, const TIntegerDynArray Types) |
Gets a description of the user-defined types defined in a particular schema. | |
IZResultSet | UncachedGetVersionColumns (const string Catalog, const string Schema, const string Table) |
Gets a description of a table's columns that are automatically updated when any value in a row is updated. | |
Protected Attributes | |
IZHashMap | CachedResultSets |
TStrings | Info |
string | Url |
Private Member Functions | |
string | EscapeString (const string S) |
Private Attributes | |
string | FDatabase |
Definition at line 72 of file ZDbcPostgreSqlMetadata.pas.
typedef array<char> TZAbstractDatabaseMetadata::WildcardsArray [protected, inherited] |
Definition at line 168 of file ZDbcMetadata.pas.
TZPostgreSQLDatabaseMetadata::TZPostgreSQLDatabaseMetadata | ( | TZAbstractConnection | Connection, | |
string | Url, | |||
TStrings | Info | |||
) |
Constructs this object and assignes the main properties.
Connection | a database connection object. | |
Url | a database connection url string. | |
Info | an extra connection properties. |
Definition at line 547 of file ZDbcPostgreSqlMetadata.pas.
TZPostgreSQLDatabaseMetadata::~TZPostgreSQLDatabaseMetadata | ( | ) |
Destroys this object and cleanups the memory.
Definition at line 578 of file ZDbcPostgreSqlMetadata.pas.
string TZAbstractDatabaseMetadata::AddEscapeCharToWildcards | ( | const string | Pattern | ) | [protected, inherited] |
Add escape character in the pattern that has wildcards character.
Pattern | The pattern that would be escaped |
Reimplemented from IZDatabaseMetadata.
Definition at line 5052 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::AddResultSetToCache | ( | const string | Key, | |
IZResultSet | ResultSet | |||
) | [protected, inherited] |
Adds resultset to the internal cache.
Key | a resultset unique key value. | |
ResultSet | a resultset interface. |
Definition at line 1206 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::AllProceduresAreCallable | ( | ) | [inherited] |
Can all the procedures returned by getProcedures be called by the current user?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1373 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::AllTablesAreSelectable | ( | ) | [inherited] |
Can all the tables returned by getTable be SELECTed by the current user?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1386 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::ClearCache | ( | const string | Key | ) | [inherited] |
Clears specific cached metadata.
Reimplemented from IZDatabaseMetadata.
Definition at line 1184 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::ClearCache | ( | ) | [inherited] |
Clears all cached metadata.
Reimplemented from IZDatabaseMetadata.
Definition at line 1173 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::CloneCachedResultSet | ( | IZResultSet | ResultSet | ) | [protected, inherited] |
Clones the cached resultset.
ResultSet | the resultset to be cloned. |
Definition at line 1326 of file ZDbcMetadata.pas.
IZVirtualResultSet TZAbstractDatabaseMetadata::ConstructVirtualResultSet | ( | TZMetadataColumnDefs | ColumnsDefs | ) | [protected, inherited] |
Constructs a virtual result set object.
ColumnsDefs | an array of column definition objects. |
Definition at line 1135 of file ZDbcMetadata.pas.
IZVirtualResultSet TZAbstractDatabaseMetadata::CopyToVirtualResultSet | ( | IZResultSet | SrcResultSet, | |
IZVirtualResultSet | DestResultSet | |||
) | [protected, inherited] |
Copies on result set to another one from the current position.
SrcResultSet | a source result set. | |
DestResultSet | a destination result set. |
Definition at line 1255 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::DataDefinitionCausesTransactionCommit | ( | ) |
Does a data definition statement within a transaction force the transaction to commit?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1717 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::DataDefinitionIgnoredInTransactions | ( | ) |
Is a data definition statement within a transaction ignored?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1729 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::DoesMaxRowSizeIncludeBlobs | ( | ) |
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1565 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::EscapeString | ( | const string | S | ) | [private] |
S | a string. |
Definition at line 519 of file ZDbcPostgreSqlMetadata.pas.
References P.
TZAbstractDatabaseMetadata::FillWildcards | ( | ) | [protected, inherited] |
Set the Wildcards character for WildcardsArray variable.
Overrride this method if the wildcards character is different in other database
Definition at line 5076 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetBestRowIdentifier | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Integer | Scope, | |||
Boolean | Nullable | |||
) | [inherited] |
Gets a description of a table's optimal set of columns that uniquely identifies a row.
They are ordered by SCOPE.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
scope | the scope of interest; use same values as SCOPE | |
nullable | include columns that are nullable? |
ResultSet
- each row is a column description Reimplemented from IZDatabaseMetadata.
Definition at line 3764 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetBestRowIdentifierCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const Integer | Scope, | |||
const Boolean | Nullable | |||
) | [inherited] |
returns cache key for GetBestRowIdentifier metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
Scope | the scope of interest | |
Nullable | include columns that are nullable? |
Definition at line 5292 of file ZDbcMetadata.pas.
TZAbstractDatabaseMetadata::GetCacheKeys | ( | TStrings | List | ) | [inherited] |
fills string list with the keys for the currently cached metadata entries
List | a string list to fill out |
Definition at line 5497 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetCatalogs | ( | ) | [inherited] |
Gets the catalog names available in this database.
The results are ordered by catalog name.
The catalog column is:
ResultSet
- each row has a single String column that is a catalog name Reimplemented from IZDatabaseMetadata.
Definition at line 3301 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetCatalogsCacheKey | ( | ) | [inherited] |
returns cache key for GetCatalogs metadata entry
Definition at line 5202 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetCatalogSeparator | ( | ) |
What's the separator between catalog and table name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1037 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetCatalogTerm | ( | ) |
What's the database vendor's preferred term for "catalog"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1025 of file ZDbcPostgreSqlMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetColumnPrivileges | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column privilege description Reimplemented from IZDatabaseMetadata.
Definition at line 3564 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetColumnPrivilegesCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetColumnPrivileges metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
ColumnNamePattern | a column name pattern |
Definition at line 5251 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of table columns available in the specified catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column description Reimplemented from IZDatabaseMetadata.
Definition at line 3448 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetColumnsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetColumns metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern | |
ColumnNamePattern | a column name pattern |
Definition at line 5230 of file ZDbcMetadata.pas.
IZConnection TZAbstractDatabaseMetadata::GetConnection | ( | ) | [inherited] |
Retrieves the connection that produced this metadata object.
Reimplemented from IZDatabaseMetadata.
Definition at line 1122 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetCrossReference | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [inherited] |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.
) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
primaryCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
primarySchema | a schema name; "" retrieves those without a schema | |
primaryTable | the table name that exports the key | |
foreignCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
foreignSchema | a schema name; "" retrieves those without a schema | |
foreignTable | the table name that imports the key |
ResultSet
- each row is a foreign key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4474 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetCrossReferenceCacheKey | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [inherited] |
returns cache key for GetCrossReference metadata entry
PrimaryCatalog | a catalog name for the primary table | |
PrimarySchema | a schema name for the primary table | |
PrimaryTable | the table name that exports the key | |
ForeignCatalog | a catalog name for the foreign table | |
ForeignSchema | a schema name for the foreign table | |
ForeignTable | the table name that imports the key |
Definition at line 5388 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetDatabaseProductName | ( | ) |
What's the name of this database product?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 593 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetDatabaseProductVersion | ( | ) |
What's the version of this database product?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 605 of file ZDbcPostgreSqlMetadata.pas.
TZTransactIsolationLevel TZPostgreSQLDatabaseMetadata::GetDefaultTransactionIsolation | ( | ) |
What's the database's default transaction isolation level? The values are defined in java.sql.Connection
.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1650 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetDriverMajorVersion | ( | ) |
What's this JDBC driver's major version number?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 629 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetDriverMinorVersion | ( | ) |
What's this JDBC driver's minor version number?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 641 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetDriverName | ( | ) |
What's the name of this JDBC driver?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 617 of file ZDbcPostgreSqlMetadata.pas.
string TZAbstractDatabaseMetadata::GetDriverVersion | ( | ) | [inherited] |
What's the version of this JDBC driver?
Reimplemented from IZDatabaseMetadata.
Definition at line 1520 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetExportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a foreign key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4298 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetExportedKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetExportedKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5367 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetExtraNameCharacters | ( | ) |
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 913 of file ZDbcPostgreSqlMetadata.pas.
IZIdentifierConvertor TZAbstractDatabaseMetadata::GetIdentifierConvertor | ( | ) | [inherited] |
Creates ab identifier convertor object.
Reimplemented from IZDatabaseMetadata.
Definition at line 5039 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetIdentifierQuoteString | ( | ) | [inherited] |
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
A JDBC Compliant<font size="-2">TM</font> driver always uses a double quote character.
Reimplemented from IZDatabaseMetadata.
Reimplemented in TZAdoDatabaseMetadata, TZMsSqlDatabaseMetadata, TZSybaseDatabaseMetadata, and TZMySQLDatabaseMetadata.
Definition at line 1689 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetImportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description Reimplemented from IZDatabaseMetadata.
Definition at line 4130 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetImportedKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetImportedKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5349 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetIndexInfo | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Boolean | Unique, | |||
Boolean | Approximate | |||
) | [inherited] |
Gets a description of a table's indices and statistics.
They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
unique | when true, return only indices for unique values; when false, return indices regardless of whether unique or not | |
approximate | when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate |
ResultSet
- each row is an index column description Reimplemented from IZDatabaseMetadata.
Definition at line 4760 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetIndexInfoCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const Boolean | Unique, | |||
const Boolean | Approximate | |||
) | [inherited] |
returns cache key for GetIndexInfo metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name | |
Unique | when true, return key for a metadata entry that should contain only indices for unique values; when false, return key for a metadata entry that may contain indices to non-unique values | |
Approximate | when true, return key for a metadata entry that may include approximate or out of data values; when false, return key for a metadata entry that should contain only accurate results |
Definition at line 5429 of file ZDbcMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxBinaryLiteralLength | ( | ) |
How many hex characters can you have in an inline binary literal?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1366 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxCatalogNameLength | ( | ) |
What's the maximum length of a catalog name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1537 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxCharLiteralLength | ( | ) |
What's the max length for a character literal?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1379 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnNameLength | ( | ) |
What's the limit on column name length?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1392 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnsInGroupBy | ( | ) |
What's the maximum number of columns in a "GROUP BY" clause?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1405 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnsInIndex | ( | ) |
What's the maximum number of columns allowed in an index?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1418 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnsInOrderBy | ( | ) |
What's the maximum number of columns in an "ORDER BY" clause?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1431 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnsInSelect | ( | ) |
What's the maximum number of columns in a "SELECT" list?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1444 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxColumnsInTable | ( | ) |
What's the maximum number of columns in a table?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1457 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxConnections | ( | ) |
How many active connections can we have at a time to this database?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1470 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxCursorNameLength | ( | ) |
What's the maximum cursor name length?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1483 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxIndexKeys | ( | ) | [protected] |
Integer TZPostgreSQLDatabaseMetadata::GetMaxIndexLength | ( | ) |
Retrieves the maximum number of bytes for an index, including all of the parts of the index.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1498 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxNameLength | ( | ) | [protected] |
Integer TZPostgreSQLDatabaseMetadata::GetMaxProcedureNameLength | ( | ) |
What's the maximum length of a procedure name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1524 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxRowSize | ( | ) |
What's the maximum length of a single row?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1550 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxSchemaNameLength | ( | ) |
What's the maximum length allowed for a schema name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1511 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxStatementLength | ( | ) |
What's the maximum length of an SQL statement?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1578 of file ZDbcPostgreSqlMetadata.pas.
References P.
Integer TZPostgreSQLDatabaseMetadata::GetMaxStatements | ( | ) |
How many active statements can we have open at one time to this database?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1594 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxTableNameLength | ( | ) |
What's the maximum length of a table name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1607 of file ZDbcPostgreSqlMetadata.pas.
References P.
Integer TZPostgreSQLDatabaseMetadata::GetMaxTablesInSelect | ( | ) |
What's the maximum number of tables in a SELECT statement?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1620 of file ZDbcPostgreSqlMetadata.pas.
Integer TZPostgreSQLDatabaseMetadata::GetMaxUserNameLength | ( | ) |
What's the maximum length of a user name?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1633 of file ZDbcPostgreSqlMetadata.pas.
References P.
string TZPostgreSQLDatabaseMetadata::GetNumericFunctions | ( | ) |
Gets a comma-separated list of math functions.
These are the X/Open CLI math function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 841 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetPostgreSQLType | ( | Integer | Oid | ) | [protected] |
IZResultSet TZAbstractDatabaseMetadata::GetPrimaryKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of a table's primary key columns.
They are ordered by COLUMN_NAME.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description SQLException | if a database access error occurs |
Reimplemented from IZDatabaseMetadata.
Definition at line 4007 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetPrimaryKeysCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetPrimaryKeys metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5331 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetPrivilegeName | ( | char | Permission | ) | [protected] |
IZResultSet TZAbstractDatabaseMetadata::GetProcedureColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
Gets a description of a catalog's stored procedure parameters and result columns.
Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description or column description with the following fields:
ResultSet
Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row describes a stored procedure parameter or column Reimplemented from IZDatabaseMetadata.
Definition at line 3049 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetProcedureColumnsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [inherited] |
returns cache key for GetProcedureColumns metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
ProcedureNamePattern | a procedure name pattern | |
ColumnNamePattern | a column name pattern |
Definition at line 5140 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetProcedures | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [inherited] |
Gets a description of the stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern |
ResultSet
- each row is a procedure description Reimplemented from IZDatabaseMetadata.
Definition at line 2926 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetProceduresCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [inherited] |
returns cache key for GetProcedures metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
ProcedureNamePattern | a procedure name pattern |
Definition at line 5120 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetProcedureTerm | ( | ) |
What's the database vendor's preferred term for "procedure"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1013 of file ZDbcPostgreSqlMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetResultSetFromCache | ( | const string | Key | ) | [protected, inherited] |
Gets a resultset interface from the internal cache by key.
Key | a resultset unique key value. |
nil
otherwise. Definition at line 1229 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetSchemas | ( | ) | [inherited] |
Gets the schema names available in this database.
The results are ordered by schema name.
The schema column is:
ResultSet
- each row has a single String column that is a schema name Reimplemented from IZDatabaseMetadata.
Definition at line 3249 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetSchemasCacheKey | ( | ) | [inherited] |
returns cache key for GetSchemas metadata entry
Definition at line 5190 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetSchemaTerm | ( | ) |
What's the database vendor's preferred term for "schema"?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1001 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetSearchStringEscape | ( | ) |
Gets the string that can be used to escape wildcard characters.
This is the string that can be used to escape '_' or '' in the string pattern style catalog search parameters.
The '_' character represents any single character.
The '' character represents any sequence of zero or more characters.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 900 of file ZDbcPostgreSqlMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetSequences | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [inherited] |
string TZAbstractDatabaseMetadata::GetSequencesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [inherited] |
returns cache key for GetSequences metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
SequenceNamePattern | a sequence name pattern |
Definition at line 5450 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetSQLKeywords | ( | ) |
Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 772 of file ZDbcPostgreSqlMetadata.pas.
TZSQLType TZPostgreSQLDatabaseMetadata::GetSQLTypeByName | ( | string | TypeName | ) | [protected] |
TZSQLType TZPostgreSQLDatabaseMetadata::GetSQLTypeByOid | ( | Integer | Oid | ) | [protected] |
string TZPostgreSQLDatabaseMetadata::GetStringFunctions | ( | ) |
Gets a comma-separated list of string functions.
These are the X/Open CLI string function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 855 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetSystemFunctions | ( | ) |
Gets a comma-separated list of system functions.
These are the X/Open CLI system function names used in the JDBC function escape clause.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 869 of file ZDbcPostgreSqlMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTablePrivileges | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [inherited] |
Gets a description of the access rights for each table available in a catalog.
Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern |
ResultSet
- each row is a table privilege description Reimplemented from IZDatabaseMetadata.
Definition at line 3661 of file ZDbcMetadata.pas.
References P.
string TZAbstractDatabaseMetadata::GetTablePrivilegesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [inherited] |
returns cache key for GetTablePrivileges metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern |
Definition at line 5271 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTables | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [inherited] |
Gets a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
Note: Some databases may not return information for all tables.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
types | a list of table types to include; null returns all types |
ResultSet
- each row is a table description Reimplemented from IZDatabaseMetadata.
Definition at line 3172 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTablesCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [inherited] |
returns cache key for GetTables metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TableNamePattern | a table name pattern | |
Types | table types list |
Definition at line 5161 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTableTypes | ( | ) | [inherited] |
Gets the table types available in this database.
The results are ordered by table type.
The table type is:
ResultSet
- each row has a single String column that is a table type Reimplemented from IZDatabaseMetadata.
Definition at line 3355 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTableTypesCacheKey | ( | ) | [inherited] |
returns cache key for GetTableTypes metadata entry
Definition at line 5214 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::GetTimeDateFunctions | ( | ) |
Gets a comma-separated list of time and date functions.
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 881 of file ZDbcPostgreSqlMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetTypeInfo | ( | ) | [inherited] |
Gets a description of all the standard SQL types supported by this database.
They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
ResultSet
- each row is an SQL type description Reimplemented from IZDatabaseMetadata.
Definition at line 4636 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetTypeInfoCacheKey | ( | ) | [inherited] |
returns cache key for GetTypeInfo metadata entry
Definition at line 5408 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetUDTs | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [inherited] |
Gets a description of the user-defined types defined in a particular schema.
Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
Note: If the driver does not support UDTs, an empty result set is returned.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
typeNamePattern | a type name pattern; may be a fully-qualified name | |
types | a list of user-named types to include (JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types |
ResultSet
- each row is a type description Reimplemented from IZDatabaseMetadata.
Definition at line 4962 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetUDTsCacheKey | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [inherited] |
returns cache key for GetUDTs metadata entry
Catalog | a catalog name | |
SchemaPattern | a schema name pattern | |
TypeNamePattern | a type name pattern | |
Types | a list of user-named types to include |
Definition at line 5470 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetURL | ( | ) | [inherited] |
What's the url for this database?
Reimplemented from IZDatabaseMetadata.
Definition at line 1398 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetUserName | ( | ) | [inherited] |
What's our user name as known to the database?
Reimplemented from IZDatabaseMetadata.
Definition at line 1410 of file ZDbcMetadata.pas.
IZResultSet TZAbstractDatabaseMetadata::GetVersionColumns | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
Gets a description of a table's columns that are automatically updated when any value in a row is updated.
They are unordered.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a column description SQLException | if a database access error occurs |
Reimplemented from IZDatabaseMetadata.
Definition at line 3921 of file ZDbcMetadata.pas.
string TZAbstractDatabaseMetadata::GetVersionColumnsCacheKey | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [inherited] |
returns cache key for GetVersionColumns metadata entry
Catalog | a catalog name | |
Schema | a schema name | |
Table | a table name |
Definition at line 5313 of file ZDbcMetadata.pas.
TZWildcardsSet TZAbstractDatabaseMetadata::GetWildcardsSet | ( | ) | [protected, inherited] |
Get the Wildscards in set of char type.
Definition at line 5094 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::HaveMinimumServerVersion | ( | Integer | MajorVersion, | |
Integer | MinorVersion | |||
) | [protected] |
Boolean TZAbstractDatabaseMetadata::IsCatalogAtStart | ( | ) | [inherited] |
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end).
Reimplemented from IZDatabaseMetadata.
Definition at line 2185 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::IsReadOnly | ( | ) | [inherited] |
Is the database in read-only mode?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1424 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullPlusNonNullIsNull | ( | ) | [inherited] |
Are concatenations between NULL and non-NULL values NULL? For SQL-92 compliance, a JDBC technology-enabled driver will return true
.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1846 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedAtEnd | ( | ) | [inherited] |
Are NULL values sorted at the end regardless of sort order?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1472 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedAtStart | ( | ) | [inherited] |
Are NULL values sorted at the start regardless of sort order?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Reimplemented in TZASADatabaseMetadata.
Definition at line 1460 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedHigh | ( | ) | [inherited] |
Are NULL values sorted high?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1436 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::NullsAreSortedLow | ( | ) | [inherited] |
Are NULL values sorted low?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1448 of file ZDbcMetadata.pas.
TZPostgreSQLDatabaseMetadata::ParseACLArray | ( | TStrings | List, | |
string | AclString | |||
) | [protected] |
Boolean TZPostgreSQLDatabaseMetadata::StoresLowerCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 693 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::StoresLowerCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 746 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::StoresMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 706 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::StoresMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 759 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::StoresUpperCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 680 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::StoresUpperCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 733 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsAlterTableWithAddColumn | ( | ) | [inherited] |
Is "ALTER TABLE" with add column supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1803 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsAlterTableWithDropColumn | ( | ) | [inherited] |
Is "ALTER TABLE" with drop column supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1815 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92EntryLevelSQL | ( | ) | [inherited] |
Is the ANSI92 entry level SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2063 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92FullSQL | ( | ) | [inherited] |
Is the ANSI92 full SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2087 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsANSI92IntermediateSQL | ( | ) | [inherited] |
Is the ANSI92 intermediate SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2075 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsBatchUpdates | ( | ) | [inherited] |
Indicates whether the driver supports batch updates.
Reimplemented from IZDatabaseMetadata.
Definition at line 4919 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCatalogsInDataManipulation | ( | ) |
Can a catalog name be used in a data manipulation statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1109 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCatalogsInIndexDefinitions | ( | ) |
Can a catalog name be used in an index definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1145 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCatalogsInPrivilegeDefinitions | ( | ) |
Can a catalog name be used in a privilege definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1157 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCatalogsInProcedureCalls | ( | ) |
Can a catalog name be used in a procedure call statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1121 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCatalogsInTableDefinitions | ( | ) |
Can a catalog name be used in a table definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1133 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsColumnAliasing | ( | ) | [inherited] |
Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required. A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1832 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsConvert | ( | ) | [inherited] |
Is the CONVERT function between SQL types supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1858 of file ZDbcMetadata.pas.
References P.
Boolean TZAbstractDatabaseMetadata::SupportsConvertForTypes | ( | TZSQLType | FromType, | |
TZSQLType | ToType | |||
) | [inherited] |
Is CONVERT between the given SQL types supported?
fromType | the type to convert from | |
toType | the type to convert to |
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1873 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsCoreSQLGrammar | ( | ) | [inherited] |
Is the ODBC Core SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2038 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsCorrelatedSubqueries | ( | ) |
Are correlated subqueries supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1271 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsDataDefinitionAndDataManipulationTransactions | ( | ) |
Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZPostgreSQLDatabaseMetadata::SupportsDataManipulationTransactionsOnly | ( | ) |
Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZAbstractDatabaseMetadata::SupportsDifferentTableCorrelationNames | ( | ) | [inherited] |
If table correlation names are supported, are they restricted to be different from the names of the tables?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1901 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsExpressionsInOrderBy | ( | ) |
Are expressions in "ORDER BY" lists supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 928 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsExtendedSQLGrammar | ( | ) | [inherited] |
Is the ODBC Extended SQL grammar supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2050 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsFullOuterJoins | ( | ) | [inherited] |
Are full nested outer joins supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2123 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsGroupBy | ( | ) |
Is some form of "GROUP BY" clause supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 952 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsGroupByBeyondSelect | ( | ) |
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 977 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsGroupByUnrelated | ( | ) |
Can a "GROUP BY" clause use columns not in the SELECT?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 964 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsIntegrityEnhancementFacility | ( | ) |
Is the SQL Integrity Enhancement Facility supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 989 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsLikeEscapeClause | ( | ) | [inherited] |
Is the escape character in "LIKE" clauses supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1975 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsLimitedOuterJoins | ( | ) | [inherited] |
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.
)
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2136 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMinimumSQLGrammar | ( | ) | [inherited] |
Is the ODBC Minimum SQL grammar supported? All JDBC Compliant<font size="-2">TM</font> drivers must return true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2026 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return false.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 667 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC Compliant<font size="-2">TM</font> driver will always return true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 720 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMultipleResultSets | ( | ) | [inherited] |
Are multiple ResultSet
from a single execute supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1987 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsMultipleTransactions | ( | ) | [inherited] |
Can we have multiple transactions open at once (on different connections)?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2000 of file ZDbcMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsNonNullableColumns | ( | ) | [inherited] |
Can columns be defined as non-nullable? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2013 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsOpenCursorsAcrossCommit | ( | ) |
Can cursors remain open across commits?
true
if cursors always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1308 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsOpenCursorsAcrossRollback | ( | ) |
Can cursors remain open across rollbacks?
true
if cursors always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1321 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsOpenStatementsAcrossCommit | ( | ) |
Can statements remain open across commits?
true
if statements always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1334 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsOpenStatementsAcrossRollback | ( | ) |
Can statements remain open across rollbacks?
true
if statements always remain open; false
if they might not remain open Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1347 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsOrderByUnrelated | ( | ) |
Can an "ORDER BY" clause use columns not in the SELECT statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 940 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsOuterJoins | ( | ) | [inherited] |
Is some form of outer join supported?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 2111 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsPositionedDelete | ( | ) |
Is positioned DELETE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1169 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsPositionedUpdate | ( | ) |
Is positioned UPDATE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1181 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsResultSetConcurrency | ( | TZResultSetType | _Type, | |
TZResultSetConcurrency | Concurrency | |||
) |
Does the database support the concurrency type in combination with the given result set type?
type | defined in java.sql.ResultSet | |
concurrency | type defined in java.sql.ResultSet |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZPostgreSQLDatabaseMetadata::SupportsResultSetType | ( | TZResultSetType | _Type | ) |
Does the database support the given result set type?
type | defined in java.sql.ResultSet |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSchemasInDataManipulation | ( | ) |
Can a schema name be used in a data manipulation statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1049 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSchemasInIndexDefinitions | ( | ) |
Can a schema name be used in an index definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1085 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSchemasInPrivilegeDefinitions | ( | ) |
Can a schema name be used in a privilege definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1097 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSchemasInProcedureCalls | ( | ) |
Can a schema name be used in a procedure call statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1061 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSchemasInTableDefinitions | ( | ) |
Can a schema name be used in a table definition statement?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1073 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSelectForUpdate | ( | ) |
Is SELECT for UPDATE supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1193 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsStoredProcedures | ( | ) |
Are stored procedure calls using the stored procedure escape syntax supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1206 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSubqueriesInComparisons | ( | ) |
Are subqueries in comparison expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1219 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSubqueriesInExists | ( | ) |
Are subqueries in 'exists' expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1232 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSubqueriesInIns | ( | ) |
Are subqueries in 'in' statements supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1245 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsSubqueriesInQuantifieds | ( | ) |
Are subqueries in quantified expressions supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1258 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::SupportsTableCorrelationNames | ( | ) | [inherited] |
Are table correlation names supported? A JDBC Compliant<font size="-2">TM</font> driver always returns true.
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Definition at line 1888 of file ZDbcMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsTransactionIsolationLevel | ( | TZTransactIsolationLevel | Level | ) |
Does this database support the given transaction isolation level?
level | the values are defined in java.sql.Connection |
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1677 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsTransactions | ( | ) |
Are transactions supported? If not, invoking the method commit
is a noop and the isolation level is TRANSACTION_NONE.
true
if transactions are supported; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1663 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsUnion | ( | ) |
Is SQL UNION supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1283 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZPostgreSQLDatabaseMetadata::SupportsUnionAll | ( | ) |
Is SQL UNION ALL supported?
true
if so; false
otherwise Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 1295 of file ZDbcPostgreSqlMetadata.pas.
string TZPostgreSQLDatabaseMetadata::TableTypeSQLExpression | ( | string | TableType, | |
Boolean | UseSchemas | |||
) | [protected] |
IZResultSet TZAbstractDatabaseMetadata::UncachedGetBestRowIdentifier | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Integer | Scope, | |||
Boolean | Nullable | |||
) | [protected, inherited] |
Gets a description of a table's optimal set of columns that uniquely identifies a row.
They are ordered by SCOPE.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
scope | the scope of interest; use same values as SCOPE | |
nullable | include columns that are nullable? |
ResultSet
- each row is a column description Definition at line 3826 of file ZDbcMetadata.pas.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetCatalogs | ( | ) | [protected] |
Gets the catalog names available in this database.
The results are ordered by catalog name.
The catalog column is:
ResultSet
- each row has a single String column that is a catalog name Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetColumnPrivileges | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column privilege description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of table columns available in the specified catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row is a column description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetCrossReference | ( | const string | PrimaryCatalog, | |
const string | PrimarySchema, | |||
const string | PrimaryTable, | |||
const string | ForeignCatalog, | |||
const string | ForeignSchema, | |||
const string | ForeignTable | |||
) | [protected] |
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.
) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
primaryCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
primarySchema | a schema name; "" retrieves those without a schema | |
primaryTable | the table name that exports the key | |
foreignCatalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
foreignSchema | a schema name; "" retrieves those without a schema | |
foreignTable | the table name that imports the key |
ResultSet
- each row is a foreign key column description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetExportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a foreign key column description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetImportedKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetIndexInfo | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table, | |||
Boolean | Unique, | |||
Boolean | Approximate | |||
) | [protected] |
Gets a description of a table's indices and statistics.
They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name | |
unique | when true, return only indices for unique values; when false, return indices regardless of whether unique or not | |
approximate | when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate |
ResultSet
- each row is an index column description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetPrimaryKeys | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of a table's primary key columns.
They are ordered by COLUMN_NAME.
Each primary key column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a primary key column description SQLException | if a database access error occurs |
Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetProcedureColumns | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern, | |||
const string | ColumnNamePattern | |||
) | [protected] |
Gets a description of a catalog's stored procedure parameters and result columns.
Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description or column description with the following fields:
ResultSet
Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern | |
columnNamePattern | a column name pattern |
ResultSet
- each row describes a stored procedure parameter or column Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetProcedures | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | ProcedureNamePattern | |||
) | [protected] |
Gets a description of the stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
procedureNamePattern | a procedure name pattern |
ResultSet
- each row is a procedure description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetSchemas | ( | ) | [protected] |
Gets the schema names available in this database.
The results are ordered by schema name.
The schema column is:
ResultSet
- each row has a single String column that is a schema name Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetSequences | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | SequenceNamePattern | |||
) | [protected] |
Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetTablePrivileges | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern | |||
) | [protected] |
Gets a description of the access rights for each table available in a catalog.
Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilige description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern |
ResultSet
- each row is a table privilege description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetTables | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TableNamePattern, | |||
const TStringDynArray | Types | |||
) | [protected] |
Gets a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
Note: Some databases may not return information for all tables.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
tableNamePattern | a table name pattern | |
types | a list of table types to include; null returns all types |
ResultSet
- each row is a table description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetTableTypes | ( | ) | [protected] |
Gets the table types available in this database.
The results are ordered by table type.
The table type is:
ResultSet
- each row has a single String column that is a table type Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetTypeInfo | ( | ) | [protected] |
Gets a description of all the standard SQL types supported by this database.
They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
ResultSet
- each row is an SQL type description Reimplemented from TZAbstractDatabaseMetadata.
IZResultSet TZAbstractDatabaseMetadata::UncachedGetUDTs | ( | const string | Catalog, | |
const string | SchemaPattern, | |||
const string | TypeNamePattern, | |||
const TIntegerDynArray | Types | |||
) | [protected, inherited] |
Gets a description of the user-defined types defined in a particular schema.
Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
Note: If the driver does not support UDTs, an empty result set is returned.
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schemaPattern | a schema name pattern; "" retrieves those without a schema | |
typeNamePattern | a type name pattern; may be a fully-qualified name | |
types | a list of user-named types to include (JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types |
ResultSet
- each row is a type description Reimplemented in TZAdoDatabaseMetadata, TZASADatabaseMetadata, TZMsSqlDatabaseMetadata, and TZSybaseDatabaseMetadata.
Definition at line 5022 of file ZDbcMetadata.pas.
IZResultSet TZPostgreSQLDatabaseMetadata::UncachedGetVersionColumns | ( | const string | Catalog, | |
const string | Schema, | |||
const string | Table | |||
) | [protected] |
Gets a description of a table's columns that are automatically updated when any value in a row is updated.
They are unordered.
Each column description has the following columns:
catalog | a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria | |
schema | a schema name; "" retrieves those without a schema | |
table | a table name |
ResultSet
- each row is a column description SQLException | if a database access error occurs |
Reimplemented from TZAbstractDatabaseMetadata.
Boolean TZPostgreSQLDatabaseMetadata::UsesLocalFilePerTable | ( | ) |
Does the database use a file for each table?
Reimplemented from TZAbstractDatabaseMetadata.
Definition at line 653 of file ZDbcPostgreSqlMetadata.pas.
Boolean TZAbstractDatabaseMetadata::UsesLocalFiles | ( | ) | [inherited] |
Does the database store tables in a local file?
true
if so; false
otherwise Reimplemented from IZDatabaseMetadata.
Reimplemented in TZASADatabaseMetadata.
Definition at line 1556 of file ZDbcMetadata.pas.
IZHashMap TZAbstractDatabaseMetadata::CachedResultSets [protected, inherited] |
FCachedResultSets For writing
Definition at line 214 of file ZDbcMetadata.pas.
string TZPostgreSQLDatabaseMetadata::FDatabase [private] |
Definition at line 77 of file ZDbcPostgreSqlMetadata.pas.
TStrings TZAbstractDatabaseMetadata::Info [protected, inherited] |
string TZAbstractDatabaseMetadata::Url [protected, inherited] |