Thread: [pgsqlclient-checkins] SF.net SVN: pgsqlclient: [113] trunk/PostgreSqlClient/source/PostgreSql/Data/
Status: Inactive
Brought to you by:
carlosga_fb
Menu
▾
▴
pgsqlclient-checkins
|
From: <car...@us...> - 2006-04-13 14:40:06
|
Revision: 113 Author: carlosga_fb Date: 2006-04-13 07:39:55 -0700 (Thu, 13 Apr 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=113&view=rev Log Message: ----------- Modified Paths: -------------- trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml Modified: trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml =================================================================== --- trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml 2006-04-13 14:39:19 UTC (rev 112) +++ trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml 2006-04-13 14:39:55 UTC (rev 113) @@ -890,7 +890,7 @@ </DataTypes> <DataTypes> <TypeName>text</TypeName> - <ProviderDbType>27</ProviderDbType> + <ProviderDbType>22</ProviderDbType> <ColumnSize>2147483647</ColumnSize> <CreateFormat /> <CreateParameters>length</CreateParameters> @@ -964,7 +964,7 @@ <DbType>6</DbType> </DataTypes> <DataTypes> - <TypeName>timestamp</TypeName> + <TypeName>time</TypeName> <ProviderDbType>23</ProviderDbType> <ColumnSize>8</ColumnSize> <CreateFormat /> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-05-19 08:36:20
|
Revision: 147 Author: carlosga_fb Date: 2006-05-19 01:36:12 -0700 (Fri, 19 May 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=147&view=rev Log Message: ----------- Updated data types schema Modified Paths: -------------- trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml Modified: trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml =================================================================== --- trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml 2006-05-18 19:52:22 UTC (rev 146) +++ trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml 2006-05-19 08:36:12 UTC (rev 147) @@ -1,1188 +1,1213 @@ <?xml version="1.0" standalone="yes"?> <NewDataSet> - <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> - <xs:element name="NewDataSet" msdata:IsDataSet="true"> - <xs:complexType> - <xs:choice minOccurs="0" maxOccurs="unbounded"> - <xs:element name="MetaDataCollections" msdata:MinimumCapacity="9"> - <xs:complexType> - <xs:sequence> - <xs:element name="CollectionName" type="xs:string" minOccurs="0" /> - <xs:element name="NumberOfRestrictions" type="xs:int" minOccurs="0" /> - <xs:element name="NumberOfIdentifierParts" type="xs:int" minOccurs="0" /> - <xs:element name="PopulationMechanism" type="xs:string" minOccurs="0" /> - <xs:element name="PopulationString" type="xs:string" minOccurs="0" /> - <xs:element name="MinimumVersion" type="xs:string" minOccurs="0" /> - <xs:element name="MaximumVersion" type="xs:string" minOccurs="0" /> - </xs:sequence> - </xs:complexType> - </xs:element> - <xs:element name="Restrictions" msdata:MinimumCapacity="3"> - <xs:complexType> - <xs:sequence> - <xs:element name="CollectionName" type="xs:string" minOccurs="0" /> - <xs:element name="RestrictionName" type="xs:string" minOccurs="0" /> - <xs:element name="RestrictionDefault" type="xs:string" minOccurs="0" /> - <xs:element name="RestrictionNumber" type="xs:int" minOccurs="0" /> - <xs:element name="MinimumVersion" type="xs:string" minOccurs="0" /> - <xs:element name="MaximumVersion" type="xs:string" minOccurs="0" /> - </xs:sequence> - </xs:complexType> - </xs:element> - <xs:element name="DataSourceInformation" msdata:MinimumCapacity="18"> - <xs:complexType> - <xs:sequence> - <xs:element name="CompositeIdentifierSeparatorPattern" type="xs:string" minOccurs="0" /> - <xs:element name="DataSourceProductName" type="xs:string" minOccurs="0" /> - <xs:element name="DataSourceProductVersion" type="xs:string" minOccurs="0" /> - <xs:element name="DataSourceProductVersionNormalized" type="xs:string" minOccurs="0" /> - <xs:element name="GroupByBehavior" msdata:DataType="System.Data.Common.GroupByBehavior, System.Data, Version=2.0.3500.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" /> - <xs:element name="IdentifierPattern" type="xs:string" minOccurs="0" /> - <xs:element name="IdentifierCase" msdata:DataType="System.Data.Common.IdentifierCase, System.Data, Version=2.0.3500.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" /> - <xs:element name="OrderByColumnsInSelect" type="xs:boolean" minOccurs="0" /> - <xs:element name="ParameterMarkerFormat" type="xs:string" minOccurs="0" /> - <xs:element name="ParameterMarkerPattern" type="xs:string" minOccurs="0" /> - <xs:element name="ParameterNameMaxLength" type="xs:int" minOccurs="0" /> - <xs:element name="ParameterNamePattern" type="xs:string" minOccurs="0" /> - <xs:element name="QuotedIdentifierPattern" type="xs:string" minOccurs="0" /> - <xs:element name="QuotedIdentifierCase" msdata:DataType="System.Data.Common.IdentifierCase, System.Data, Version=2.0.3500.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" /> - <xs:element name="StatementSeparatorPattern" type="xs:string" minOccurs="0" /> - <xs:element name="StringLiteralPattern" type="xs:string" minOccurs="0" /> - <xs:element name="SupportedJoinOperators" msdata:DataType="System.Data.Common.SupportedJoinOperators, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" /> - </xs:sequence> - </xs:complexType> - </xs:element> - <xs:element name="DataTypes" msdata:MinimumCapacity="18"> - <xs:complexType> - <xs:sequence> - <xs:element name="TypeName" type="xs:string" minOccurs="0" /> - <xs:element name="ProviderDbType" type="xs:int" minOccurs="0" /> - <xs:element name="ColumnSize" type="xs:long" minOccurs="0" /> - <xs:element name="CreateFormat" type="xs:string" minOccurs="0" /> - <xs:element name="CreateParameters" type="xs:string" minOccurs="0" /> - <xs:element name="DataType" type="xs:string" minOccurs="0" /> - <xs:element name="IsAutoIncrementable" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsBestMatch" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsCaseSensitive" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsFixedLength" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsFixedPrecisionScale" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsLong" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsNullable" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsSearchable" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsSearchableWithLike" type="xs:boolean" minOccurs="0" /> - <xs:element name="IsUnsigned" type="xs:boolean" minOccurs="0" /> - <xs:element name="MaximumScale" type="xs:short" minOccurs="0" /> - <xs:element name="MinimumScale" type="xs:short" minOccurs="0" /> - <xs:element name="IsConcurrencyType" type="xs:boolean" minOccurs="0" /> - <xs:element name="MaximumVersion" type="xs:string" minOccurs="0" /> - <xs:element name="MinimumVersion" type="xs:string" minOccurs="0" /> - <xs:element name="IsLiteralSupported" type="xs:boolean" minOccurs="0" /> - <xs:element name="LiteralPrefix" type="xs:string" minOccurs="0" /> - <xs:element name="LiteralSuffix" type="xs:string" minOccurs="0" /> - <xs:element name="DbType" type="xs:int" minOccurs="0" /> - </xs:sequence> - </xs:complexType> - </xs:element> - <xs:element name="ReservedWords" msdata:MinimumCapacity="3"> - <xs:complexType> - <xs:sequence> - <xs:element name="ReservedWord" type="xs:string" minOccurs="0" /> - <xs:element name="MaximumVersion" type="xs:string" minOccurs="0" /> - <xs:element name="MinimumVersion" type="xs:string" minOccurs="0" /> - </xs:sequence> - </xs:complexType> - </xs:element> - </xs:choice> - </xs:complexType> - </xs:element> - </xs:schema> - <MetaDataCollections> - <CollectionName>Aggregates</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_aggregate.aggfnoid AS AGGREGATE_FUNCTION, pg_aggregate.aggtransfn AS TRANSITION_FUNCTION, pg_aggregate.aggfinalfn AS FINAL_FUNCTION, pg_aggregate.agginitval AS INITIAL_VALUE, pg_type.typname AS BASE_TYPE FROM pg_aggregate left join pg_type ON pg_aggregate.aggtranstype = pg_type.oid ORDER BY pg_aggregate.aggfnoid</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Casts</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_typesrc.typname AS SOURCE_TYPE, pg_typetgt.typname AS TARGET_TYPE, pg_namespace.nspname AS FUNCTION_SCHEMA, pg_proc.proname AS FUNCTION_NAME, case pg_cast.castcontext when 'e' THEN 'EXPLICIT' when 'a' THEN 'ASSIGNMENT' when 'i' THEN 'EXPRESSIONS' END AS CAST_CONTEXT FROM pg_cast left join pg_type as pg_typesrc ON pg_cast.castsource = pg_typesrc.oid left join pg_type as pg_typetgt ON pg_cast.casttarget = pg_typetgt.oid left join pg_proc ON pg_cast.castfunc = pg_proc.oid left join pg_namespace ON pg_proc.pronamespace = pg_namespace.oid ORDER BY pg_proc.proname</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>CheckConstraints</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Columns</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Databases</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_database.datname AS DATABASE_NAME, pg_database.datistemplate AS IS_TEMPLATE, pg_database.datallowconn AS ALLOW_CONNECTION, pg_database.datconfig AS DATABASE_CONFIG FROM pg_database</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>DataSourceInformation</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>DataTable</PopulationMechanism> - <PopulationString>DataSourceInformation</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>DataTypes</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>DataTable</PopulationMechanism> - <PopulationString>DataTypes</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>ForeignKeys</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>ForeignKeyColumns</CollectionName> - <NumberOfRestrictions>5</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Functions</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>FunctionParameters</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Groups</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_group.groname AS GROUP_NAME, pg_group.grolist AS GROUP_USERS FROM pg_group ORDER BY pg_group.groname</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Indexes</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>IndexColumns</CollectionName> - <NumberOfRestrictions>5</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>MetaDataCollections</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>DataTable</PopulationMechanism> - <PopulationString>MetaDataCollections</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>PrimaryKeys</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>ReservedWords</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>DataTable</PopulationMechanism> - <PopulationString>ReservedWords</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Restrictions</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>DataTable</PopulationMechanism> - <PopulationString>Restrictions</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Schemas</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT current_database() AS SCHEMA_CATALOG, pg_namespace.nspname AS SCHEMA_NAME, pg_shadow.usename AS SCHEMA_OWNER, pg_description.description AS DESCRIPTION, CASE WHEN nspname LIKE 'pg\\_temp\\_%%' THEN 1 WHEN (nspname LIKE 'pg\\_%' OR nspname = 'information_schema') THEN 0 ELSE 3 END AS SCHEMA_TYPE FROM pg_namespace left join pg_shadow ON pg_namespace.nspowner = pg_shadow.usesysid left join pg_description ON pg_namespace.oid = pg_description.objoid ORDER BY pg_namespace.nspname, pg_shadow.usename</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Sequences</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>SqlLanguages</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_language.lanname AS LANGUAGE_NAME, pg_language.lanispl AS IS_USER_DEFINED, pg_proc.proname AS CALL_FUNCTION, pg_procv.proname AS VALIDATOR, pg_description.description AS DESCRIPTION FROM pg_language left join pg_proc ON pg_language.lanplcallfoid = pg_proc.oid left join pg_proc as pg_procv ON pg_language.lanvalidator = pg_procv.oid left join pg_description ON pg_language.oid = pg_description.objoid ORDER BY pg_language.lanname</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Tables</CollectionName> - <NumberOfRestrictions>5</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>TableConstraints</CollectionName> - <NumberOfRestrictions>7</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>TableSpaces</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT spcname as TABLESPACE_NAME from pg_tablespace</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Triggers</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>UniqueKeys</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Users</CollectionName> - <NumberOfRestrictions>0</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>SQLCommand</PopulationMechanism> - <PopulationString>SELECT pg_shadow.usename AS USER_NAME, pg_shadow.usecreatedb AS CREATE_DATABASE, pg_shadow.usesuper AS IS_SUPERUSER, pg_shadow.usecatupd AS UPDATE_SYSCATALOGS, pg_shadow.passwd AS PASSWORD, pg_shadow.useconfig AS CONFIGURATION FROM pg_shadow ORDER BY pg_shadow.usename</PopulationString> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>Views</CollectionName> - <NumberOfRestrictions>3</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <MetaDataCollections> - <CollectionName>ViewColumns</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> - <NumberOfIdentifierParts>0</NumberOfIdentifierParts> - <PopulationMechanism>PrepareCollection</PopulationMechanism> - </MetaDataCollections> - <Restrictions> - <CollectionName>CheckConstraints</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>constraint_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>CheckConstraints</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>constraint_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>CheckConstraints</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>constraint_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Columns</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Columns</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Columns</CollectionName> - <RestrictionName>Table</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Columns</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>column_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Indexes</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Indexes</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Indexes</CollectionName> - <RestrictionName>TableName</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Indexes</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>index_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>IndexColumns</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>IndexColumns</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>IndexColumns</CollectionName> - <RestrictionName>TableName</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>IndexColumns</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>index_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>IndexColumns</CollectionName> - <RestrictionName>ColumnName</RestrictionName> - <RestrictionDefault>column_name</RestrictionDefault> - <RestrictionNumber>5</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Functions</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>function_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Functions</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>function_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Functions</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>function_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>FunctionParameters</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>function_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>FunctionParameters</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>function_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>FunctionParameters</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>function_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeys</CollectionName> - <RestrictionName>ConstraintCatalog</RestrictionName> - <RestrictionDefault>constraint_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeys</CollectionName> - <RestrictionName>ConstraintSchema</RestrictionName> - <RestrictionDefault>constraint_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeys</CollectionName> - <RestrictionName>TableName</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeys</CollectionName> - <RestrictionName>ConstraintName</RestrictionName> - <RestrictionDefault>constraint_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeyColumns</CollectionName> - <RestrictionName>ConstraintCatalog</RestrictionName> - <RestrictionDefault>constraint_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeyColumns</CollectionName> - <RestrictionName>ConstraintSchema</RestrictionName> - <RestrictionDefault>constraint_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeyColumns</CollectionName> - <RestrictionName>TableName</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeyColumns</CollectionName> - <RestrictionName>ConstraintName</RestrictionName> - <RestrictionDefault>constraint_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ForeignKeyColumns</CollectionName> - <RestrictionName>ColumnName</RestrictionName> - <RestrictionDefault>column_name</RestrictionDefault> - <RestrictionNumber>5</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>PrimaryKeys</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>PrimaryKeys</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>PrimaryKeys</CollectionName> - <RestrictionName>Table</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Sequences</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>sequence_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Sequences</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>sequence_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Sequences</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>sequence_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Tables</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Tables</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Tables</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Tables</CollectionName> - <RestrictionName>Type</RestrictionName> - <RestrictionDefault>table_type</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Tables</CollectionName> - <RestrictionName>Tablespace</RestrictionName> - <RestrictionDefault>tablespace</RestrictionDefault> - <RestrictionNumber>5</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Triggers</CollectionName> - <RestrictionName>TableCatalog</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Triggers</CollectionName> - <RestrictionName>TableSchema</RestrictionName> - <RestrictionDefault>table_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Triggers</CollectionName> - <RestrictionName>TableName</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Triggers</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>trigger_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>UniqueKeys</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>UniqueKeys</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>table_schema</Restriction... [truncated message content] |
