[pgsqlclient-checkins] SF.net SVN: pgsqlclient: [147] trunk/PostgreSqlClient/source/PostgreSql/Data/
Status: Inactive
Brought to you by:
carlosga_fb
Menu
▾
▴
[pgsqlclient-checkins] SF.net SVN: pgsqlclient: [147] trunk/PostgreSqlClient/source/PostgreSql/Data/Schema/MetaData.xml
|
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</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>UniqueKeys</CollectionName> - <RestrictionName>Table</RestrictionName> - <RestrictionDefault>table_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Views</CollectionName> - <RestrictionName>Catalog</RestrictionName> - <RestrictionDefault>view_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Views</CollectionName> - <RestrictionName>Schema</RestrictionName> - <RestrictionDefault>view_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>Views</CollectionName> - <RestrictionName>Name</RestrictionName> - <RestrictionDefault>view_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ViewColumns</CollectionName> - <RestrictionName>ViewCatalog</RestrictionName> - <RestrictionDefault>view_catalog</RestrictionDefault> - <RestrictionNumber>1</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ViewColumns</CollectionName> - <RestrictionName>ViewSchema</RestrictionName> - <RestrictionDefault>view_schema</RestrictionDefault> - <RestrictionNumber>2</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ViewColumns</CollectionName> - <RestrictionName>ViewName</RestrictionName> - <RestrictionDefault>view_name</RestrictionDefault> - <RestrictionNumber>3</RestrictionNumber> - </Restrictions> - <Restrictions> - <CollectionName>ViewColumns</CollectionName> - <RestrictionName>ColumnName</RestrictionName> - <RestrictionDefault>column_name</RestrictionDefault> - <RestrictionNumber>4</RestrictionNumber> - </Restrictions> - <DataSourceInformation> - <CompositeIdentifierSeparatorPattern>.</CompositeIdentifierSeparatorPattern> - <DataSourceProductName>PostgreSQL</DataSourceProductName> - <DataSourceProductVersion>7.4+</DataSourceProductVersion> - <DataSourceProductVersionNormalized>7.4+</DataSourceProductVersionNormalized> - <GroupByBehavior>2</GroupByBehavior> - <IdentifierPattern>(^\[\p{Lo}\p{Lu}\p{Ll}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Nd}@$#_]*$)|(^\[[^\]\0]|\]\]+\]$)|(^\"[^\"\0]|\"\"+\"$)</IdentifierPattern> - <IdentifierCase>2</IdentifierCase> - <OrderByColumnsInSelect>true</OrderByColumnsInSelect> - <ParameterMarkerFormat>{0}</ParameterMarkerFormat> - <ParameterMarkerPattern>@[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$)</ParameterMarkerPattern> - <ParameterNameMaxLength>128</ParameterNameMaxLength> - <ParameterNamePattern>^[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$)</ParameterNamePattern> - <QuotedIdentifierPattern>(([^\""|\"\")*)</QuotedIdentifierPattern> - <QuotedIdentifierCase>2</QuotedIdentifierCase> - <StatementSeparatorPattern>;</StatementSeparatorPattern> - <StringLiteralPattern>'(([^']|'')*)'</StringLiteralPattern> - <SupportedJoinOperators>15</SupportedJoinOperators> - </DataSourceInformation> - <DataTypes> - <TypeName>int2</TypeName> - <ProviderDbType>12</ProviderDbType> - <ColumnSize>2</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Int16</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>10</DbType> - </DataTypes> - <DataTypes> - <TypeName>int4</TypeName> - <ProviderDbType>13</ProviderDbType> - <ColumnSize>4</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Int32</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>11</DbType> - </DataTypes> - <DataTypes> - <TypeName>int8</TypeName> - <ProviderDbType>14</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Int64</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>12</DbType> - </DataTypes> - <DataTypes> - <TypeName>decimal</TypeName> - <ProviderDbType>9</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters>precision, scale</CreateParameters> - <DataType>System.Decimal</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>7</DbType> - </DataTypes> - <DataTypes> - <TypeName>numeric</TypeName> - <ProviderDbType>18</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters>precision, scale</CreateParameters> - <DataType>System.Decimal</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>7</DbType> - </DataTypes> - <DataTypes> - <TypeName>float4</TypeName> - <ProviderDbType>11</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Single</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>15</DbType> - </DataTypes> - <DataTypes> - <TypeName>float8</TypeName> - <ProviderDbType>10</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Single</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>8</DbType> - </DataTypes> - <DataTypes> - <TypeName>currency</TypeName> - <ProviderDbType>7</ProviderDbType> - <ColumnSize>4</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Single</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>true</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>15</DbType> - </DataTypes> - <DataTypes> - <TypeName>char</TypeName> - <ProviderDbType>5</ProviderDbType> - <ColumnSize>2147483647</ColumnSize> - <CreateFormat /> - <CreateParameters>length</CreateParameters> - <DataType>System.String</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>true</IsLiteralSupported> - <LiteralPrefix>'</LiteralPrefix> - <LiteralSuffix>'</LiteralSuffix> - <DbType>16</DbType> - </DataTypes> - <DataTypes> - <TypeName>varchar</TypeName> - <ProviderDbType>27</ProviderDbType> - <ColumnSize>2147483647</ColumnSize> - <CreateFormat /> - <CreateParameters>length</CreateParameters> - <DataType>System.String</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>true</IsLiteralSupported> - <LiteralPrefix>'</LiteralPrefix> - <LiteralSuffix>'</LiteralSuffix> - <DbType>16</DbType> - </DataTypes> - <DataTypes> - <TypeName>text</TypeName> - <ProviderDbType>22</ProviderDbType> - <ColumnSize>2147483647</ColumnSize> - <CreateFormat /> - <CreateParameters>length</CreateParameters> - <DataType>System.String</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>true</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>true</IsLiteralSupported> - <LiteralPrefix>'</LiteralPrefix> - <LiteralSuffix>'</LiteralSuffix> - <DbType>16</DbType> - </DataTypes> - <DataTypes> - <TypeName>bytea</TypeName> - <ProviderDbType>1</ProviderDbType> - <ColumnSize>2147483647</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Byte[]</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>true</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>1</DbType> - </DataTypes> - <DataTypes> - <TypeName>date</TypeName> - <ProviderDbType>8</ProviderDbType> - <ColumnSize>4</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.DateTime</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>time</TypeName> - <ProviderDbType>23</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.DateTime</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>timetz</TypeName> - <ProviderDbType>24</ProviderDbType> - <ColumnSize>12</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.DateTime</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>timestamp</TypeName> - <ProviderDbType>25</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.DateTime</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>timestamptz</TypeName> - <ProviderDbType>26</ProviderDbType> - <ColumnSize>8</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.DateTime</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>interval</TypeName> - <ProviderDbType>15</ProviderDbType> - <ColumnSize>12</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Timespan</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>6</DbType> - </DataTypes> - <DataTypes> - <TypeName>bool</TypeName> - <ProviderDbType>2</ProviderDbType> - <ColumnSize>1</ColumnSize> - <CreateFormat /> - <CreateParameters/> - <DataType>System.Boolean</DataType> - <IsAutoIncrementable>false</IsAutoIncrementable> - <IsBestMatch>false</IsBestMatch> - <IsCaseSensitive>false</IsCaseSensitive> - <IsFixedLength>false</IsFixedLength> - <IsFixedPrecisionScale>false</IsFixedPrecisionScale> - <IsLong>false</IsLong> - <IsNullable>true</IsNullable> - <IsSearchable>true</IsSearchable> - <IsSearchableWithLike>true</IsSearchableWithLike> - <IsUnsigned>false</IsUnsigned> - <MaximumScale>0</MaximumScale> - <MinimumScale>0</MinimumScale> - <IsConcurrencyType>false</IsConcurrencyType> - <IsLiteralSupported>false</IsLiteralSupported> - <LiteralPrefix/> - <LiteralSuffix/> - <DbType>3</DbType> - </DataTypes> - <ReservedWords> - <ReservedWord>ABORT</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>ABORT</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>ANALYZE</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>BINARY</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>CLUSTER</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>CONSTRAINT</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>COPY</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>EXPLAIN</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>EXTEND</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>LISTEN</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>LOAD</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>LOCK</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>MOVE</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>NEW</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>NONE</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>NOTIFY</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>OFFSET</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>RESET</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>SETOF</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>SHOW</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>UNLISTEN</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>UNTIL</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>VACUUM</ReservedWord> - </ReservedWords> - <ReservedWords> - <ReservedWord>VERBOSE</ReservedWord> - </ReservedWords> + <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> + <NumberOfRestri... [truncated message content] |
