You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/06/26 01:29:47 UTC
[shardingsphere] branch master updated: Add pg information schema tables (#26425)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 361b367ae4d Add pg information schema tables (#26425)
361b367ae4d is described below
commit 361b367ae4d0196473d88cc2ada99d1458aa7223
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Mon Jun 26 09:29:41 2023 +0800
Add pg information schema tables (#26425)
* Add sys table
* Add sys table
* Add sys table
* merge
* fix
* fix
* fix
---
.../schema/builder/SystemSchemaBuilderRule.java | 14 +-
.../_pg_foreign_data_wrappers.yaml | 75 +++
.../information_schema/_pg_foreign_servers.yaml | 91 +++
.../_pg_foreign_table_columns.yaml | 51 ++
.../information_schema/_pg_foreign_tables.yaml | 75 +++
.../information_schema/_pg_user_mappings.yaml | 75 +++
.../administrable_role_authorizations.yaml | 43 ++
.../information_schema/applicable_roles.yaml | 43 ++
.../postgresql/information_schema/attributes.yaml | 267 ++++++++
.../information_schema/character_sets.yaml | 83 +++
.../check_constraint_routine_usage.yaml | 67 ++
.../information_schema/check_constraints.yaml | 51 ++
.../collation_character_set_applicability.yaml | 67 ++
.../postgresql/information_schema/collations.yaml | 51 ++
.../information_schema/column_column_usage.yaml | 59 ++
.../information_schema/column_domain_usage.yaml | 75 +++
.../information_schema/column_options.yaml | 67 ++
.../information_schema/column_privileges.yaml | 83 +++
.../information_schema/column_udt_usage.yaml | 75 +++
.../constraint_column_usage.yaml | 75 +++
.../information_schema/constraint_table_usage.yaml | 67 ++
.../information_schema/data_type_privileges.yaml | 59 ++
.../information_schema/domain_constraints.yaml | 83 +++
.../information_schema/domain_udt_usage.yaml | 67 ++
.../postgresql/information_schema/domains.yaml | 235 +++++++
.../information_schema/element_types.yaml | 251 ++++++++
.../information_schema/enabled_roles.yaml | 27 +
.../foreign_data_wrapper_options.yaml | 51 ++
.../information_schema/foreign_data_wrappers.yaml | 59 ++
.../information_schema/foreign_server_options.yaml | 51 ++
.../information_schema/foreign_servers.yaml | 75 +++
.../information_schema/foreign_table_options.yaml | 59 ++
.../information_schema/foreign_tables.yaml | 59 ++
.../information_schema_catalog_name.yaml | 27 +
.../information_schema/key_column_usage.yaml | 91 +++
.../postgresql/information_schema/parameters.yaml | 275 +++++++++
.../referential_constraints.yaml | 91 +++
.../information_schema/role_column_grants.yaml | 83 +++
.../information_schema/role_routine_grants.yaml | 99 +++
.../information_schema/role_table_grants.yaml | 83 +++
.../information_schema/role_udt_grants.yaml | 75 +++
.../information_schema/role_usage_grants.yaml | 83 +++
.../information_schema/routine_column_usage.yaml | 99 +++
.../information_schema/routine_privileges.yaml | 99 +++
.../information_schema/routine_routine_usage.yaml | 67 ++
.../information_schema/routine_sequence_usage.yaml | 91 +++
.../information_schema/routine_table_usage.yaml | 91 +++
.../postgresql/information_schema/routines.yaml | 675 +++++++++++++++++++++
.../postgresql/information_schema/schemata.yaml | 75 +++
.../postgresql/information_schema/sequences.yaml | 115 ++++
.../information_schema/sql_features.yaml | 75 +++
.../sql_implementation_info.yaml | 59 ++
.../postgresql/information_schema/sql_parts.yaml | 59 ++
.../postgresql/information_schema/sql_sizing.yaml | 51 ++
.../information_schema/table_constraints.yaml | 99 +++
.../information_schema/table_privileges.yaml | 83 +++
.../postgresql/information_schema/transforms.yaml | 83 +++
.../triggered_update_columns.yaml | 75 +++
.../postgresql/information_schema/triggers.yaml | 155 +++++
.../information_schema/udt_privileges.yaml | 75 +++
.../information_schema/usage_privileges.yaml | 83 +++
.../information_schema/user_defined_types.yaml | 251 ++++++++
.../information_schema/user_mapping_options.yaml | 59 ++
.../information_schema/user_mappings.yaml | 43 ++
.../information_schema/view_column_usage.yaml | 75 +++
.../information_schema/view_routine_usage.yaml | 67 ++
.../information_schema/view_table_usage.yaml | 67 ++
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
.../test/e2e/engine/type/RALE2EIT.java | 8 +
...nformation_schema__pg_foreign_data_wrappers.xml | 28 +
...esql_information_schema__pg_foreign_servers.xml | 30 +
...nformation_schema__pg_foreign_table_columns.xml | 25 +
...resql_information_schema__pg_foreign_tables.xml | 28 +
...gresql_information_schema__pg_user_mappings.xml | 28 +
...on_schema_administrable_role_authorizations.xml | 24 +
...tgresql_information_schema_applicable_roles.xml | 24 +
...ct_postgresql_information_schema_attributes.xml | 52 ++
...ostgresql_information_schema_character_sets.xml | 29 +
...ation_schema_check_constraint_routine_usage.xml | 27 +
...gresql_information_schema_check_constraints.xml | 25 +
...chema_collation_character_set_applicability.xml | 27 +
...ct_postgresql_information_schema_collations.xml | 25 +
...esql_information_schema_column_column_usage.xml | 26 +
...esql_information_schema_column_domain_usage.xml | 28 +
...ostgresql_information_schema_column_options.xml | 27 +
...gresql_information_schema_column_privileges.xml | 29 +
...tgresql_information_schema_column_udt_usage.xml | 28 +
...elect_postgresql_information_schema_columns.xml | 65 ++
..._information_schema_constraint_column_usage.xml | 28 +
...l_information_schema_constraint_table_usage.xml | 27 +
...sql_information_schema_data_type_privileges.xml | 26 +
...resql_information_schema_domain_constraints.xml | 29 +
...tgresql_information_schema_domain_udt_usage.xml | 27 +
...elect_postgresql_information_schema_domains.xml | 48 ++
...postgresql_information_schema_element_types.xml | 50 ++
...postgresql_information_schema_enabled_roles.xml | 22 +
...rmation_schema_foreign_data_wrapper_options.xml | 25 +
...ql_information_schema_foreign_data_wrappers.xml | 26 +
...l_information_schema_foreign_server_options.xml | 25 +
...stgresql_information_schema_foreign_servers.xml | 28 +
...ql_information_schema_foreign_table_options.xml | 26 +
...ostgresql_information_schema_foreign_tables.xml | 26 +
...tion_schema_information_schema_catalog_name.xml | 22 +
...tgresql_information_schema_key_column_usage.xml | 30 +
...ct_postgresql_information_schema_parameters.xml | 53 ++
..._information_schema_referential_constraints.xml | 30 +
...resql_information_schema_role_column_grants.xml | 29 +
...esql_information_schema_role_routine_grants.xml | 31 +
...gresql_information_schema_role_table_grants.xml | 29 +
...stgresql_information_schema_role_udt_grants.xml | 28 +
...gresql_information_schema_role_usage_grants.xml | 29 +
...sql_information_schema_routine_column_usage.xml | 31 +
...resql_information_schema_routine_privileges.xml | 31 +
...ql_information_schema_routine_routine_usage.xml | 27 +
...l_information_schema_routine_sequence_usage.xml | 30 +
...esql_information_schema_routine_table_usage.xml | 30 +
...lect_postgresql_information_schema_routines.xml | 103 ++++
...lect_postgresql_information_schema_schemata.xml | 28 +
...ect_postgresql_information_schema_sequences.xml | 33 +
..._postgresql_information_schema_sql_features.xml | 28 +
..._information_schema_sql_implementation_info.xml | 26 +
...ect_postgresql_information_schema_sql_parts.xml | 26 +
...ct_postgresql_information_schema_sql_sizing.xml | 25 +
...gresql_information_schema_table_constraints.xml | 31 +
...tgresql_information_schema_table_privileges.xml | 29 +
...select_postgresql_information_schema_tables.xml | 33 +
...ct_postgresql_information_schema_transforms.xml | 29 +
...information_schema_triggered_update_columns.xml | 28 +
...lect_postgresql_information_schema_triggers.xml | 38 ++
...ostgresql_information_schema_udt_privileges.xml | 28 +
...tgresql_information_schema_usage_privileges.xml | 29 +
...resql_information_schema_user_defined_types.xml | 50 ++
...sql_information_schema_user_mapping_options.xml | 26 +
...postgresql_information_schema_user_mappings.xml | 24 +
...gresql_information_schema_view_column_usage.xml | 28 +
...resql_information_schema_view_routine_usage.xml | 27 +
...tgresql_information_schema_view_table_usage.xml | 27 +
.../select_postgresql_information_schema_views.xml | 31 +
138 files changed, 8461 insertions(+), 2 deletions(-)
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
index e7a21886619..776f118cff6 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
@@ -74,7 +74,19 @@ public enum SystemSchemaBuilderRule {
MYSQL_SHARDING_SPHERE("MySQL", "shardingsphere", new HashSet<>(Arrays.asList("sharding_table_statistics", "cluster_information"))),
- POSTGRESQL_INFORMATION_SCHEMA("PostgreSQL", "information_schema", new HashSet<>(Arrays.asList("columns", "tables", "views"))),
+ POSTGRESQL_INFORMATION_SCHEMA("PostgreSQL", "information_schema",
+ new HashSet<>(Arrays.asList("_pg_foreign_data_wrappers", "_pg_foreign_servers", "_pg_foreign_table_columns", "_pg_foreign_tables", "_pg_user_mappings", "administrable_role_authorizations",
+ "applicable_roles", "attributes", "character_sets",
+ "check_constraint_routine_usage", "check_constraints", "collation_character_set_applicability", "collations", "column_column_usage", "column_domain_usage", "column_options",
+ "column_privileges", "column_udt_usage",
+ "columns", "constraint_column_usage", "constraint_table_usage", "data_type_privileges", "domain_constraints", "domain_udt_usage", "domains", "element_types", "enabled_roles",
+ "foreign_data_wrapper_options", "foreign_data_wrappers", "foreign_server_options", "foreign_servers", "foreign_table_options", "foreign_tables", "information_schema_catalog_name",
+ "key_column_usage", "parameters",
+ "referential_constraints", "role_column_grants", "role_routine_grants", "role_table_grants", "role_udt_grants", "role_usage_grants", "routine_column_usage", "routine_privileges",
+ "routine_routine_usage",
+ "routine_sequence_usage", "routine_table_usage", "routines", "schemata", "sequences", "sql_features", "sql_implementation_info", "sql_parts", "sql_sizing",
+ "table_constraints", "table_privileges", "tables", "transforms", "triggered_update_columns", "triggers", "udt_privileges", "usage_privileges", "user_defined_types",
+ "user_mapping_options", "user_mappings", "view_column_usage", "view_routine_usage", "view_table_usage", "views"))),
POSTGRESQL_PG_CATALOG("PostgreSQL", "pg_catalog", new HashSet<>(Arrays.asList("pg_aggregate", "pg_am", "pg_amop", "pg_amproc", "pg_attrdef", "pg_attribute", "pg_auth_members", "pg_authid",
"pg_available_extension_versions", "pg_available_extensions", "pg_backend_memory_contexts", "pg_cast", "pg_class",
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_data_wrappers.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_data_wrappers.yaml
new file mode 100644
index 00000000000..eec2ca094a1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_data_wrappers.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: _pg_foreign_data_wrappers
+columns:
+ oid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: oid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fdwowner:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: fdwowner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fdwoptions:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: fdwoptions
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_language:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_language
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_servers.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_servers.yaml
new file mode 100644
index 00000000000..04937132305
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_servers.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: _pg_foreign_servers
+columns:
+ oid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: oid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ srvoptions:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: srvoptions
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_version:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_version
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_table_columns.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_table_columns.yaml
new file mode 100644
index 00000000000..a0b5acc0844
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_table_columns.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: _pg_foreign_table_columns
+columns:
+ nspname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: nspname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ relname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: relname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attname:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attname
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attfdwoptions:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: attfdwoptions
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_tables.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_tables.yaml
new file mode 100644
index 00000000000..4491f5f9e96
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_foreign_tables.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: _pg_foreign_tables
+columns:
+ foreign_table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ftoptions:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: ftoptions
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_user_mappings.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_user_mappings.yaml
new file mode 100644
index 00000000000..31ed776f098
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/_pg_user_mappings.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: _pg_user_mappings
+columns:
+ oid:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: oid
+ primaryKey: false
+ unsigned: false
+ visible: true
+ umoptions:
+ caseSensitive: true
+ dataType: 2003
+ generated: false
+ name: umoptions
+ primaryKey: false
+ unsigned: false
+ visible: true
+ umuser:
+ caseSensitive: true
+ dataType: -5
+ generated: false
+ name: umuser
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ srvowner:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: srvowner
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/administrable_role_authorizations.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/administrable_role_authorizations.yaml
new file mode 100644
index 00000000000..c8cc0f38ca2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/administrable_role_authorizations.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: administrable_role_authorizations
+columns:
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ role_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: role_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/applicable_roles.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/applicable_roles.yaml
new file mode 100644
index 00000000000..1817188e4c7
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/applicable_roles.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: applicable_roles
+columns:
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ role_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: role_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/attributes.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/attributes.yaml
new file mode 100644
index 00000000000..7d183f0f9fd
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/attributes.yaml
@@ -0,0 +1,267 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: attributes
+columns:
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordinal_position:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: ordinal_position
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_default:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_default
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_nullable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_nullable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ attribute_udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: attribute_udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_derived_reference_attribute:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_derived_reference_attribute
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/character_sets.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/character_sets.yaml
new file mode 100644
index 00000000000..67a7ecb6654
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/character_sets.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: character_sets
+columns:
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_repertoire:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_repertoire
+ primaryKey: false
+ unsigned: false
+ visible: true
+ form_of_use:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: form_of_use
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_collate_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_collate_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_collate_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_collate_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_collate_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_collate_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraint_routine_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraint_routine_usage.yaml
new file mode 100644
index 00000000000..cf87647cbdc
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraint_routine_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: check_constraint_routine_usage
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraints.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraints.yaml
new file mode 100644
index 00000000000..a3dd6121cc5
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/check_constraints.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: check_constraints
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ check_clause:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: check_clause
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/collation_character_set_applicability.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/collation_character_set_applicability.yaml
new file mode 100644
index 00000000000..e20e07f56f2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/collation_character_set_applicability.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: collation_character_set_applicability
+columns:
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/collations.yaml
new file mode 100644
index 00000000000..1a30bdc298f
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/collations.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: collations
+columns:
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pad_attribute:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: pad_attribute
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/column_column_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/column_column_usage.yaml
new file mode 100644
index 00000000000..61a28b71cb3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/column_column_usage.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: column_column_usage
+columns:
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dependent_column:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dependent_column
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/column_domain_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/column_domain_usage.yaml
new file mode 100644
index 00000000000..72d6d7b8638
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/column_domain_usage.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: column_domain_usage
+columns:
+ domain_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/column_options.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/column_options.yaml
new file mode 100644
index 00000000000..1b39cf04369
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/column_options.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: column_options
+columns:
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/column_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/column_privileges.yaml
new file mode 100644
index 00000000000..1d162c4fb88
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/column_privileges.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: column_privileges
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/column_udt_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/column_udt_usage.yaml
new file mode 100644
index 00000000000..80910fb7648
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/column_udt_usage.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: column_udt_usage
+columns:
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_column_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_column_usage.yaml
new file mode 100644
index 00000000000..4d6c0826ff1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_column_usage.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: constraint_column_usage
+columns:
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_table_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_table_usage.yaml
new file mode 100644
index 00000000000..ea5fe70be85
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/constraint_table_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: constraint_table_usage
+columns:
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/data_type_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/data_type_privileges.yaml
new file mode 100644
index 00000000000..8bcc9de87aa
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/data_type_privileges.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: data_type_privileges
+columns:
+ object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/domain_constraints.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/domain_constraints.yaml
new file mode 100644
index 00000000000..0c2afe21cd2
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/domain_constraints.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: domain_constraints
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_deferrable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_deferrable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ initially_deferred:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: initially_deferred
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/domain_udt_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/domain_udt_usage.yaml
new file mode 100644
index 00000000000..aac24702806
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/domain_udt_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: domain_udt_usage
+columns:
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/domains.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/domains.yaml
new file mode 100644
index 00000000000..d6a27abe1d3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/domains.yaml
@@ -0,0 +1,235 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: domains
+columns:
+ domain_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_default:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_default
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/element_types.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/element_types.yaml
new file mode 100644
index 00000000000..7cc00086476
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/element_types.yaml
@@ -0,0 +1,251 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: element_types
+columns:
+ object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collection_type_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collection_type_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ domain_default:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: domain_default
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/enabled_roles.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/enabled_roles.yaml
new file mode 100644
index 00000000000..740b9391970
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/enabled_roles.yaml
@@ -0,0 +1,27 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: enabled_roles
+columns:
+ role_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: role_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrapper_options.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrapper_options.yaml
new file mode 100644
index 00000000000..43f087d5f21
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrapper_options.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_data_wrapper_options
+columns:
+ foreign_data_wrapper_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrappers.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrappers.yaml
new file mode 100644
index 00000000000..3f7e5b6edb3
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_data_wrappers.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_data_wrappers
+columns:
+ foreign_data_wrapper_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ library_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: library_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_language:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_language
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_server_options.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_server_options.yaml
new file mode 100644
index 00000000000..4ceb5e56171
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_server_options.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_server_options
+columns:
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_servers.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_servers.yaml
new file mode 100644
index 00000000000..5325350cca1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_servers.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_servers
+columns:
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_data_wrapper_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_data_wrapper_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_version:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_version
+ primaryKey: false
+ unsigned: false
+ visible: true
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_table_options.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_table_options.yaml
new file mode 100644
index 00000000000..ecb38058661
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_table_options.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_table_options
+columns:
+ foreign_table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_tables.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_tables.yaml
new file mode 100644
index 00000000000..01429369a29
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/foreign_tables.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: foreign_tables
+columns:
+ foreign_table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/information_schema_catalog_name.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/information_schema_catalog_name.yaml
new file mode 100644
index 00000000000..46efa0bebcd
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/information_schema_catalog_name.yaml
@@ -0,0 +1,27 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: information_schema_catalog_name
+columns:
+ catalog_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: catalog_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/key_column_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/key_column_usage.yaml
new file mode 100644
index 00000000000..ffc139f8f8f
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/key_column_usage.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: key_column_usage
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordinal_position:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: ordinal_position
+ primaryKey: false
+ unsigned: false
+ visible: true
+ position_in_unique_constraint:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: position_in_unique_constraint
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/parameters.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/parameters.yaml
new file mode 100644
index 00000000000..7eb381cc393
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/parameters.yaml
@@ -0,0 +1,275 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: parameters
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordinal_position:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: ordinal_position
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parameter_mode:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parameter_mode
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_result:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_result
+ primaryKey: false
+ unsigned: false
+ visible: true
+ as_locator:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: as_locator
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parameter_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parameter_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parameter_default:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parameter_default
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/referential_constraints.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/referential_constraints.yaml
new file mode 100644
index 00000000000..67b8e48192e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/referential_constraints.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: referential_constraints
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: unique_constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: unique_constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ unique_constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: unique_constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ match_option:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: match_option
+ primaryKey: false
+ unsigned: false
+ visible: true
+ update_rule:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: update_rule
+ primaryKey: false
+ unsigned: false
+ visible: true
+ delete_rule:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: delete_rule
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/role_column_grants.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/role_column_grants.yaml
new file mode 100644
index 00000000000..12d6abe698e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/role_column_grants.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: role_column_grants
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/role_routine_grants.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/role_routine_grants.yaml
new file mode 100644
index 00000000000..3b74a7100d1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/role_routine_grants.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: role_routine_grants
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/role_table_grants.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/role_table_grants.yaml
new file mode 100644
index 00000000000..9820501d987
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/role_table_grants.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: role_table_grants
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ with_hierarchy:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: with_hierarchy
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/role_udt_grants.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/role_udt_grants.yaml
new file mode 100644
index 00000000000..75490cbb5c8
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/role_udt_grants.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: role_udt_grants
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/role_usage_grants.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/role_usage_grants.yaml
new file mode 100644
index 00000000000..e746e931b9c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/role_usage_grants.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: role_usage_grants
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routine_column_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_column_usage.yaml
new file mode 100644
index 00000000000..399989c672f
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_column_usage.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routine_column_usage
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routine_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_privileges.yaml
new file mode 100644
index 00000000000..126c8cabc5c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_privileges.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routine_privileges
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routine_routine_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_routine_usage.yaml
new file mode 100644
index 00000000000..99c2f368a57
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_routine_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routine_routine_usage
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routine_sequence_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_sequence_usage.yaml
new file mode 100644
index 00000000000..47e93c67ceb
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_sequence_usage.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routine_sequence_usage
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sequence_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sequence_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sequence_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routine_table_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_table_usage.yaml
new file mode 100644
index 00000000000..5cad6fb1cfe
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routine_table_usage.yaml
@@ -0,0 +1,91 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routine_table_usage
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/routines.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/routines.yaml
new file mode 100644
index 00000000000..e13fe9971d1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/routines.yaml
@@ -0,0 +1,675 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: routines
+columns:
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ module_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: module_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ module_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: module_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ module_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: module_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type_udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: type_udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type_udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: type_udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ type_udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: type_udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_body:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_body
+ primaryKey: false
+ unsigned: false
+ visible: true
+ routine_definition:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: routine_definition
+ primaryKey: false
+ unsigned: false
+ visible: true
+ external_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: external_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ external_language:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: external_language
+ primaryKey: false
+ unsigned: false
+ visible: true
+ parameter_style:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: parameter_style
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_deterministic:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_deterministic
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_data_access:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sql_data_access
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_null_call:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_null_call
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_path:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sql_path
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schema_level_routine:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schema_level_routine
+ primaryKey: false
+ unsigned: false
+ visible: true
+ max_dynamic_result_sets:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: max_dynamic_result_sets
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_user_defined_cast:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_user_defined_cast
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_implicitly_invocable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_implicitly_invocable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ security_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: security_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ to_sql_specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: to_sql_specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ to_sql_specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: to_sql_specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ to_sql_specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: to_sql_specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ as_locator:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: as_locator
+ primaryKey: false
+ unsigned: false
+ visible: true
+ created:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: created
+ primaryKey: false
+ unsigned: false
+ visible: true
+ last_altered:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: last_altered
+ primaryKey: false
+ unsigned: false
+ visible: true
+ new_savepoint_level:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: new_savepoint_level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_udt_dependent:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_udt_dependent
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_from_data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_from_data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_as_locator:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_as_locator
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_char_max_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_char_max_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_char_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_char_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_char_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_char_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_char_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_char_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_char_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_char_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_type_udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_type_udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_type_udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_type_udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_type_udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_type_udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_scope_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_scope_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_scope_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_scope_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_scope_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_scope_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_maximum_cardinality:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: result_cast_maximum_cardinality
+ primaryKey: false
+ unsigned: false
+ visible: true
+ result_cast_dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: result_cast_dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/schemata.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/schemata.yaml
new file mode 100644
index 00000000000..00f4ea77163
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/schemata.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: schemata
+columns:
+ catalog_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: catalog_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schema_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schema_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ schema_owner:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: schema_owner
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ default_character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: default_character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sql_path:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sql_path
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/sequences.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/sequences.yaml
new file mode 100644
index 00000000000..6ddea39f5dc
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/sequences.yaml
@@ -0,0 +1,115 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: sequences
+columns:
+ sequence_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sequence_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sequence_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sequence_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ start_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: start_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ minimum_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: minimum_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ maximum_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: maximum_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ increment:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: increment
+ primaryKey: false
+ unsigned: false
+ visible: true
+ cycle_option:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: cycle_option
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/sql_features.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_features.yaml
new file mode 100644
index 00000000000..b8bd8019fb5
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_features.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: sql_features
+columns:
+ feature_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: feature_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ feature_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: feature_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sub_feature_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sub_feature_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sub_feature_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sub_feature_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_supported:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_supported
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_verified_by:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_verified_by
+ primaryKey: false
+ unsigned: false
+ visible: true
+ comments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: comments
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/sql_implementation_info.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_implementation_info.yaml
new file mode 100644
index 00000000000..725c7e769e9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_implementation_info.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: sql_implementation_info
+columns:
+ implementation_info_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: implementation_info_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ implementation_info_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: implementation_info_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ integer_value:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: integer_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ comments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: comments
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/sql_parts.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_parts.yaml
new file mode 100644
index 00000000000..d5219fd0838
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_parts.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: sql_parts
+columns:
+ feature_id:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: feature_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ feature_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: feature_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_supported:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_supported
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_verified_by:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_verified_by
+ primaryKey: false
+ unsigned: false
+ visible: true
+ comments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: comments
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/sql_sizing.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_sizing.yaml
new file mode 100644
index 00000000000..5c2df86c52e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/sql_sizing.yaml
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: sql_sizing
+columns:
+ sizing_id:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: sizing_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ sizing_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: sizing_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ supported_value:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: supported_value
+ primaryKey: false
+ unsigned: false
+ visible: true
+ comments:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: comments
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/table_constraints.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/table_constraints.yaml
new file mode 100644
index 00000000000..e40157461b0
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/table_constraints.yaml
@@ -0,0 +1,99 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: table_constraints
+columns:
+ constraint_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ constraint_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: constraint_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_deferrable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_deferrable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ initially_deferred:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: initially_deferred
+ primaryKey: false
+ unsigned: false
+ visible: true
+ enforced:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: enforced
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/table_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/table_privileges.yaml
new file mode 100644
index 00000000000..71aca23f55e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/table_privileges.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: table_privileges
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ with_hierarchy:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: with_hierarchy
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/transforms.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/transforms.yaml
new file mode 100644
index 00000000000..0a5da98b731
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/transforms.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: transforms
+columns:
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ group_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: group_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ transform_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: transform_type
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/triggered_update_columns.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/triggered_update_columns.yaml
new file mode 100644
index 00000000000..e0226c94fb9
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/triggered_update_columns.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: triggered_update_columns
+columns:
+ trigger_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trigger_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trigger_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_table:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_table
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_column:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_column
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/triggers.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/triggers.yaml
new file mode 100644
index 00000000000..fc578ec830a
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/triggers.yaml
@@ -0,0 +1,155 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: triggers
+columns:
+ trigger_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trigger_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trigger_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: trigger_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_manipulation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_manipulation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ event_object_table:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: event_object_table
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_order:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: action_order
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_condition:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_condition
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_statement:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_statement
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_orientation:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_orientation
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_timing:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_timing
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_reference_old_table:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_reference_old_table
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_reference_new_table:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_reference_new_table
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_reference_old_row:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_reference_old_row
+ primaryKey: false
+ unsigned: false
+ visible: true
+ action_reference_new_row:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: action_reference_new_row
+ primaryKey: false
+ unsigned: false
+ visible: true
+ created:
+ caseSensitive: true
+ dataType: 93
+ generated: false
+ name: created
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/udt_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/udt_privileges.yaml
new file mode 100644
index 00000000000..3b078919a49
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/udt_privileges.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: udt_privileges
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ udt_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: udt_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/usage_privileges.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/usage_privileges.yaml
new file mode 100644
index 00000000000..1dba95b8b63
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/usage_privileges.yaml
@@ -0,0 +1,83 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: usage_privileges
+columns:
+ grantor:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantor
+ primaryKey: false
+ unsigned: false
+ visible: true
+ grantee:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: grantee
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ object_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: object_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ privilege_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: privilege_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_grantable
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/user_defined_types.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/user_defined_types.yaml
new file mode 100644
index 00000000000..bf9ddf9b1a5
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/user_defined_types.yaml
@@ -0,0 +1,251 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_defined_types
+columns:
+ user_defined_type_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_defined_type_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_defined_type_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_defined_type_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_defined_type_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_defined_type_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ user_defined_type_category:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: user_defined_type_category
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_instantiable:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_instantiable
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_final:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: is_final
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordering_form:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ordering_form
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordering_category:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ordering_category
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordering_routine_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ordering_routine_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordering_routine_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ordering_routine_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ordering_routine_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ordering_routine_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ reference_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: reference_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ data_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: data_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_maximum_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_maximum_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_octet_length:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: character_octet_length
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ character_set_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: character_set_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ collation_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: collation_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_precision_radix:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_precision_radix
+ primaryKey: false
+ unsigned: false
+ visible: true
+ numeric_scale:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: numeric_scale
+ primaryKey: false
+ unsigned: false
+ visible: true
+ datetime_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: datetime_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_type:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: interval_type
+ primaryKey: false
+ unsigned: false
+ visible: true
+ interval_precision:
+ caseSensitive: true
+ dataType: 4
+ generated: false
+ name: interval_precision
+ primaryKey: false
+ unsigned: false
+ visible: true
+ source_dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: source_dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ref_dtd_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: ref_dtd_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/user_mapping_options.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/user_mapping_options.yaml
new file mode 100644
index 00000000000..5b8fb1b49c1
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/user_mapping_options.yaml
@@ -0,0 +1,59 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_mapping_options
+columns:
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ option_value:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: option_value
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/user_mappings.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/user_mappings.yaml
new file mode 100644
index 00000000000..e4e1f2afaca
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/user_mappings.yaml
@@ -0,0 +1,43 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: user_mappings
+columns:
+ authorization_identifier:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: authorization_identifier
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ foreign_server_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: foreign_server_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/view_column_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/view_column_usage.yaml
new file mode 100644
index 00000000000..0d4ed806751
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/view_column_usage.yaml
@@ -0,0 +1,75 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: view_column_usage
+columns:
+ view_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ view_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ view_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ column_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: column_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/view_routine_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/view_routine_usage.yaml
new file mode 100644
index 00000000000..0da4f7b9c8c
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/view_routine_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: view_routine_usage
+columns:
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ specific_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: specific_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/postgresql/information_schema/view_table_usage.yaml b/infra/common/src/main/resources/schema/postgresql/information_schema/view_table_usage.yaml
new file mode 100644
index 00000000000..72ef11e0a13
--- /dev/null
+++ b/infra/common/src/main/resources/schema/postgresql/information_schema/view_table_usage.yaml
@@ -0,0 +1,67 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+name: view_table_usage
+columns:
+ view_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ view_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ view_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: view_name
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_catalog:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_catalog
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_schema:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_schema
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_name:
+ caseSensitive: true
+ dataType: 12
+ generated: false
+ name: table_name
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
index c9ca105c3b4..590a08c7bd1 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
@@ -54,7 +54,7 @@ class SystemSchemaBuilderTest {
assertTrue(actual.containsKey("information_schema"));
assertTrue(actual.containsKey("pg_catalog"));
assertTrue(actual.containsKey("shardingsphere"));
- assertThat(actual.get("information_schema").getTables().size(), is(3));
+ assertThat(actual.get("information_schema").getTables().size(), is(69));
assertThat(actual.get("pg_catalog").getTables().size(), is(31));
assertThat(actual.get("shardingsphere").getTables().size(), is(2));
}
diff --git a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/RALE2EIT.java b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/RALE2EIT.java
index 326174c6fca..7170420bb7c 100644
--- a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/RALE2EIT.java
+++ b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/engine/type/RALE2EIT.java
@@ -41,6 +41,8 @@ import java.sql.Statement;
import java.util.Collection;
import java.util.LinkedList;
import java.util.List;
+import java.util.Map;
+import java.util.concurrent.ConcurrentHashMap;
import java.util.concurrent.TimeUnit;
import java.util.stream.Collectors;
@@ -51,6 +53,8 @@ import static org.junit.jupiter.api.Assertions.assertTrue;
@E2ETestCaseSettings(SQLCommandType.RAL)
class RALE2EIT {
+ private static final Map<String, Boolean> INITIALIZE = new ConcurrentHashMap<>();
+
@ParameterizedTest(name = "{0}")
@EnabledIf("isEnabled")
@ArgumentsSource(E2ETestCaseArgumentsProvider.class)
@@ -60,6 +64,10 @@ class RALE2EIT {
return;
}
try (SingleE2EContainerComposer containerComposer = new SingleE2EContainerComposer(testParam)) {
+ if (!INITIALIZE.containsKey(testParam.getKey())) {
+ INITIALIZE.put(testParam.getKey(), true);
+ Awaitility.await().atMost(16L, TimeUnit.SECONDS).pollInterval(15L, TimeUnit.SECONDS).until(() -> true);
+ }
init(containerComposer);
assertExecute(containerComposer);
tearDown(containerComposer);
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_data_wrappers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_data_wrappers.xml
new file mode 100644
index 00000000000..76480872607
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_data_wrappers.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="oid" />
+ <column name="fdwowner" />
+ <column name="fdwoptions" />
+ <column name="foreign_data_wrapper_catalog" />
+ <column name="foreign_data_wrapper_name" />
+ <column name="authorization_identifier" />
+ <column name="foreign_data_wrapper_language" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_servers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_servers.xml
new file mode 100644
index 00000000000..9e097cd2298
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_servers.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="oid" />
+ <column name="srvoptions" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="foreign_data_wrapper_catalog" />
+ <column name="foreign_data_wrapper_name" />
+ <column name="foreign_server_type" />
+ <column name="foreign_server_version" />
+ <column name="authorization_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_table_columns.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_table_columns.xml
new file mode 100644
index 00000000000..2e4472ca86d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_table_columns.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="nspname" />
+ <column name="relname" />
+ <column name="attname" />
+ <column name="attfdwoptions" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_tables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_tables.xml
new file mode 100644
index 00000000000..f95e32f09c3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_foreign_tables.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_table_catalog" />
+ <column name="foreign_table_schema" />
+ <column name="foreign_table_name" />
+ <column name="ftoptions" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="authorization_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_user_mappings.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_user_mappings.xml
new file mode 100644
index 00000000000..b7266a7e247
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema__pg_user_mappings.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="oid" />
+ <column name="umoptions" />
+ <column name="umuser" />
+ <column name="authorization_identifier" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="srvowner" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_administrable_role_authorizations.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_administrable_role_authorizations.xml
new file mode 100644
index 00000000000..b836e6bdc2d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_administrable_role_authorizations.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantee" />
+ <column name="role_name" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_applicable_roles.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_applicable_roles.xml
new file mode 100644
index 00000000000..b836e6bdc2d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_applicable_roles.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantee" />
+ <column name="role_name" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_attributes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_attributes.xml
new file mode 100644
index 00000000000..e6e7b24cfe1
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_attributes.xml
@@ -0,0 +1,52 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="attribute_name" />
+ <column name="ordinal_position" />
+ <column name="attribute_default" />
+ <column name="is_nullable" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="attribute_udt_catalog" />
+ <column name="attribute_udt_schema" />
+ <column name="attribute_udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ <column name="is_derived_reference_attribute" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_character_sets.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_character_sets.xml
new file mode 100644
index 00000000000..a6715abf00f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_character_sets.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="character_repertoire" />
+ <column name="form_of_use" />
+ <column name="default_collate_catalog" />
+ <column name="default_collate_schema" />
+ <column name="default_collate_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraint_routine_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraint_routine_usage.xml
new file mode 100644
index 00000000000..86cb0bffd3a
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraint_routine_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraints.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraints.xml
new file mode 100644
index 00000000000..d4161e5690a
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_check_constraints.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="check_clause" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collation_character_set_applicability.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collation_character_set_applicability.xml
new file mode 100644
index 00000000000..06037cfad81
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collation_character_set_applicability.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collations.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collations.xml
new file mode 100644
index 00000000000..5de624749f9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_collations.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="pad_attribute" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_column_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_column_usage.xml
new file mode 100644
index 00000000000..b58516e2ab2
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_column_usage.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="dependent_column" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_domain_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_domain_usage.xml
new file mode 100644
index 00000000000..6417ca15ba4
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_domain_usage.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="domain_catalog" />
+ <column name="domain_schema" />
+ <column name="domain_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_options.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_options.xml
new file mode 100644
index 00000000000..7bed5b4af11
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_options.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="option_name" />
+ <column name="option_value" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_privileges.xml
new file mode 100644
index 00000000000..dae7de6c28f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_privileges.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_udt_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_udt_usage.xml
new file mode 100644
index 00000000000..9e0e3b3f801
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_column_udt_usage.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_columns.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_columns.xml
new file mode 100644
index 00000000000..fe56dc84762
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_columns.xml
@@ -0,0 +1,65 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="ordinal_position" />
+ <column name="column_default" />
+ <column name="is_nullable" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="domain_catalog" />
+ <column name="domain_schema" />
+ <column name="domain_name" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ <column name="is_self_referencing" />
+ <column name="is_identity" />
+ <column name="identity_generation" />
+ <column name="identity_start" />
+ <column name="identity_increment" />
+ <column name="identity_maximum" />
+ <column name="identity_minimum" />
+ <column name="identity_cycle" />
+ <column name="is_generated" />
+ <column name="generation_expression" />
+ <column name="is_updatable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_column_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_column_usage.xml
new file mode 100644
index 00000000000..daae059aa5e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_column_usage.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_table_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_table_usage.xml
new file mode 100644
index 00000000000..ad3e5451288
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_constraint_table_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_data_type_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_data_type_privileges.xml
new file mode 100644
index 00000000000..c2d61f4f451
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_data_type_privileges.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_catalog" />
+ <column name="object_schema" />
+ <column name="object_name" />
+ <column name="object_type" />
+ <column name="dtd_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_constraints.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_constraints.xml
new file mode 100644
index 00000000000..a941b35d5bd
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_constraints.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="domain_catalog" />
+ <column name="domain_schema" />
+ <column name="domain_name" />
+ <column name="is_deferrable" />
+ <column name="initially_deferred" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_udt_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_udt_usage.xml
new file mode 100644
index 00000000000..fc987aca9d4
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domain_udt_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="domain_catalog" />
+ <column name="domain_schema" />
+ <column name="domain_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domains.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domains.xml
new file mode 100644
index 00000000000..a11ced959ac
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_domains.xml
@@ -0,0 +1,48 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="domain_catalog" />
+ <column name="domain_schema" />
+ <column name="domain_name" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="domain_default" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_element_types.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_element_types.xml
new file mode 100644
index 00000000000..cdcf8446f50
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_element_types.xml
@@ -0,0 +1,50 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="object_catalog" />
+ <column name="object_schema" />
+ <column name="object_name" />
+ <column name="object_type" />
+ <column name="collection_type_identifier" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="domain_default" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_enabled_roles.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_enabled_roles.xml
new file mode 100644
index 00000000000..84acd8f9020
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_enabled_roles.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="role_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrapper_options.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrapper_options.xml
new file mode 100644
index 00000000000..1acfd86b3f2
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrapper_options.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_data_wrapper_catalog" />
+ <column name="foreign_data_wrapper_name" />
+ <column name="option_name" />
+ <column name="option_value" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrappers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrappers.xml
new file mode 100644
index 00000000000..d8f24fae170
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_data_wrappers.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_data_wrapper_catalog" />
+ <column name="foreign_data_wrapper_name" />
+ <column name="authorization_identifier" />
+ <column name="library_name" />
+ <column name="foreign_data_wrapper_language" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_server_options.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_server_options.xml
new file mode 100644
index 00000000000..763aa2ec842
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_server_options.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="option_name" />
+ <column name="option_value" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_servers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_servers.xml
new file mode 100644
index 00000000000..acf0d813e95
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_servers.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="foreign_data_wrapper_catalog" />
+ <column name="foreign_data_wrapper_name" />
+ <column name="foreign_server_type" />
+ <column name="foreign_server_version" />
+ <column name="authorization_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_table_options.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_table_options.xml
new file mode 100644
index 00000000000..9fae68417a7
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_table_options.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_table_catalog" />
+ <column name="foreign_table_schema" />
+ <column name="foreign_table_name" />
+ <column name="option_name" />
+ <column name="option_value" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_tables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_tables.xml
new file mode 100644
index 00000000000..58ed3c9f027
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_foreign_tables.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="foreign_table_catalog" />
+ <column name="foreign_table_schema" />
+ <column name="foreign_table_name" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_information_schema_catalog_name.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_information_schema_catalog_name.xml
new file mode 100644
index 00000000000..cfec38cba22
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_information_schema_catalog_name.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="catalog_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_key_column_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_key_column_usage.xml
new file mode 100644
index 00000000000..200e6093687
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_key_column_usage.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="ordinal_position" />
+ <column name="position_in_unique_constraint" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_parameters.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_parameters.xml
new file mode 100644
index 00000000000..6bbdc12f19e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_parameters.xml
@@ -0,0 +1,53 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="ordinal_position" />
+ <column name="parameter_mode" />
+ <column name="is_result" />
+ <column name="as_locator" />
+ <column name="parameter_name" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ <column name="parameter_default" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_referential_constraints.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_referential_constraints.xml
new file mode 100644
index 00000000000..6345fbf92e9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_referential_constraints.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="unique_constraint_catalog" />
+ <column name="unique_constraint_schema" />
+ <column name="unique_constraint_name" />
+ <column name="match_option" />
+ <column name="update_rule" />
+ <column name="delete_rule" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_column_grants.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_column_grants.xml
new file mode 100644
index 00000000000..dae7de6c28f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_column_grants.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_routine_grants.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_routine_grants.xml
new file mode 100644
index 00000000000..39f862b3a80
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_routine_grants.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_table_grants.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_table_grants.xml
new file mode 100644
index 00000000000..4ec24e8515d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_table_grants.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ <column name="with_hierarchy" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_udt_grants.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_udt_grants.xml
new file mode 100644
index 00000000000..5e575b845e8
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_udt_grants.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_usage_grants.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_usage_grants.xml
new file mode 100644
index 00000000000..b9107ed7df9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_role_usage_grants.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="object_catalog" />
+ <column name="object_schema" />
+ <column name="object_name" />
+ <column name="object_type" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_column_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_column_usage.xml
new file mode 100644
index 00000000000..278caa4a285
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_column_usage.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_privileges.xml
new file mode 100644
index 00000000000..39f862b3a80
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_privileges.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_routine_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_routine_usage.xml
new file mode 100644
index 00000000000..27e50e4232c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_routine_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_sequence_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_sequence_usage.xml
new file mode 100644
index 00000000000..d82ed20db99
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_sequence_usage.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="sequence_catalog" />
+ <column name="sequence_schema" />
+ <column name="sequence_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_table_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_table_usage.xml
new file mode 100644
index 00000000000..e7fac7f067f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routine_table_usage.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routines.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routines.xml
new file mode 100644
index 00000000000..b08c5d37cc3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_routines.xml
@@ -0,0 +1,103 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="routine_catalog" />
+ <column name="routine_schema" />
+ <column name="routine_name" />
+ <column name="routine_type" />
+ <column name="module_catalog" />
+ <column name="module_schema" />
+ <column name="module_name" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="type_udt_catalog" />
+ <column name="type_udt_schema" />
+ <column name="type_udt_name" />
+ <column name="scope_catalog" />
+ <column name="scope_schema" />
+ <column name="scope_name" />
+ <column name="maximum_cardinality" />
+ <column name="dtd_identifier" />
+ <column name="routine_body" />
+ <column name="routine_definition" />
+ <column name="external_name" />
+ <column name="external_language" />
+ <column name="parameter_style" />
+ <column name="is_deterministic" />
+ <column name="sql_data_access" />
+ <column name="is_null_call" />
+ <column name="sql_path" />
+ <column name="schema_level_routine" />
+ <column name="max_dynamic_result_sets" />
+ <column name="is_user_defined_cast" />
+ <column name="is_implicitly_invocable" />
+ <column name="security_type" />
+ <column name="to_sql_specific_catalog" />
+ <column name="to_sql_specific_schema" />
+ <column name="to_sql_specific_name" />
+ <column name="as_locator" />
+ <column name="created" />
+ <column name="last_altered" />
+ <column name="new_savepoint_level" />
+ <column name="is_udt_dependent" />
+ <column name="result_cast_from_data_type" />
+ <column name="result_cast_as_locator" />
+ <column name="result_cast_char_max_length" />
+ <column name="result_cast_char_octet_length" />
+ <column name="result_cast_char_set_catalog" />
+ <column name="result_cast_char_set_schema" />
+ <column name="result_cast_char_set_name" />
+ <column name="result_cast_collation_catalog" />
+ <column name="result_cast_collation_schema" />
+ <column name="result_cast_collation_name" />
+ <column name="result_cast_numeric_precision" />
+ <column name="result_cast_numeric_precision_radix" />
+ <column name="result_cast_numeric_scale" />
+ <column name="result_cast_datetime_precision" />
+ <column name="result_cast_interval_type" />
+ <column name="result_cast_interval_precision" />
+ <column name="result_cast_type_udt_catalog" />
+ <column name="result_cast_type_udt_schema" />
+ <column name="result_cast_type_udt_name" />
+ <column name="result_cast_scope_catalog" />
+ <column name="result_cast_scope_schema" />
+ <column name="result_cast_scope_name" />
+ <column name="result_cast_maximum_cardinality" />
+ <column name="result_cast_dtd_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_schemata.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_schemata.xml
new file mode 100644
index 00000000000..4ceff4521de
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_schemata.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="catalog_name" />
+ <column name="schema_name" />
+ <column name="schema_owner" />
+ <column name="default_character_set_catalog" />
+ <column name="default_character_set_schema" />
+ <column name="default_character_set_name" />
+ <column name="sql_path" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sequences.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sequences.xml
new file mode 100644
index 00000000000..b55f6740b13
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sequences.xml
@@ -0,0 +1,33 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sequence_catalog" />
+ <column name="sequence_schema" />
+ <column name="sequence_name" />
+ <column name="data_type" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="start_value" />
+ <column name="minimum_value" />
+ <column name="maximum_value" />
+ <column name="increment" />
+ <column name="cycle_option" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_features.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_features.xml
new file mode 100644
index 00000000000..32e3344a678
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_features.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="feature_id" />
+ <column name="feature_name" />
+ <column name="sub_feature_id" />
+ <column name="sub_feature_name" />
+ <column name="is_supported" />
+ <column name="is_verified_by" />
+ <column name="comments" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_implementation_info.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_implementation_info.xml
new file mode 100644
index 00000000000..e3f354d5f4e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_implementation_info.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="implementation_info_id" />
+ <column name="implementation_info_name" />
+ <column name="integer_value" />
+ <column name="character_value" />
+ <column name="comments" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_parts.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_parts.xml
new file mode 100644
index 00000000000..4897f5ebe51
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_parts.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="feature_id" />
+ <column name="feature_name" />
+ <column name="is_supported" />
+ <column name="is_verified_by" />
+ <column name="comments" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_sizing.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_sizing.xml
new file mode 100644
index 00000000000..57cb5fb1e49
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_sql_sizing.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sizing_id" />
+ <column name="sizing_name" />
+ <column name="supported_value" />
+ <column name="comments" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_constraints.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_constraints.xml
new file mode 100644
index 00000000000..ea4188d4ec2
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_constraints.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="constraint_catalog" />
+ <column name="constraint_schema" />
+ <column name="constraint_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="constraint_type" />
+ <column name="is_deferrable" />
+ <column name="initially_deferred" />
+ <column name="enforced" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_privileges.xml
new file mode 100644
index 00000000000..4ec24e8515d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_table_privileges.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ <column name="with_hierarchy" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_tables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_tables.xml
new file mode 100644
index 00000000000..782e69c3fa3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_tables.xml
@@ -0,0 +1,33 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="table_type" />
+ <column name="self_referencing_column_name" />
+ <column name="reference_generation" />
+ <column name="user_defined_type_catalog" />
+ <column name="user_defined_type_schema" />
+ <column name="user_defined_type_name" />
+ <column name="is_insertable_into" />
+ <column name="is_typed" />
+ <column name="commit_action" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_transforms.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_transforms.xml
new file mode 100644
index 00000000000..97409749672
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_transforms.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ <column name="group_name" />
+ <column name="transform_type" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggered_update_columns.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggered_update_columns.xml
new file mode 100644
index 00000000000..8f55d14ace0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggered_update_columns.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="trigger_catalog" />
+ <column name="trigger_schema" />
+ <column name="trigger_name" />
+ <column name="event_object_catalog" />
+ <column name="event_object_schema" />
+ <column name="event_object_table" />
+ <column name="event_object_column" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggers.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggers.xml
new file mode 100644
index 00000000000..6072e9466fd
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_triggers.xml
@@ -0,0 +1,38 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="trigger_catalog" />
+ <column name="trigger_schema" />
+ <column name="trigger_name" />
+ <column name="event_manipulation" />
+ <column name="event_object_catalog" />
+ <column name="event_object_schema" />
+ <column name="event_object_table" />
+ <column name="action_order" />
+ <column name="action_condition" />
+ <column name="action_statement" />
+ <column name="action_orientation" />
+ <column name="action_timing" />
+ <column name="action_reference_old_table" />
+ <column name="action_reference_new_table" />
+ <column name="action_reference_old_row" />
+ <column name="action_reference_new_row" />
+ <column name="created" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_udt_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_udt_privileges.xml
new file mode 100644
index 00000000000..5e575b845e8
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_udt_privileges.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="udt_catalog" />
+ <column name="udt_schema" />
+ <column name="udt_name" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_usage_privileges.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_usage_privileges.xml
new file mode 100644
index 00000000000..b9107ed7df9
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_usage_privileges.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="grantor" />
+ <column name="grantee" />
+ <column name="object_catalog" />
+ <column name="object_schema" />
+ <column name="object_name" />
+ <column name="object_type" />
+ <column name="privilege_type" />
+ <column name="is_grantable" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_defined_types.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_defined_types.xml
new file mode 100644
index 00000000000..815980eea6f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_defined_types.xml
@@ -0,0 +1,50 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="user_defined_type_catalog" />
+ <column name="user_defined_type_schema" />
+ <column name="user_defined_type_name" />
+ <column name="user_defined_type_category" />
+ <column name="is_instantiable" />
+ <column name="is_final" />
+ <column name="ordering_form" />
+ <column name="ordering_category" />
+ <column name="ordering_routine_catalog" />
+ <column name="ordering_routine_schema" />
+ <column name="ordering_routine_name" />
+ <column name="reference_type" />
+ <column name="data_type" />
+ <column name="character_maximum_length" />
+ <column name="character_octet_length" />
+ <column name="character_set_catalog" />
+ <column name="character_set_schema" />
+ <column name="character_set_name" />
+ <column name="collation_catalog" />
+ <column name="collation_schema" />
+ <column name="collation_name" />
+ <column name="numeric_precision" />
+ <column name="numeric_precision_radix" />
+ <column name="numeric_scale" />
+ <column name="datetime_precision" />
+ <column name="interval_type" />
+ <column name="interval_precision" />
+ <column name="source_dtd_identifier" />
+ <column name="ref_dtd_identifier" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mapping_options.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mapping_options.xml
new file mode 100644
index 00000000000..3fe6f4b007d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mapping_options.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="authorization_identifier" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ <column name="option_name" />
+ <column name="option_value" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mappings.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mappings.xml
new file mode 100644
index 00000000000..317a6a0b3a3
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_user_mappings.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="authorization_identifier" />
+ <column name="foreign_server_catalog" />
+ <column name="foreign_server_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_column_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_column_usage.xml
new file mode 100644
index 00000000000..6a57441ba77
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_column_usage.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="view_catalog" />
+ <column name="view_schema" />
+ <column name="view_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="column_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_routine_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_routine_usage.xml
new file mode 100644
index 00000000000..c97bbee9d39
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_routine_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="specific_catalog" />
+ <column name="specific_schema" />
+ <column name="specific_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_table_usage.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_table_usage.xml
new file mode 100644
index 00000000000..45385845d13
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_view_table_usage.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="view_catalog" />
+ <column name="view_schema" />
+ <column name="view_name" />
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_views.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_views.xml
new file mode 100644
index 00000000000..1f5f6727f4c
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_postgresql_information_schema_views.xml
@@ -0,0 +1,31 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table_catalog" />
+ <column name="table_schema" />
+ <column name="table_name" />
+ <column name="view_definition" />
+ <column name="check_option" />
+ <column name="is_updatable" />
+ <column name="is_insertable_into" />
+ <column name="is_trigger_updatable" />
+ <column name="is_trigger_deletable" />
+ <column name="is_trigger_insertable_into" />
+ </metadata>
+</dataset>