{"id":41388,"date":"2023-04-10T05:52:25","date_gmt":"2023-07-19T10:22:10","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/"},"modified":"2024-04-29T22:48:08","modified_gmt":"2024-04-29T14:48:08","slug":"postgresql%e7%ac%94%e8%ae%b0-3","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/","title":{"rendered":"PostgreSQL\u7b14\u8bb0"},"content":{"rendered":"

\u7cfb\u7edf\u76ee\u5f55<\/h1>\n
\n
14131211109.69.59.49.39.29.19pg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_aggregatepg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_ampg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amoppg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_amprocpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attrdefpg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_attributepg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_auth_memberspg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_authidpg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versionspg_available_extension_versions
\npg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensionspg_available_extensions
\npg_backend_memory_contexts<\/p>\n

pg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_castpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_classpg_collationpg_collationpg_collationpg_collationpg_collationpg_collationpg_collationpg_collationpg_collationpg_collationpg_collation
\npg_configpg_configpg_configpg_configpg_configpg_config<\/p>\n

pg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_constraintpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_conversionpg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_cursorspg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_databasepg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_db_role_settingpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_default_aclpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_dependpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_descriptionpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_enumpg_event_triggerpg_event_triggerpg_event_triggerpg_event_triggerpg_event_triggerpg_event_triggerpg_event_triggerpg_event_triggerpg_event_trigger<\/p>\n

pg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extensionpg_extension
\npg_file_settingspg_file_settingspg_file_settingspg_file_settingspg_file_settingspg_file_settingspg_file_settings<\/p>\n

pg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_data_wrapperpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_serverpg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_tablepg_foreign_table
\npg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_grouppg_hba_file_rulespg_hba_file_rulespg_hba_file_rulespg_hba_file_rulespg_hba_file_rules<\/p>\n

pg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexpg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_indexespg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_inheritspg_init_privspg_init_privspg_init_privspg_init_privspg_init_privspg_init_privs<\/p>\n

pg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_languagepg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobjectpg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_largeobject_metadatapg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_lockspg_matviewspg_matviewspg_matviewspg_matviewspg_matviewspg_matviewspg_matviewspg_matviewspg_matviews<\/p>\n

pg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_namespacepg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_opclasspg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_operatorpg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_opfamilypg_partitioned_tablepg_partitioned_tablepg_partitioned_tablepg_partitioned_tablepg_partitioned_table<\/p>\n

pg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_pltemplatepg_policiespg_policiespg_policiespg_policiespg_policiespg_policiespg_policies<\/p>\n

pg_policypg_policypg_policypg_policypg_policypg_policypg_policy<\/p>\n

pg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_statementspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_prepared_xactspg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_procpg_publicationpg_publicationpg_publicationpg_publicationpg_publicationpg_rangepg_rangepg_rangepg_rangepg_range<\/p>\n

pg_publication_relpg_publication_relpg_publication_relpg_publication_relpg_publication_relpg_replication_originpg_replication_originpg_replication_slots<\/p>\n

pg_publication_tablespg_publication_tablespg_publication_tablespg_publication_tablespg_publication_tablespg_replication_origin_statuspg_replication_origin_status<\/p>\n

pg_rangepg_rangepg_rangepg_rangepg_rangepg_replication_slotspg_replication_slots<\/p>\n

pg_replication_originpg_replication_originpg_replication_originpg_replication_originpg_replication_origin<\/p>\n

pg_replication_origin_statuspg_replication_origin_statuspg_replication_origin_statuspg_replication_origin_statuspg_replication_origin_status<\/p>\n

pg_replication_slotspg_replication_slotspg_replication_slotspg_replication_slotspg_replication_slots<\/p>\n

pg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rewritepg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rolespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_rulespg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabelpg_seclabel
\npg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabelspg_seclabels
\npg_sequencepg_sequencepg_sequencepg_sequencepg_sequence<\/p>\n

pg_sequencespg_sequencespg_sequencespg_sequencespg_sequences<\/p>\n

pg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_settingspg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shadowpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdependpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shdescriptionpg_shmem_allocationspg_shmem_allocations<\/p>\n

pg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabelpg_shseclabel<\/p>\n

pg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statisticpg_statistic_extpg_statistic_extpg_statistic_extpg_statistic_extpg_statistic_ext<\/p>\n

pg_statistic_ext_datapg_statistic_ext_datapg_statistic_ext_data<\/p>\n

pg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_statspg_stats_extpg_stats_extpg_stats_ext<\/p>\n

pg_stats_ext_exprs<\/p>\n

pg_subscriptionpg_subscriptionpg_subscriptionpg_subscriptionpg_subscription<\/p>\n

pg_subscription_relpg_subscription_relpg_subscription_relpg_subscription_relpg_subscription_rel<\/p>\n

pg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_tablespacepg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_abbrevspg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_timezone_namespg_transformpg_transformpg_transformpg_transformpg_transformpg_transformpg_transform<\/p>\n

pg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_triggerpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_configpg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_config_mappg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_dictpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_parserpg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_ts_templatepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_typepg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_userpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingpg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_user_mappingspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_viewspg_views<\/p><\/div>\n<\/div>\n

\u60c5\u62a5\u6a21\u5f0f<\/h1>\n
\n
14131211109.69.59.49.39.29.19administrable_role_\u200bauthorizationsadministrable_role_\u200bauthorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsadministrable_role_authorizationsapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesapplicable_rolesattributesattributesattributesattributesattributesattributesattributesattributesattributesattributesattributesattributescharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_setscharacter_sets
\ncheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraint_routine_usagecheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscheck_constraintscollation_character_set_\u200bapplicabilitycollation_character_set_\u200bapplicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicabilitycollation_character_set_applicability
\ncollationscollationscollationscollationscollationscollationscollationscollationscollationscollationscollations
\ncolumn_column_usagecolumn_column_usagecolumn_column_usage<\/p>\n

column_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_domain_usagecolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_optionscolumn_options<\/p>\n

column_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_privilegescolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumn_udt_usagecolumnscolumnscolumnscolumnscolumnscolumnscolumnscolumnscolumnscolumnscolumnscolumnsconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_column_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usageconstraint_table_usagedata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdata_type_privilegesdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_constraintsdomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomain_udt_usagedomainsdomainsdomainsdomainsdomainsdomainsdomainsdomainsdomainsdomainsdomainsdomainselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typeselement_typesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesenabled_rolesforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrapper_optionsforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_data_wrappersforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_server_optionsforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_serversforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_optionsforeign_table_options
\nforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tablesforeign_tables
\ninformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_nameinformation_schema_catalog_namekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usagekey_column_usageparametersparametersparametersparametersparametersparametersparametersparametersparametersparametersparametersparametersreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsreferential_constraintsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_column_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_routine_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_table_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grantsrole_udt_grants<\/p>\n

role_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsrole_usage_grantsroutine_column_usage<\/p>\n

routine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_privilegesroutine_routine_usage<\/p>\n

routine_sequence_usage<\/p>\n

routine_table_usage<\/p>\n

routinesroutinesroutinesroutinesroutinesroutinesroutinesroutinesroutinesroutinesroutinesroutinesschemataschemataschemataschemataschemataschemataschemataschemataschemataschemataschemataschematasequencessequencessequencessequencessequencessequencessequencessequencessequencessequencessequencessequencessql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_featuressql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_infosql_implementation_info<\/p>\n

sql_languagessql_languagessql_languagessql_languagessql_languagessql_languagessql_languagessql_languagessql_languagessql_languages<\/p>\n

sql_packagessql_packagessql_packagessql_packagessql_packagessql_packagessql_packagessql_packagessql_packagessql_packagessql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_partssql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizingsql_sizing<\/p>\n

sql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilessql_sizing_profilestable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_constraintstable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestable_privilegestablestablestablestablestablestablestablestablestablestablestablestablestransformstransformstransformstransformstransformstransformstransforms<\/p>\n

triggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggered_update_columnstriggerstriggerstriggerstriggerstriggerstriggerstriggerstriggerstriggerstriggerstriggerstriggersudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privilegesudt_privileges<\/p>\n

usage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesusage_privilegesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_typesuser_defined_types<\/p>\n

user_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mapping_optionsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsuser_mappingsview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_column_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_routine_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageview_table_usageviewsviewsviewsviewsviewsviewsviewsviewsviewsviewsviewsviews<\/p><\/div>\n<\/div>\n

\u521b\u5efa\u6587\u4ef6\u793a\u4f8b<\/h1>\n
CREATE USER\tCREATE USER takahashi_user WITH PASSWORD 'takahashi' SUPERUSER;\r\ntakahashi_user\u3067\u5165\u308a\u306a\u304a\u3059\u3002\r\n<\/code><\/pre>\n
CREATE TABLESPACE\tCREATE TABLESPACE takahashi_tablespace\r\n\t  OWNER takahashi_user\r\n\t  LOCATION 'C:\/Work\/postgres\/';\r\n\t\u203b\u8a72\u5f53\u30d5\u30a9\u30eb\u30c0\u306b\u304a\u3051\u308b\u30d5\u30eb\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u3053\u3068\u3002\r\n<\/code><\/pre>\n
CREATE DATABASE\tcreate database takahashi_database\r\n\t  TABLESPACE = takahashi_tablespace;\r\n<\/code><\/pre>\n
CREATE SCHEMA\tcreate schema takahashi_schema;\r\n<\/code><\/pre>\n
CREATE ROLE\tCREATE ROLE takahashi_role\r\n\t  CREATEDB\r\n\t  CREATEROLE\r\n\t  INHERIT;\r\n<\/code><\/pre>\n
CREATE GROUP\t-\r\n<\/code><\/pre>\n
CREATE TABLE\tCREATE TABLE takahashi_table\r\n\t(id char(4) not null,\r\n\tname text not null,\r\n\tfood text not null,\r\n\tPRIMARY KEY(id));\r\n\tINSERT INTO takahashi_table(id,name,food) VALUES (1,'hoge','\u304a\u306b\u304e\u308a');\r\n\tINSERT INTO takahashi_table(id,name,food) VALUES (2,'fuga','\u8089');\r\n\tINSERT INTO takahashi_table(id,name,food) VALUES (3,'piyo','\u30b9\u30fc\u30d7');\r\n\tcommit;\r\n\t\r\n\tCREATE TABLE takahashi_table2\r\n\t(id char(4) not null,\r\n\tname text not null,\r\n\tfood text not null,\r\n\tPRIMARY KEY(id));\r\n\t\r\n\tCREATE TABLE takahashi_table3\r\n\t(id char(4) not null,\r\n\tname text not null,\r\n\tfood text not null,\r\n\tPRIMARY KEY(id));\r\n<\/code><\/pre>\n
CREATE TABLE AS\t-\r\n<\/code><\/pre>\n
CREATE INDEX\tcreate index on takahashi_table (id);\r\n<\/code><\/pre>\n
CREATE FUNCTION\tCREATE FUNCTION takahashi_procedure() RETURNS trigger AS $takahashi_procedure$\r\n\tBEGIN\r\n\tINSERT INTO takahashi_table2 VALUES (NEW.id+1, NEW.name, NEW.food);\r\n\tRETURN NEW;\r\n\tEND;\r\n\t$takahashi_procedure$\r\n\tLANGUAGE plpgsql;\r\n<\/code><\/pre>\n
CREATE AGGREGATE\tCREATE FUNCTION takahashi_text_add(text,text) RETURNS text\r\n\tAS 'SELECT concat($1,''+'',$2)'\r\n\tLANGUAGE SQL;\r\n\t\r\n\tSELECT takahashi_text_add('a','b');\r\n\t\r\n\tCREATE AGGREGATE takahashi_aggregate (text)\r\n\t( sfunc = takahashi_text_add,\r\n\tstype = text,\r\n\tinitcond = '');\r\n<\/code><\/pre>\n
CREATE CAST\tCREATE FUNCTION takahashi_b2n(bool) RETURNS numeric(1) AS\r\n\t'select\r\n\tcase\r\n\twhen $1 IS TRUE\r\n\tthen CAST(1 AS NUMERIC(1))\r\n\telse CAST(0 AS NUMERIC(1))\r\n\tend;'\r\n\tLANGUAGE SQL;\r\n\t\r\n\tcreate cast(bool as numeric) WITH FUNCTION takahashi_b2n(bool) AS ASSIGNMENT;\r\n<\/code><\/pre>\n
CREATE COLLATION\tCREATE COLLATION takahashi_collation (locale = 'fr_FR.utf8');\r\n<\/code><\/pre>\n
CREATE DOMAIN\tCREATE DOMAIN takahashi_domain AS TEXT\r\n\tCHECK(\r\n\tVALUE ~ '^\\\\d{5}$'\r\n\tOR VALUE ~ '^\\\\d{5}-\\\\d{4}$'\r\n\t);\r\n<\/code><\/pre>\n
CREATE EXTENSION\tCREATE EXTENSION hstore;\r\n<\/code><\/pre>\n
CREATE VIEW\tCREATE VIEW takahashi_view AS SELECT name, food FROM takahashi_table;\r\n<\/code><\/pre>\n
CREATE TYPE\tcreate type takahashi_type as (\r\n\th_id int,\r\n\th_name text\r\n\t);\r\n<\/code><\/pre>\n
CREATE MATERIALIZED VIEW\tcreate materialized view takahashi_materializedview\r\n\tas select id, name from takahashi_table;\r\n\t\r\n\trefresh materialized view takahashi_materializedview;\r\n<\/code><\/pre>\n
CREATE RULE\tCREATE RULE takahashi_rule\r\n\t  AS ON update TO takahashi_table DO ALSO select * from takahashi_table3;\r\n<\/code><\/pre>\n
CREATE SEQUENCE\tCREATE SEQUENCE takahashi_sequence AS integer;\r\n<\/code><\/pre>\n
CREATE TEXT SEARCH CONFIGURATION\tCREATE TEXT SEARCH CONFIGURATION takahashi_textsearchconfiguration (copy=simple);\r\n<\/code><\/pre>\n
CREATE TEXT SEARCH DICTIONARY\ttype nul > \"C:\/Program Files\/PostgreSQL\/11\/share\/tsearch_data\/myrussian.stop\"\r\n\tCREATE TEXT SEARCH DICTIONARY takahashi_textsearchdictionary(\r\n\ttemplate = snowball,\r\n\tlanguage = russian,\r\n\tstopwords = myrussian\r\n\t);\r\n<\/code><\/pre>\n
CREATE TEXT SEARCH PARSER\tCREATE TEXT SEARCH PARSER takahashi_textsearchparser (\r\n\tSTART = prsd_start ,\r\n\tGETTOKEN = prsd_nexttoken ,\r\n\tEND = prsd_end ,\r\n\tLEXTYPES =prsd_lextype,\r\n\tHEADLINE = prsd_headline\r\n\t);\r\n<\/code><\/pre>\n
CREATE TEXT SEARCH TEMPLATE\tCREATE TEXT SEARCH TEMPLATE takahashi_textsearchtemplate (\r\n\tLEXIZE = dsimple_lexize\r\n\t);\r\n<\/code><\/pre>\n
CREATE TRIGGER\tCREATE TRIGGER takahashi_trigger AFTER INSERT ON takahashi_table FOR EACH ROW\r\n\tEXECUTE FUNCTION takahashi_procedure();\r\n<\/code><\/pre>\n
CREATE SERVER\tcreate extension postgres_fdw;\r\n\t\r\n\tcreate server takahashi_server\r\n\tforeign data wrapper postgres_fdw\r\n\toptions (host '13.115.0.163', port '5432', dbname 'postgres');\r\n<\/code><\/pre>\n
CREATE FOREIGN DATA WRAPPER\tCREATE FOREIGN DATA WRAPPER takahashi_foreigndatawrapper\r\n\tOPTIONS (debug 'true');\r\n<\/code><\/pre>\n
CREATE FOREIGN TABLE\tCREATE FOREIGN TABLE takahashi_foreigntable (aid integer, bid integer, abalance integer, filler character(84))\r\n\tSERVER takahashi_server  OPTIONS (schema_name 'postgres', table_name 'takahashi_table');\r\n<\/code><\/pre>\n
CREATE USER MAPPING\t-- \u5148\u306b\u3082takahashi_user\u3092\u4f5c\u6210\r\n\tcreate user mapping for takahashi_user\r\n\tserver takahashi_server\r\n\toptions (user 'takahashi_user', password 'takahashi');\r\n\t\r\n\tgrant all on foreign server takahashi_server to takahashi_user;\r\n\t\r\n\t-- \u4ee5\u4e0b\u306f\u3084\u3089\u306a\u304f\u3066\u3088\u3044\u3002\r\n\timport foreign schema postgres limit to (takahashi_table)\r\n\tfrom server takahashi_server into takahashi_schema;\r\n<\/code><\/pre>\n
CREATE EVENT TRIGGER\tCREATE OR REPLACE FUNCTION takahashi_abort_any_command()\r\n\tRETURNS event_trigger\r\n\tLANGUAGE plpgsql\r\n\tAS $$\r\n\tBEGIN\r\n\tselect * from takahashi_table;\r\n\tEND;\r\n\t$$;\r\n\t\r\n\t-- \u79fb\u884c\u306e\u76f4\u524d\u3067\u4f5c\u308b\u3002\r\n\tCREATE EVENT TRIGGER takahashi_eventtrigger ON ddl_command_end\r\n\tEXECUTE PROCEDURE takahashi_abort_any_command();\r\n<\/code><\/pre>\n
\u914d\u7f6e\u6587\u4ef6<\/h1>\n
\n
\u30d5\u30a1\u30a4\u30eb\u540d\u8aac\u660epostgresql.conf\u5168\u4f53\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30ebpostgresql.conf\u3067include\u3057\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u5168\u4f53\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30ebpostgresql.auto.conf\u5168\u4f53\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30ebpg_hba.conf\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308bpg_hba.conf\u3067include\u3057\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308bpg_ident.confident\u8a8d\u8a3c\u304a\u3088\u3073GSSAPI\u8a8d\u8a3c\u3067\u4f7f\u7528\u3055\u308c\u308bpg_ident.conf\u3067include\u3057\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30ebident\u8a8d\u8a3c\u304a\u3088\u3073GSSAPI\u8a8d\u8a3c\u3067\u4f7f\u7528\u3055\u308c\u308brecovery.conf\u30a2\u30fc\u30ab\u30a4\u30d6\u7528\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\uff08\uff5ePostgreSQL11\uff09pg_service.conflibpq\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u63a5\u7d9a\u60c5\u5831\u3092\u30b5\u30fc\u30d3\u30b9\u3068\u3057\u3066\u307e\u3068\u3081\u3066\u7ba1\u7406\u3059\u308b<\/div>\n<\/div>\n
\u8868\u6f14<\/h1>\n
pg_stat_database
\npg_stat_user_tables
\npg_statio_user_tables
\npg_statio_user_indexes
\npg_stat_activity<\/p>\n
pg_stat_database
\npg_stat_user_tables
\npg_statio_user_tables
\npg_statio_user_indexes
\npg_stat_activity<\/p>\n
\u83b7\u5f97<\/h1>\n
\n
No.\u7a2e\u5225\u8868\u540d\u5f79\u52721\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_aggregate\u96c6\u7d04\u95a2\u65702\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_am\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c93\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_amop\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u6f14\u7b97\u5b50\u306e\u96c6\u5408\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u305f\u6f14\u7b97\u5b504\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_amproc\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u6f14\u7b97\u5b50\u65cf\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u305f\u30b5\u30dd\u30fc\u30c8\u95a2\u65705\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_attrdef\u5217\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u50246\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_attribute\u30c6\u30fc\u30d6\u30eb\u306e\u52177\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_authid\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a8d\u8a3c\u8b58\u5225\u5b50\uff08\u30ed\u30fc\u30eb\uff098\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_auth_members\u30ed\u30fc\u30eb\u9593\u306e\u30e1\u30f3\u30d0\u30b7\u30c3\u30d7\u95a2\u4fc29\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_cast\u30c7\u30fc\u30bf\u578b\u5909\u63db\u30d1\u30b910\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_class\u30c6\u30fc\u30d6\u30eb\u3001\u305d\u306e\u4ed6\u306e\u5217\u3092\u6301\u3064\u3082\u306e\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u4f3c\u305f\u5168\u3066\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c811\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_collation\u5229\u7528\u53ef\u80fd\u306aSQL\u540d\u3068OS\u306e\u30ed\u30b1\u30fc\u30eb\u3068\u306e\u57fa\u672c\u7684\u306a\u5bfe\u5fdc\u4ed8\u305112\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_constraint\u691c\u67fb\u5236\u7d04\u3001\u4e3b\u30ad\u30fc\u5236\u7d04\u3001\u4e00\u610f\u6027\u5236\u7d04\u3001\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u3001\u6392\u4ed6\u5236\u7d0413\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_conversion\u30a8\u30f3\u30b3\u30fc\u30c9\u65b9\u5f0f14\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_database\u30c7\u30fc\u30bf\u30d9\u30fc\u30b915\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_db_role_setting\u30ed\u30fc\u30eb\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7d44\u307f\u5408\u308f\u305b\u6bce\u306e\u5b9f\u884c\u6642\u8a2d\u5b9a\u5909\u6570\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u502416\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_default_acl\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u521d\u671f\u6a29\u965017\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_depend\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u9593\u306e\u4f9d\u5b58\u95a2\u4fc218\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_description\u5404\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u4ed8\u3051\u3089\u308c\u305f\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u88dc\u8db3\u8aac\u660e19\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_enum\u5404\u5217\u6319\u578b\u306b\u3064\u3044\u3066\u305d\u306e\u5024\u3068\u30e9\u30d9\u30eb20\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_event_trigger\u30a4\u30d9\u30f3\u30c8\u30c8\u30ea\u30ac21\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_extension\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u62e1\u5f35\u6a5f\u80fd22\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_foreign_data_wrapper\u5916\u90e8\u30c7\u30fc\u30bf\u30e9\u30c3\u30d123\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_foreign_server\u5916\u90e8\u30b5\u30fc\u30d024\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_foreign_table\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u306b\u95a2\u3059\u308b\u88dc\u52a9\u60c5\u583125\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_index\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u60c5\u5831\u306e\u4e00\u90e8\uff08\u307b\u3068\u3093\u3069\u306e\u60c5\u5831\u306fpg_class\uff0926\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_inherits\u30c6\u30fc\u30d6\u30eb\u3068\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7d99\u627f\u968e\u5c6427\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_init_privs\u30b7\u30b9\u30c6\u30e0\u5185\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u521d\u671f\u6a29\u965028\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_language\u30e6\u30fc\u30b6\u5b9a\u7fa9\u95a2\u6570\u3084\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e329\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_largeobject\u30e9\u30fc\u30b8\u30aa\u30d6\u30b8\u30a7\u30af\u30c830\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_largeobject_metadata\u30e9\u30fc\u30b8\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30e1\u30bf\u30c7\u30fc\u30bf31\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_namespace\u540d\u524d\u7a7a\u959332\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_opclass\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u6f14\u7b97\u5b50\u30af\u30e9\u30b933\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_operator\u6f14\u7b97\u5b5034\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_opfamily\u6f14\u7b97\u5b50\u65cf35\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_partitioned_table\u30c6\u30fc\u30d6\u30eb\u306e\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f336\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_policy\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u5358\u4f4d\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u30dd\u30ea\u30b7\u30fc37\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_proc\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3001\u96c6\u7d04\u95a2\u6570\u3042\u308b\u3044\u306fWINDOW\u95a2\u6570\uff08\u307e\u3068\u3081\u3066\u30eb\u30fc\u30c1\u30f3\uff0938\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_publication\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306b\u4f5c\u6210\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30d1\u30d6\u30ea\u30b1\u30fc\u30b7\u30e7\u30f339\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_publication_rel\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u30d1\u30d6\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30de\u30c3\u30d4\u30f3\u30b040\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_range\u7bc4\u56f2\u578b41\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_replication_origin\u4f5c\u6210\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8d77\u70b942\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_rewrite\u30c6\u30fc\u30d6\u30eb\u3068\u30d3\u30e5\u30fc\u306b\u5bfe\u3059\u308b\u66f8\u304d\u63db\u3048\u30eb\u30fc\u30eb43\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_seclabel\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4e0a\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30e9\u30d9\u30eb44\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_sequence\u30b7\u30fc\u30b1\u30f3\u30b945\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_shdepend\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u30ed\u30fc\u30eb\u306e\u3088\u3046\u306a\u5171\u6709\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u9593\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u4f9d\u5b58\u95a2\u4fc246\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_shdescription\u5171\u6709\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3059\u308b\u88dc\u8db3\u8aac\u660e47\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_shseclabel\u5171\u6709\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4e0a\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30e9\u30d9\u30eb48\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_statistic\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5185\u5bb9\u306b\u95a2\u3059\u308b\u7d71\u8a08\u30c7\u30fc\u30bf49\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_statistic_ext\u30d7\u30e9\u30f3\u30ca\u306e\u62e1\u5f35\u7d71\u8a0850\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_statistic_ext_datapg_statistic_ext\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u30d7\u30e9\u30f3\u30ca\u306e\u62e1\u5f35\u7d71\u8a0851\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_subscription\u5b58\u5728\u3059\u308b\u3059\u3079\u3066\u306e\u8ad6\u7406\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f352\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_subscription_rel\u5404\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u3067\u8907\u88fd\u3055\u308c\u308b\u5404\u30ea\u30ec\u30fc\u30b7\u30e7\u30f353\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_tablespace\u5229\u7528\u3067\u304d\u308b\u30c6\u30fc\u30d6\u30eb\u7a7a\u959354\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_transform\u5909\u63db\uff08\u30c7\u30fc\u30bf\u578b\u3092\u624b\u7d9a\u304d\u8a00\u8a9e\u306b\u9069\u5408\u3055\u305b\u308b\u305f\u3081\u306e\u6a5f\u69cb\uff0955\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_trigger\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u4e0a\u306e\u30c8\u30ea\u30ac56\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_ts_config\u30c6\u30ad\u30b9\u30c8\u691c\u7d2257\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_ts_config_map\u3069\u306e\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u8f9e\u66f8\u3092\u53c2\u7167\u3059\u308b\u3079\u304d\u304b58\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_ts_dict\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u8f9e\u66f8\u3092\u5b9a\u7fa9\u3059\u308b\u9805\u76ee59\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_ts_parser\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u30d1\u30fc\u30b5\u3092\u5b9a\u7fa9\u3059\u308b\u9805\u76ee60\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_ts_template\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u30c6\u30f3\u30d7\u30ec\u30fc\u30c861\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_type\u30c7\u30fc\u30bf\u578b62\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_user_mapping\u30ed\u30fc\u30ab\u30eb\u306e\u30e6\u30fc\u30b6\u304b\u3089\u9060\u9694\u306e\u30e6\u30fc\u30b6\u3078\u306e\u30de\u30c3\u30d4\u30f3\u30b063\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_available_extensions\u30a4\u30f3\u30b9\u30c8\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u5229\u7528\u53ef\u80fd\u306a\u62e1\u5f35\u6a5f\u80fd64\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_available_extension_versions\u30a4\u30f3\u30b9\u30c8\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u5229\u7528\u53ef\u80fd\u306a\u7279\u5b9a\u306e\u62e1\u5f35\u6a5f\u80fd\u306e\u30d0\u30fc\u30b8\u30e7\u30f365\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_backend_memory_contexts\u73fe\u5728\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u306b\u30a2\u30bf\u30c3\u30c1\u3055\u308c\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30d7\u30ed\u30bb\u30b9\u306e\u3059\u3079\u3066\u306e\u30e1\u30e2\u30ea\u30b3\u30f3\u30c6\u30ad\u30b9\u30c866\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_configPostgreSQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30b3\u30f3\u30d1\u30a4\u30eb\u6642\u8a2d\u5b9a\u30d1\u30e9\u30e1\u30fc\u30bf67\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_cursors\u73fe\u5728\u5229\u7528\u53ef\u80fd\u306a\u30ab\u30fc\u30bd\u30eb68\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_file_settings\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5185\u5bb9\u306e\u8981\u7d0469\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_group\u3010\u4e0b\u4f4d\u4e92\u63db\u3011rolcanlogin\u3068\u3057\u3066\u30de\u30fc\u30af\u3055\u308c\u3066\u3044\u306a\u3044\u3001\u3059\u3079\u3066\u306e\u30ed\u30fc\u30eb\u306e\u540d\u524d\u3068\u30e1\u30f3\u30d070\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_hba_file_rules\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u8a8d\u8a3c\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30ebpg_hba.conf\u306e\u5185\u5bb9\u306e\u8981\u7d0471\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_indexes\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u305d\u308c\u305e\u308c\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b972\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_locks\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u5185\u3067\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30d7\u30ed\u30bb\u30b9\u306b\u3088\u3063\u3066\u4fdd\u6301\u3055\u308c\u305f\u30ed\u30c3\u30af73\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_matviews\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc74\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_policies\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u884c\u5358\u4f4d\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u30dd\u30ea\u30b7\u30fc75\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_prepared_statements\u73fe\u5728\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u3067\u5229\u7528\u53ef\u80fd\u306a\u6e96\u5099\u6e08\u307f\u658776\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_prepared_xacts\u73fe\u72b6\u30672\u76f8\u30b3\u30df\u30c3\u30c8\u306e\u305f\u3081\u306b\u30d7\u30ea\u30da\u30a2\u30fc\u30c9\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f377\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_publication_tables\u30d1\u30d6\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u305d\u308c\u306b\u542b\u307e\u308c\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u9593\u306e\u30de\u30c3\u30d4\u30f3\u30b078\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_replication_origin_status\u3042\u308b\u8d77\u70b9\u306e\u518d\u751f\u306e\u9032\u6357\u306b\u3064\u3044\u3066\u306e\u60c5\u583179\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_replication_slots\u73fe\u5728\u5b58\u5728\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30e9\u30b9\u30bf\u3068\u305d\u306e\u72b6\u614b\u3001\u5168\u3066\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b9\u30ed\u30c3\u30c880\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_roles\u30ed\u30fc\u30eb81\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_rules\u554f\u3044\u5408\u308f\u305b\u66f8\u304d\u63db\u3048\u30eb\u30fc\u30eb82\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_seclabels\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30e9\u30d9\u30eb83\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_sequences\u30b7\u30fc\u30b1\u30f3\u30b984\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_settings\u5b9f\u884c\u6642\u30d1\u30e9\u30e1\u30fc\u30bf\u3078\u306e\u30a2\u30af\u30bb\u30b985\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_shadow\u3010\u4e0b\u4f4d\u4e92\u63db\u3011 pg_authid\u5185\u3067rolcanlogin\u306e\u30de\u30fc\u30af\u304c\u3064\u3044\u305f\u5168\u3066\u306e\u30ed\u30fc\u30eb\u306e\u5c5e\u602786\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_shmem_allocations\u30b5\u30fc\u30d0\u306e\u4e3b\u5171\u6709\u30e1\u30e2\u30ea\u30bb\u30b0\u30e1\u30f3\u30c8\u306b\u3088\u308b\u30e1\u30e2\u30ea\u306e\u7372\u5f97\u72b6\u6cc187\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_statspg_statistic\u30ab\u30bf\u30ed\u30b0\u306e\u60c5\u5831\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306e\u30d3\u30e5\u30fc88\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_stats_extpg_statistic_ext\u3068pg_statistic_ext_data\u30ab\u30bf\u30ed\u30b0\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u60c5\u5831\u3078\u306e\u30a2\u30af\u30bb\u30b989\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_stats_ext_exprs\u62e1\u5f35\u7d71\u8a08\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u542b\u307e\u308c\u308b\u3059\u3079\u3066\u306e\u5f0f\u306b\u95a2\u3059\u308b\u60c5\u5831\u3078\u306e\u30a2\u30af\u30bb\u30b9\uff08pg_statistic_ext\u3068pg_statistic_ext_data\uff0990\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_tables\u30c6\u30fc\u30d6\u30eb91\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_timezone_abbrevs\u73fe\u5728\u65e5\u4ed8\u6642\u9593\u306e\u5165\u529b\u51e6\u7406\u3067\u8a8d\u8b58\u3055\u308c\u3066\u3044\u308b\u3001\u6642\u9593\u5e2f\u7701\u7565\u5f62\u306e\u30ea\u30b9\u30c892\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_timezone_namesSET TIMEZONE\u3067\u8a8d\u8b58\u3055\u308c\u308b\u6642\u9593\u5e2f\u540d\u79f093\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_user\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e6\u30fc\u30b694\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_user_mappings\u30e6\u30fc\u30b6\u30de\u30c3\u30d4\u30f3\u30b095\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_views\u30d3\u30e5\u30fc96\u30b7\u30b9\u30c6\u30e0\u30ab\u30bf\u30ed\u30b0pg_pltemplate\u624b\u7d9a\u304d\u8a00\u8a9e\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c897\u60c5\u5831\u30b9\u30ad\u30fc\u30deinformation_schema_catalog_name\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\uff08SQL\u7528\u8a9e\u3067\u306f\u73fe\u5728\u306e\u30ab\u30bf\u30ed\u30b0\uff0998\u60c5\u5831\u30b9\u30ad\u30fc\u30deadministrable_role_\u200bauthorizations\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u30a2\u30c9\u30df\u30f3\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6301\u3064\u3059\u3079\u3066\u306e\u30ed\u30fc\u30eb99\u60c5\u5831\u30b9\u30ad\u30fc\u30deapplicable_roles\u305d\u306e\u6a29\u9650\u3092\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3059\u3079\u3066\u306e\u30ed\u30fc\u30eb100\u60c5\u5831\u30b9\u30ad\u30fc\u30deattributes\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u8907\u5408\u30c7\u30fc\u30bf\u578b\u306e\u5c5e\u6027\uff08\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u30a2\u30af\u30bb\u30b9\u3059\u308b\u6a29\u9650\u3092\u6301\u3064\uff09101\u60c5\u5831\u30b9\u30ad\u30fc\u30decharacter_sets\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5229\u7528\u53ef\u80fd\u306a\u6587\u5b57\u30bb\u30c3\u30c8102\u60c5\u5831\u30b9\u30ad\u30fc\u30decheck_constraint_routine_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u3001\u691c\u67fb\u5236\u7d04\u3067\u4f7f\u7528\u3055\u308c\u308b\u51e6\u7406\uff08\u95a2\u6570\u304a\u3088\u3073\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3103\u60c5\u5831\u30b9\u30ad\u30fc\u30decheck_constraints\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3057\u3066\u3044\u308b\u3001\u30c6\u30fc\u30d6\u30eb\u4e0a\u3082\u3057\u304f\u306f\u30c9\u30e1\u30a4\u30f3\u4e0a\u306e\u3069\u3061\u3089\u304b\u306b\u3042\u308b\u3001\u5168\u3066\u306e\u691c\u67fb\u5236\u7d04104\u60c5\u5831\u30b9\u30ad\u30fc\u30decollations\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5229\u7528\u53ef\u80fd\u306a\u7167\u5408105\u60c5\u5831\u30b9\u30ad\u30fc\u30decollation_character_set_\u200bapplicability\u5229\u7528\u53ef\u80fd\u306a\u7167\u5408\u304c\u3069\u306e\u6587\u5b57\u30bb\u30c3\u30c8\u306b\u9069\u7528\u53ef\u80fd\u304b\uff08PostgreSQL\u306f\u6587\u5b57\u30bb\u30c3\u30c8\u304c1\u3064\u306e\u305f\u3081\u3001\u4e0d\u8981\uff09106\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumn_column_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u304a\u3044\u3066\u3001\u540c\u3058\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u5225\u306e\u57fa\u5e95\u5217\u306b\u57fa\u3065\u304f\u3059\u3079\u3066\u306e\u751f\u6210\u5217107\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumn_domain_usage\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u5b9a\u7fa9\u3055\u308c\u3001\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u3042\u308b\u30c9\u30e1\u30a4\u30f3\u3092\u4f7f\u7528\u3059\u308b\uff08\u30c6\u30fc\u30d6\u30eb\u3082\u3057\u304f\u306f\u30d3\u30e5\u30fc\u306e\uff09\u5168\u3066\u306e\u5217108\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumn_options\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3042\u308b\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3109\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumn_privileges\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u5bfe\u3057\u3001\u307e\u305f\u306f\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u3001\u5217\u306b\u4e0e\u3048\u3089\u308c\u305f\u6a29\u9650110\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumn_udt_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u30c7\u30fc\u30bf\u578b\u3092\u4f7f\u7528\u3059\u308b\u5168\u3066\u306e\u5217111\u60c5\u5831\u30b9\u30ad\u30fc\u30decolumns\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u5217\uff08\u3082\u3057\u304f\u306f\u30d3\u30e5\u30fc\u306e\u5217\uff09112\u60c5\u5831\u30b9\u30ad\u30fc\u30deconstraint_column_usage\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5236\u7d04\u3092\u4f7f\u7528\u3059\u308b\u5168\u3066\u306e\u5217113\u60c5\u5831\u30b9\u30ad\u30fc\u30deconstraint_table_usage\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306b\u304a\u3044\u3066\u3001\u3042\u308b\u5236\u7d04\u3067\u4f7f\u7528\u3055\u308c\u3001\u304b\u3064\u3001\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb114\u60c5\u5831\u30b9\u30ad\u30fc\u30dedata_type_privileges\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u5168\u3066\u306e\u30c7\u30fc\u30bf\u578b\u8a18\u8ff0\u5b50115\u60c5\u5831\u30b9\u30ad\u30fc\u30dedomain_constraints\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u30c9\u30e1\u30a4\u30f3\u306b\u5c5e\u3059\u308b\u5168\u3066\u306e\u5236\u7d04116\u60c5\u5831\u30b9\u30ad\u30fc\u30dedomain_udt_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u3059\u308b\u30c7\u30fc\u30bf\u578b\u306b\u57fa\u3065\u3044\u305f\u3059\u3079\u3066\u306e\u30c9\u30e1\u30a4\u30f3117\u60c5\u5831\u30b9\u30ad\u30fc\u30dedomains\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u30c9\u30e1\u30a4\u30f3118\u60c5\u5831\u30b9\u30ad\u30fc\u30deelement_types\u914d\u5217\u306e\u8981\u7d20\u306e\u30c7\u30fc\u30bf\u578b\u8a18\u8ff0\u5b50119\u60c5\u5831\u30b9\u30ad\u30fc\u30deenabled_roles\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb120\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_data_wrapper_options\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u5916\u90e8\u30c7\u30fc\u30bf\u30e9\u30c3\u30d1\u30fc\u7528\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3121\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_data_wrappers\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u3001\u3059\u3079\u3066\u306e\u5916\u90e8\u30c7\u30fc\u30bf\u30e9\u30c3\u30d1\u30fc122\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_server_options\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u5916\u90e8\u30b5\u30fc\u30d0\u7528\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3123\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_servers\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u5916\u90e8\u30b5\u30fc\u30d0124\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_table_options\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3125\u60c5\u5831\u30b9\u30ad\u30fc\u30deforeign_tables\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u5168\u3066\u306e\u5916\u90e8\u30c6\u30fc\u30d6\u30eb126\u60c5\u5831\u30b9\u30ad\u30fc\u30dekey_column_usage\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u304a\u3044\u3066\u3001\u3042\u308b\u4e00\u610f\u6027\u5236\u7d04\u3001\u4e3b\u30ad\u30fc\u5236\u7d04\u3001\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u306b\u3088\u3063\u3066\u5236\u9650\u3092\u53d7\u3051\u3066\u3044\u308b\u5168\u3066\u306e\u5217127\u60c5\u5831\u30b9\u30ad\u30fc\u30deparameters\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3042\u308b\u5168\u3066\u306e\u95a2\u6570\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\uff08\u5f15\u6570\uff09128\u60c5\u5831\u30b9\u30ad\u30fc\u30dereferential_constraints\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306b\u3042\u308b\u5168\u3066\u306e\u53c2\u7167\uff08\u5916\u90e8\u30ad\u30fc\uff09\u5236\u7d04129\u60c5\u5831\u30b9\u30ad\u30fc\u30derole_column_grants\u8b72\u4e0e\u8005\u307e\u305f\u306f\u88ab\u8b72\u4e0e\u8005\u304c\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u3067\u3042\u308b\u5834\u5408\u3001\u5217\u306b\u4ed8\u4e0e\u3055\u308c\u305f\u5168\u3066\u306e\u6a29\u9650130\u60c5\u5831\u30b9\u30ad\u30fc\u30derole_routine_grants\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u8b72\u4e0e\u8005\u3001\u307e\u305f\u306f\u88ab\u8b72\u4e0e\u8005\u3067\u95a2\u6570\u4e0a\u306b\u4e0e\u3048\u3089\u308c\u305f\u5168\u3066\u306e\u6a29\u9650131\u60c5\u5831\u30b9\u30ad\u30fc\u30derole_table_grants\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u8b72\u4e0e\u8005\u307e\u305f\u306f\u88ab\u8b72\u4e0e\u8005\u3067\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u3084\u30d3\u30e5\u30fc\u4e0a\u306b\u4e0e\u3048\u3089\u308c\u305f\u5168\u3066\u306e\u6a29\u9650132\u60c5\u5831\u30b9\u30ad\u30fc\u30derole_udt_grants\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u4ed8\u4e0e\u8005\u307e\u305f\u88ab\u4ed8\u4e0e\u8005\u3067\u3042\u308b\u3001\u30e6\u30fc\u30b6\u5b9a\u7fa9\u578b\u306b\u4ed8\u4e0e\u3055\u308c\u305fUSAGE\u6a29\u9650133\u60c5\u5831\u30b9\u30ad\u30fc\u30derole_usage_grants\u8b72\u4e0e\u8005\u307e\u305f\u306f\u88ab\u8b72\u4e0e\u8005\u304c\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u3067\u3042\u308b\u591a\u304f\u306e\u7a2e\u985e\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3001USAGE\u6a29\u9650134\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutine_column_usage\u95a2\u6570\u307e\u305f\u306f\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3067\u4f7f\u7528\u3055\u308c\u308b\u5168\u3066\u306e\u5217135\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutine_privileges\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u4e0e\u3048\u3089\u308c\u305f\u6a29\u9650\u3001\u3042\u308b\u3044\u306f\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u95a2\u6570\u306b\u4e0e\u3048\u3089\u308c\u305f\u6a29\u9650136\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutine_routine_usage\u73fe\u5728\u4f7f\u7528\u53ef\u80fd\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u6240\u6709\u3055\u308c\u3066\u3044\u308b\u3001\u672c\u4f53\/\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u5225\u306e\u95a2\u6570\u306b\u3088\u3063\u3066\u4f7f\u308f\u308c\u3066\u3044\u308b\u95a2\u6570137\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutine_sequence_usage\u73fe\u5728\u4f7f\u7528\u53ef\u80fd\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u6240\u6709\u3055\u308c\u3066\u3044\u308b\u3001\u672c\u4f53\/\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u5225\u306e\u95a2\u6570\u306b\u3088\u3063\u3066\u4f7f\u308f\u308c\u3066\u3044\u308b\u30b7\u30fc\u30b1\u30f3\u30b9138\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutine_table_usage\u95a2\u6570\u307e\u305f\u306f\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3067\u4f7f\u7528\u3055\u308c\u308b\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb139\u60c5\u5831\u30b9\u30ad\u30fc\u30deroutines\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u5168\u3066\u306e\u95a2\u6570\u3068\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3140\u60c5\u5831\u30b9\u30ad\u30fc\u30deschemata\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e2d\u3067\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3059\u3079\u3066\u306e\u30b9\u30ad\u30fc\u30de141\u60c5\u5831\u30b9\u30ad\u30fc\u30desequences\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30b7\u30fc\u30b1\u30f3\u30b9142\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_features\u6a19\u6e96SQL\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u516c\u5f0f\u306a\u6a5f\u80fd\u306e\u3069\u308c\u304cPostgreSQL\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u304b143\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_implementation_info\u6a19\u6e96SQL\u3067\u5b9f\u88c5\u4f9d\u5b58\u3067\u5b9a\u7fa9\u3059\u308b\u3082\u306e\u3068\u3055\u308c\u3066\u3044\u308b\u5404\u7a2e\u72b6\u6cc1144\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_parts\u6a19\u6e96SQL\u306e\u3069\u306e\u90e8\u5206\u304cPostgreSQL\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u304b145\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_sizingPostgreSQL\u4e2d\u306e\u5404\u7a2e\u30b5\u30a4\u30ba\u5236\u9650\u3068\u4e0a\u9650\u5024146\u60c5\u5831\u30b9\u30ad\u30fc\u30detable_constraints\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u6240\u6709\u3059\u308b\u3001\u307e\u305f\u306f\u4f55\u3089\u304b\u306eSELECT\u4ee5\u5916\u306e\u6a29\u9650\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb147\u60c5\u5831\u30b9\u30ad\u30fc\u30detable_privileges\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u5bfe\u3057\u3001\u307e\u305f\u306f\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u3082\u3057\u304f\u306f\u30d3\u30e5\u30fc\u306b\u4e0e\u3048\u3089\u308c\u305f\u6a29\u9650148\u60c5\u5831\u30b9\u30ad\u30fc\u30detables\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u30d3\u30e5\u30fc149\u60c5\u5831\u30b9\u30ad\u30fc\u30detransforms\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u5909\u63db150\u60c5\u5831\u30b9\u30ad\u30fc\u30detriggered_update_columns\u5217\u30ea\u30b9\u30c8\u3092\u6307\u5b9a\u3059\u308b\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30c8\u30ea\u30ac\u306b\u304a\u3051\u308b\u3001\u305d\u308c\u3089\u306e\u5217151\u60c5\u5831\u30b9\u30ad\u30fc\u30detriggers\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u3067\u3001\u73fe\u5728\u306e\u30e6\u30fc\u30b6\u304c\u6240\u6709\u3059\u308b\u3042\u308b\u3044\u306f\u4f55\u3089\u304b\u306eSELECT\u4ee5\u5916\u306e\u6a29\u9650\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u307e\u305f\u306f\u30d3\u30e5\u30fc\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u3001\u5168\u3066\u306e\u30c8\u30ea\u30ac152\u60c5\u5831\u30b9\u30ad\u30fc\u30deudt_privileges\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u4ed8\u4e0e\u8005\u307e\u305f\u306f\u88ab\u4ed8\u4e0e\u8005\u3067\u3042\u308b\u3001\u30e6\u30fc\u30b6\u5b9a\u7fa9\u578b\u306b\u4ed8\u4e0e\u3055\u308c\u305fUSAGE\u6a29\u9650153\u60c5\u5831\u30b9\u30ad\u30fc\u30deusage_privileges\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u3001\u3082\u3057\u304f\u306f\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u306b\u3088\u3063\u3066\u4e0e\u3048\u3089\u308c\u305f\u3001\u5404\u7a2e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4e0a\u306eUSAGE\u6a29\u9650154\u60c5\u5831\u30b9\u30ad\u30fc\u30deuser_defined_types\u73fe\u5728\u306f\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u8907\u5408\u30c7\u30fc\u30bf\u578b155\u60c5\u5831\u30b9\u30ad\u30fc\u30deuser_mapping_options\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u30e6\u30fc\u30b6\u30de\u30c3\u30d4\u30f3\u30b0\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u5168\u3066\u306e\u30aa\u30d7\u30b7\u30e7\u30f3156\u60c5\u5831\u30b9\u30ad\u30fc\u30deuser_mappings\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u30e6\u30fc\u30b6\u30de\u30c3\u30d4\u30f3\u30b0\u3059\u3079\u3066157\u60c5\u5831\u30b9\u30ad\u30fc\u30deview_column_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u8005\u306e\u30d3\u30e5\u30fc\u306e\u554f\u3044\u5408\u308f\u305b\u5f0f\uff08\u30d3\u30e5\u30fc\u3092\u5b9a\u7fa9\u3059\u308bSELECT\u6587\uff09\u3067\u4f7f\u7528\u3055\u308c\u308b\u5168\u3066\u306e\u5217158\u60c5\u5831\u30b9\u30ad\u30fc\u30deview_routine_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u8005\u306e\u30d3\u30e5\u30fc\u306e\u554f\u3044\u5408\u308f\u305b\u5f0f\uff08\u30d3\u30e5\u30fc\u3092\u5b9a\u7fa9\u3059\u308bSELECT\u6587\uff09\u3067\u4f7f\u7528\u3055\u308c\u308b\u5168\u3066\u306e\u30eb\u30fc\u30c1\u30f3159\u60c5\u5831\u30b9\u30ad\u30fc\u30deview_table_usage\u73fe\u5728\u6709\u52b9\u306a\u30ed\u30fc\u30eb\u304c\u6240\u6709\u8005\u306e\u30d3\u30e5\u30fc\u306e\u554f\u3044\u5408\u308f\u305b\u5f0f\uff08\u30d3\u30e5\u30fc\u3092\u5b9a\u7fa9\u3059\u308bSELECT\u6587\uff09\u3067\u4f7f\u7528\u3055\u308c\u308b\u5168\u3066\u306e\u30c6\u30fc\u30d6\u30eb160\u60c5\u5831\u30b9\u30ad\u30fc\u30deviews\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30d3\u30e5\u30fc161\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_languagesPostgreSQL\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u308b\u3001\u5404SQL\u8a00\u8a9e\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0162\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_packages\u3069\u306e\u6a19\u6e96SQL\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u6a5f\u80fd\u30d1\u30c3\u30b1\u30fc\u30b8\u304cPostgreSQL\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u304b163\u60c5\u5831\u30b9\u30ad\u30fc\u30desql_sizing_profiles\u6a19\u6e96SQL\u306e\u5404\u7a2e\u30d7\u30ed\u30d5\u30a1\u30a4\u30eb\u3067\u8981\u6c42\u3055\u308c\u308bsql_sizing\u5024164\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5d[S+]\u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002165\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5d[S+] \u540d\u524d\u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u8aac\u660e\u3092\u8868\u793a\u3057\u307e\u3059\u3002166\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5da[S] [\u30d1\u30bf\u30fc\u30f3]\u96c6\u7d04\u95a2\u6570\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002167\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dA[+] [\u30d1\u30bf\u30fc\u30f3]\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002168\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5db[+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30fc\u30d6\u30eb\u7a7a\u9593\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002169\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dc[S+] [\u30d1\u30bf\u30fc\u30f3]\u7b26\u53f7\u5316\u65b9\u5f0f\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002170\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dC[+] [\u30d1\u30bf\u30fc\u30f3]\u30ad\u30e3\u30b9\u30c8\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002171\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dd[S] [\u30d1\u30bf\u30fc\u30f3]\u4ed6\u3067\u306f\u8868\u793a\u3055\u308c\u306a\u3044\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u8aac\u660e\u3092\u8868\u793a\u3057\u307e\u3059\u3002172\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dD[S+] [\u30d1\u30bf\u30fc\u30f3]\u30c9\u30e1\u30a4\u30f3\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002173\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5ddp [\u30d1\u30bf\u30fc\u30f3]\u30c7\u30d5\u30a9\u30eb\u30c8\u6a29\u9650\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002174\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dE[S+] [\u30d1\u30bf\u30fc\u30f3]\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002175\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5det[+] [\u30d1\u30bf\u30fc\u30f3]\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002176\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5des[+] [\u30d1\u30bf\u30fc\u30f3]\u5916\u90e8\u30b5\u30fc\u30d0\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002177\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5deu[+] [\u30d1\u30bf\u30fc\u30f3]\u30e6\u30fc\u30b6\u30de\u30c3\u30d4\u30f3\u30b0\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002178\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dew[+] [\u30d1\u30bf\u30fc\u30f3]\u5916\u90e8\u30c7\u30fc\u30bf\u30e9\u30c3\u30d1\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002179\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5df[antw][S+] [\u30d1\u30bf\u30fc\u30f3](\u96c6\u7d04\/\u901a\u5e38\/\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\/\u30c8\u30ea\u30ac\u30fc\/\u30a6\u30a3\u30f3\u30c9\u30a6)\u95a2\u6570(\u306e\u307f)\u306e\u4e00\u89a7 \u3092\u8868\u793a\u3057\u307e\u3059180\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dF[+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u8a2d\u5b9a\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002181\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dFd[+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u7528\u8f9e\u66f8\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002182\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dFp[+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u7528\u30d1\u30fc\u30b5\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002183\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dFt[+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u7528\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002184\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dg[S+] [\u30d1\u30bf\u30fc\u30f3]\u30ed\u30fc\u30eb\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002185\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5di[S+] [\u30d1\u30bf\u30fc\u30f3]\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002186\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dl\u30e9\u30fc\u30b8\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002\u00a5lo_list \u3068\u540c\u3058\u3067\u3059\u3002187\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dL[S+] [\u30d1\u30bf\u30fc\u30f3]\u624b\u7d9a\u304d\u8a00\u8a9e\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002188\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dm[S+] [\u30d1\u30bf\u30fc\u30f3]\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002189\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dn[S+] [\u30d1\u30bf\u30fc\u30f3]\u30b9\u30ad\u30fc\u30de\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002190\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5do[S] [\u540d\u524d]\u6f14\u7b97\u5b50\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002191\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dO[S+] [\u30d1\u30bf\u30fc\u30f3]\u7167\u5408\u9806\u5e8f\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002192\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dp [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002193\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5drds [\u30d1\u30bf\u30fc\u30f31 [\u30d1\u30bf\u30fc\u30f32]]\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u6bce\u306e\u30ed\u30fc\u30eb\u8a2d\u5b9a\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002194\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dRp[+] [\u30d1\u30bf\u30fc\u30f3]\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d6\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002195\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dRs[+] [\u30d1\u30bf\u30fc\u30f3]\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002196\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dc[S+] [\u30d1\u30bf\u30fc\u30f3]\u5909\u63db\u30b7\u30fc\u30b1\u30f3\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002197\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5ds[S+] [\u30d1\u30bf\u30fc\u30f3]\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002198\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dt[S+] [\u30d1\u30bf\u30fc\u30f3]\u30c7\u30fc\u30bf\u578b\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002199\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5du[S+] [\u30d1\u30bf\u30fc\u30f3]\u30ed\u30fc\u30eb\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002200\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dv[S+] [\u30d1\u30bf\u30fc\u30f3]\u30d3\u30e5\u30fc\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002201\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dx[+] [\u30d1\u30bf\u30fc\u30f3]\u62e1\u5f35\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002202\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5dy [\u30d1\u30bf\u30fc\u30f3]\u30a4\u30d9\u30f3\u30c8\u30c8\u30ea\u30ac\u30fc\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002203\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5l[+] [\u30d1\u30bf\u30fc\u30f3]\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002204\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5sf[+] \u95a2\u6570\u540d\u95a2\u6570\u5b9a\u7fa9\u3092\u8868\u793a\u3057\u307e\u3059\u3002205\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5sv[+] \u30d3\u30e5\u30fc\u540d\u30d3\u30e5\u30fc\u5b9a\u7fa9\u3092\u8868\u793a\u3057\u307e\u3059\u3002206\u30e1\u30bf\u30b3\u30de\u30f3\u30c9\u00a5z [\u30d1\u30bf\u30fc\u30f3]\u00a5dp \u3068\u540c\u3058\u3067\u3059\u3002<\/div>\n<\/div>\n
\u4ee5\u4e0b\u662f\u4e00\u79cd\u53ef\u80fd\u7684\u6c49\u8bed\u91ca\u4e49\uff1a<\/h1>\n
\u6279\u5904\u7406<\/p>\n
type nul > pg_aggregate.sql\r\ntype nul > pg_am.sql\r\ntype nul > pg_amop.sql\r\ntype nul > pg_amproc.sql\r\ntype nul > pg_attrdef.sql\r\ntype nul > pg_attribute.sql\r\ntype nul > pg_authid.sql\r\ntype nul > pg_auth_members.sql\r\ntype nul > pg_cast.sql\r\ntype nul > pg_class.sql\r\ntype nul > pg_collation.sql\r\ntype nul > pg_constraint.sql\r\ntype nul > pg_conversion.sql\r\ntype nul > pg_database.sql\r\ntype nul > pg_db_role_setting.sql\r\ntype nul > pg_default_acl.sql\r\ntype nul > pg_depend.sql\r\ntype nul > pg_description.sql\r\ntype nul > pg_enum.sql\r\ntype nul > pg_event_trigger.sql\r\ntype nul > pg_extension.sql\r\ntype nul > pg_foreign_data_wrapper.sql\r\ntype nul > pg_foreign_server.sql\r\ntype nul > pg_foreign_table.sql\r\ntype nul > pg_index.sql\r\ntype nul > pg_inherits.sql\r\ntype nul > pg_init_privs.sql\r\ntype nul > pg_language.sql\r\ntype nul > pg_largeobject.sql\r\ntype nul > pg_largeobject_metadata.sql\r\ntype nul > pg_namespace.sql\r\ntype nul > pg_opclass.sql\r\ntype nul > pg_operator.sql\r\ntype nul > pg_opfamily.sql\r\ntype nul > pg_partitioned_table.sql\r\ntype nul > pg_policy.sql\r\ntype nul > pg_proc.sql\r\ntype nul > pg_publication.sql\r\ntype nul > pg_publication_rel.sql\r\ntype nul > pg_range.sql\r\ntype nul > pg_replication_origin.sql\r\ntype nul > pg_rewrite.sql\r\ntype nul > pg_seclabel.sql\r\ntype nul > pg_sequence.sql\r\ntype nul > pg_shdepend.sql\r\ntype nul > pg_shdescription.sql\r\ntype nul > pg_shseclabel.sql\r\ntype nul > pg_statistic.sql\r\ntype nul > pg_statistic_ext.sql\r\ntype nul > pg_statistic_ext_data.sql\r\ntype nul > pg_subscription.sql\r\ntype nul > pg_subscription_rel.sql\r\ntype nul > pg_tablespace.sql\r\ntype nul > pg_transform.sql\r\ntype nul > pg_trigger.sql\r\ntype nul > pg_ts_config.sql\r\ntype nul > pg_ts_config_map.sql\r\ntype nul > pg_ts_dict.sql\r\ntype nul > pg_ts_parser.sql\r\ntype nul > pg_ts_template.sql\r\ntype nul > pg_type.sql\r\ntype nul > pg_user_mapping.sql\r\ntype nul > pg_available_extensions.sql\r\ntype nul > pg_available_extension_versions.sql\r\ntype nul > pg_backend_memory_contexts.sql\r\ntype nul > pg_config.sql\r\ntype nul > pg_cursors.sql\r\ntype nul > pg_file_settings.sql\r\ntype nul > pg_group.sql\r\ntype nul > pg_hba_file_rules.sql\r\ntype nul > pg_indexes.sql\r\ntype nul > pg_locks.sql\r\ntype nul > pg_matviews.sql\r\ntype nul > pg_policies.sql\r\ntype nul > pg_prepared_statements.sql\r\ntype nul > pg_prepared_xacts.sql\r\ntype nul > pg_publication_tables.sql\r\ntype nul > pg_replication_origin_status.sql\r\ntype nul > pg_replication_slots.sql\r\ntype nul > pg_roles.sql\r\ntype nul > pg_rules.sql\r\ntype nul > pg_seclabels.sql\r\ntype nul > pg_sequences.sql\r\ntype nul > pg_settings.sql\r\ntype nul > pg_shadow.sql\r\ntype nul > pg_shmem_allocations.sql\r\ntype nul > pg_stats.sql\r\ntype nul > pg_stats_ext.sql\r\ntype nul > pg_stats_ext_exprs.sql\r\ntype nul > pg_tables.sql\r\ntype nul > pg_timezone_abbrevs.sql\r\ntype nul > pg_timezone_names.sql\r\ntype nul > pg_user.sql\r\ntype nul > pg_user_mappings.sql\r\ntype nul > pg_views.sql\r\ntype nul > pg_pltemplate.sql\r\necho \\o pg_aggregate.sql >> pg_aggregate.sql\r\necho \\o pg_am.sql >> pg_am.sql\r\necho \\o pg_amop.sql >> pg_amop.sql\r\necho \\o pg_amproc.sql >> pg_amproc.sql\r\necho \\o pg_attrdef.sql >> pg_attrdef.sql\r\necho \\o pg_attribute.sql >> pg_attribute.sql\r\necho \\o pg_authid.sql >> pg_authid.sql\r\necho \\o pg_auth_members.sql >> pg_auth_members.sql\r\necho \\o pg_cast.sql >> pg_cast.sql\r\necho \\o pg_class.sql >> pg_class.sql\r\necho \\o pg_collation.sql >> pg_collation.sql\r\necho \\o pg_constraint.sql >> pg_constraint.sql\r\necho \\o pg_conversion.sql >> pg_conversion.sql\r\necho \\o pg_database.sql >> pg_database.sql\r\necho \\o pg_db_role_setting.sql >> pg_db_role_setting.sql\r\necho \\o pg_default_acl.sql >> pg_default_acl.sql\r\necho \\o pg_depend.sql >> pg_depend.sql\r\necho \\o pg_description.sql >> pg_description.sql\r\necho \\o pg_enum.sql >> pg_enum.sql\r\necho \\o pg_event_trigger.sql >> pg_event_trigger.sql\r\necho \\o pg_extension.sql >> pg_extension.sql\r\necho \\o pg_foreign_data_wrapper.sql >> pg_foreign_data_wrapper.sql\r\necho \\o pg_foreign_server.sql >> pg_foreign_server.sql\r\necho \\o pg_foreign_table.sql >> pg_foreign_table.sql\r\necho \\o pg_index.sql >> pg_index.sql\r\necho \\o pg_inherits.sql >> pg_inherits.sql\r\necho \\o pg_init_privs.sql >> pg_init_privs.sql\r\necho \\o pg_language.sql >> pg_language.sql\r\necho \\o pg_largeobject.sql >> pg_largeobject.sql\r\necho \\o pg_largeobject_metadata.sql >> pg_largeobject_metadata.sql\r\necho \\o pg_namespace.sql >> pg_namespace.sql\r\necho \\o pg_opclass.sql >> pg_opclass.sql\r\necho \\o pg_operator.sql >> pg_operator.sql\r\necho \\o pg_opfamily.sql >> pg_opfamily.sql\r\necho \\o pg_partitioned_table.sql >> pg_partitioned_table.sql\r\necho \\o pg_policy.sql >> pg_policy.sql\r\necho \\o pg_proc.sql >> pg_proc.sql\r\necho \\o pg_publication.sql >> pg_publication.sql\r\necho \\o pg_publication_rel.sql >> pg_publication_rel.sql\r\necho \\o pg_range.sql >> pg_range.sql\r\necho \\o pg_replication_origin.sql >> pg_replication_origin.sql\r\necho \\o pg_rewrite.sql >> pg_rewrite.sql\r\necho \\o pg_seclabel.sql >> pg_seclabel.sql\r\necho \\o pg_sequence.sql >> pg_sequence.sql\r\necho \\o pg_shdepend.sql >> pg_shdepend.sql\r\necho \\o pg_shdescription.sql >> pg_shdescription.sql\r\necho \\o pg_shseclabel.sql >> pg_shseclabel.sql\r\necho \\o pg_statistic.sql >> pg_statistic.sql\r\necho \\o pg_statistic_ext.sql >> pg_statistic_ext.sql\r\necho \\o pg_statistic_ext_data.sql >> pg_statistic_ext_data.sql\r\necho \\o pg_subscription.sql >> pg_subscription.sql\r\necho \\o pg_subscription_rel.sql >> pg_subscription_rel.sql\r\necho \\o pg_tablespace.sql >> pg_tablespace.sql\r\necho \\o pg_transform.sql >> pg_transform.sql\r\necho \\o pg_trigger.sql >> pg_trigger.sql\r\necho \\o pg_ts_config.sql >> pg_ts_config.sql\r\necho \\o pg_ts_config_map.sql >> pg_ts_config_map.sql\r\necho \\o pg_ts_dict.sql >> pg_ts_dict.sql\r\necho \\o pg_ts_parser.sql >> pg_ts_parser.sql\r\necho \\o pg_ts_template.sql >> pg_ts_template.sql\r\necho \\o pg_type.sql >> pg_type.sql\r\necho \\o pg_user_mapping.sql >> pg_user_mapping.sql\r\necho \\o pg_available_extensions.sql >> pg_available_extensions.sql\r\necho \\o pg_available_extension_versions.sql >> pg_available_extension_versions.sql\r\necho \\o pg_backend_memory_contexts.sql >> pg_backend_memory_contexts.sql\r\necho \\o pg_config.sql >> pg_config.sql\r\necho \\o pg_cursors.sql >> pg_cursors.sql\r\necho \\o pg_file_settings.sql >> pg_file_settings.sql\r\necho \\o pg_group.sql >> pg_group.sql\r\necho \\o pg_hba_file_rules.sql >> pg_hba_file_rules.sql\r\necho \\o pg_indexes.sql >> pg_indexes.sql\r\necho \\o pg_locks.sql >> pg_locks.sql\r\necho \\o pg_matviews.sql >> pg_matviews.sql\r\necho \\o pg_policies.sql >> pg_policies.sql\r\necho \\o pg_prepared_statements.sql >> pg_prepared_statements.sql\r\necho \\o pg_prepared_xacts.sql >> pg_prepared_xacts.sql\r\necho \\o pg_publication_tables.sql >> pg_publication_tables.sql\r\necho \\o pg_replication_origin_status.sql >> pg_replication_origin_status.sql\r\necho \\o pg_replication_slots.sql >> pg_replication_slots.sql\r\necho \\o pg_roles.sql >> pg_roles.sql\r\necho \\o pg_rules.sql >> pg_rules.sql\r\necho \\o pg_seclabels.sql >> pg_seclabels.sql\r\necho \\o pg_sequences.sql >> pg_sequences.sql\r\necho \\o pg_settings.sql >> pg_settings.sql\r\necho \\o pg_shadow.sql >> pg_shadow.sql\r\necho \\o pg_shmem_allocations.sql >> pg_shmem_allocations.sql\r\necho \\o pg_stats.sql >> pg_stats.sql\r\necho \\o pg_stats_ext.sql >> pg_stats_ext.sql\r\necho \\o pg_stats_ext_exprs.sql >> pg_stats_ext_exprs.sql\r\necho \\o pg_tables.sql >> pg_tables.sql\r\necho \\o pg_timezone_abbrevs.sql >> pg_timezone_abbrevs.sql\r\necho \\o pg_timezone_names.sql >> pg_timezone_names.sql\r\necho \\o pg_user.sql >> pg_user.sql\r\necho \\o pg_user_mappings.sql >> pg_user_mappings.sql\r\necho \\o pg_views.sql >> pg_views.sql\r\necho \\o pg_pltemplate.sql >> pg_pltemplate.sql\r\n\r\n\r\necho select * from pg_aggregate; >> pg_aggregate.sql\r\necho select * from pg_am; >> pg_am.sql\r\necho select * from pg_amop; >> pg_amop.sql\r\necho select * from pg_amproc; >> pg_amproc.sql\r\necho select * from pg_attrdef; >> pg_attrdef.sql\r\necho select * from pg_attribute; >> pg_attribute.sql\r\necho select * from pg_authid; >> pg_authid.sql\r\necho select * from pg_auth_members; >> pg_auth_members.sql\r\necho select * from pg_cast; >> pg_cast.sql\r\necho select * from pg_class; >> pg_class.sql\r\necho select * from pg_collation; >> pg_collation.sql\r\necho select * from pg_constraint; >> pg_constraint.sql\r\necho select * from pg_conversion; >> pg_conversion.sql\r\necho select * from pg_database; >> pg_database.sql\r\necho select * from pg_db_role_setting; >> pg_db_role_setting.sql\r\necho select * from pg_default_acl; >> pg_default_acl.sql\r\necho select * from pg_depend; >> pg_depend.sql\r\necho select * from pg_description; >> pg_description.sql\r\necho select * from pg_enum; >> pg_enum.sql\r\necho select * from pg_event_trigger; >> pg_event_trigger.sql\r\necho select * from pg_extension; >> pg_extension.sql\r\necho select * from pg_foreign_data_wrapper; >> pg_foreign_data_wrapper.sql\r\necho select * from pg_foreign_server; >> pg_foreign_server.sql\r\necho select * from pg_foreign_table; >> pg_foreign_table.sql\r\necho select * from pg_index; >> pg_index.sql\r\necho select * from pg_inherits; >> pg_inherits.sql\r\necho select * from pg_init_privs; >> pg_init_privs.sql\r\necho select * from pg_language; >> pg_language.sql\r\necho select * from pg_largeobject; >> pg_largeobject.sql\r\necho select * from pg_largeobject_metadata; >> pg_largeobject_metadata.sql\r\necho select * from pg_namespace; >> pg_namespace.sql\r\necho select * from pg_opclass; >> pg_opclass.sql\r\necho select * from pg_operator; >> pg_operator.sql\r\necho select * from pg_opfamily; >> pg_opfamily.sql\r\necho select * from pg_partitioned_table; >> pg_partitioned_table.sql\r\necho select * from pg_policy; >> pg_policy.sql\r\necho select * from pg_proc; >> pg_proc.sql\r\necho select * from pg_publication; >> pg_publication.sql\r\necho select * from pg_publication_rel; >> pg_publication_rel.sql\r\necho select * from pg_range; >> pg_range.sql\r\necho select * from pg_replication_origin; >> pg_replication_origin.sql\r\necho select * from pg_rewrite; >> pg_rewrite.sql\r\necho select * from pg_seclabel; >> pg_seclabel.sql\r\necho select * from pg_sequence; >> pg_sequence.sql\r\necho select * from pg_shdepend; >> pg_shdepend.sql\r\necho select * from pg_shdescription; >> pg_shdescription.sql\r\necho select * from pg_shseclabel; >> pg_shseclabel.sql\r\necho select * from pg_statistic; >> pg_statistic.sql\r\necho select * from pg_statistic_ext; >> pg_statistic_ext.sql\r\necho select * from pg_statistic_ext_data; >> pg_statistic_ext_data.sql\r\necho select * from pg_subscription; >> pg_subscription.sql\r\necho select * from pg_subscription_rel; >> pg_subscription_rel.sql\r\necho select * from pg_tablespace; >> pg_tablespace.sql\r\necho select * from pg_transform; >> pg_transform.sql\r\necho select * from pg_trigger; >> pg_trigger.sql\r\necho select * from pg_ts_config; >> pg_ts_config.sql\r\necho select * from pg_ts_config_map; >> pg_ts_config_map.sql\r\necho select * from pg_ts_dict; >> pg_ts_dict.sql\r\necho select * from pg_ts_parser; >> pg_ts_parser.sql\r\necho select * from pg_ts_template; >> pg_ts_template.sql\r\necho select * from pg_type; >> pg_type.sql\r\necho select * from pg_user_mapping; >> pg_user_mapping.sql\r\necho select * from pg_available_extensions; >> pg_available_extensions.sql\r\necho select * from pg_available_extension_versions; >> pg_available_extension_versions.sql\r\necho select * from pg_backend_memory_contexts; >> pg_backend_memory_contexts.sql\r\necho select * from pg_config; >> pg_config.sql\r\necho select * from pg_cursors; >> pg_cursors.sql\r\necho select * from pg_file_settings; >> pg_file_settings.sql\r\necho select * from pg_group; >> pg_group.sql\r\necho select * from pg_hba_file_rules; >> pg_hba_file_rules.sql\r\necho select * from pg_indexes; >> pg_indexes.sql\r\necho select * from pg_locks; >> pg_locks.sql\r\necho select * from pg_matviews; >> pg_matviews.sql\r\necho select * from pg_policies; >> pg_policies.sql\r\necho select * from pg_prepared_statements; >> pg_prepared_statements.sql\r\necho select * from pg_prepared_xacts; >> pg_prepared_xacts.sql\r\necho select * from pg_publication_tables; >> pg_publication_tables.sql\r\necho select * from pg_replication_origin_status; >> pg_replication_origin_status.sql\r\necho select * from pg_replication_slots; >> pg_replication_slots.sql\r\necho select * from pg_roles; >> pg_roles.sql\r\necho select * from pg_rules; >> pg_rules.sql\r\necho select * from pg_seclabels; >> pg_seclabels.sql\r\necho select * from pg_sequences; >> pg_sequences.sql\r\necho select * from pg_settings; >> pg_settings.sql\r\necho select * from pg_shadow; >> pg_shadow.sql\r\necho select * from pg_shmem_allocations; >> pg_shmem_allocations.sql\r\necho select * from pg_stats; >> pg_stats.sql\r\necho select * from pg_stats_ext; >> pg_stats_ext.sql\r\necho select * from pg_stats_ext_exprs; >> pg_stats_ext_exprs.sql\r\necho select * from pg_tables; >> pg_tables.sql\r\necho select * from pg_timezone_abbrevs; >> pg_timezone_abbrevs.sql\r\necho select * from pg_timezone_names; >> pg_timezone_names.sql\r\necho select * from pg_user; >> pg_user.sql\r\necho select * from pg_user_mappings; >> pg_user_mappings.sql\r\necho select * from pg_views; >> pg_views.sql\r\necho select * from pg_pltemplate; >> pg_pltemplate.sql\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u7cfb\u7edf\u76ee\u5f55 14131211109.69.59.49.39.29.19pg_aggregatepg_aggreg […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41388","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nPostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u7b14\u8bb0-3\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL\u7b14\u8bb0\" \/>\n<meta property=\"og:description\" content=\"\u7cfb\u7edf\u76ee\u5f55 14131211109.69.59.49.39.29.19pg_aggregatepg_aggreg […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u7b14\u8bb0-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T10:22:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T14:48:08+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u5b87\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"32 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/\",\"name\":\"PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-07-19T10:22:10+00:00\",\"dateModified\":\"2024-04-29T14:48:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL\u7b14\u8bb0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u7b14\u8bb0-3\/","og_locale":"zh_CN","og_type":"article","og_title":"PostgreSQL\u7b14\u8bb0","og_description":"\u7cfb\u7edf\u76ee\u5f55 14131211109.69.59.49.39.29.19pg_aggregatepg_aggreg […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql\u7b14\u8bb0-3\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-07-19T10:22:10+00:00","article_modified_time":"2024-04-29T14:48:08+00:00","author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"32 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/","name":"PostgreSQL\u7b14\u8bb0 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-07-19T10:22:10+00:00","dateModified":"2024-04-29T14:48:08+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL\u7b14\u8bb0"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/postgresql%e7%ac%94%e8%ae%b0-3\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41388"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41388\/revisions"}],"predecessor-version":[{"id":88109,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41388\/revisions\/88109"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}