PostgreSQL深入浅出 | 数据库的日常维护

2022-09-1109:41:25数据库教程Comments979 views字数 18400阅读模式

1、概述

本篇是继上一篇笔记《课程笔记 | PostgreSQL深入浅出 | 数据库的启动与停止》的续集，本篇主要介绍PostgreSQL数据库的日常基本操作。后续也会持续更新内容。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

2、查看数据库版本

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[postgres@localhost ~]$ pg_ctl -V文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_ctl (PostgreSQL) 12.12文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

3、登录数据库

[postgres@localhost ~]$ psql -d postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

psql (12.12)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Type "help" for help.文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

postgres=#文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

4、列出所有数据库

postgres=# \l文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

5、显示所有用户

postgres=# \du文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

6、查看扩展

postgres=# \dx文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

7、列出表和视图的信息

postgres=# \dS文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

postgres=# \dS文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

List of relations文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Schema   |              Name               | Type  |  Owner文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

------------+---------------------------------+-------+----------文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_aggregate                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_am                           | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_amop                         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_amproc                       | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_attrdef                      | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_attribute                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_auth_members                 | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_authid                       | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_available_extension_versions | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_available_extensions         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_cast                         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_class                        | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_collation                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_config                       | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_constraint                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_conversion                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_cursors                      | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_database                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_db_role_setting              | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_default_acl                  | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_depend                       | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_description                  | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_enum                         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_event_trigger                | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_extension                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_file_settings                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_foreign_data_wrapper         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_foreign_server               | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_foreign_table                | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_group                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_hba_file_rules               | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_index                        | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_indexes                      | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_inherits                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_init_privs                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_language                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_largeobject                  | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_largeobject_metadata         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_locks                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_matviews                     | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_namespace                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_opclass                      | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_operator                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_opfamily                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_partitioned_table            | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_pltemplate                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_policies                     | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_policy                       | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_prepared_statements          | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_prepared_xacts               | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_proc                         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_publication                  | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_publication_rel              | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_publication_tables           | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_range                        | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_replication_origin           | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_replication_origin_status    | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_replication_slots            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_rewrite                      | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_roles                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_rules                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_seclabel                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_seclabels                    | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_sequence                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_sequences                    | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_settings                     | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_shadow                       | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_shdepend                     | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_shdescription                | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_shseclabel                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_activity                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_all_indexes             | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_all_tables              | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_archiver                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_bgwriter                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_database                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_database_conflicts      | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_gssapi                  | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_progress_cluster        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_progress_create_index   | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_progress_vacuum         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_replication             | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_ssl                     | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_subscription            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_sys_indexes             | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_sys_tables              | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_user_functions          | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_user_indexes            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_user_tables             | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_wal_receiver            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_xact_all_tables         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_xact_sys_tables         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_xact_user_functions     | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stat_xact_user_tables        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_all_indexes           | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_all_sequences         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_all_tables            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_sys_indexes           | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_sys_sequences         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_sys_tables            | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_user_indexes          | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_user_sequences        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statio_user_tables           | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statistic                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statistic_ext                | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_statistic_ext_data           | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stats                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_stats_ext                    | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_subscription                 | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_subscription_rel             | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_tables                       | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_tablespace                   | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_timezone_abbrevs             | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_timezone_names               | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_transform                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_trigger                      | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_ts_config                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_ts_config_map                | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_ts_dict                      | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_ts_parser                    | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_ts_template                  | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_type                         | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_user                         | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_user_mapping                 | table | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_user_mappings                | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

pg_catalog | pg_views                        | view  | postgres文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

(126 rows)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

postgres=#文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

补充：postgres=# \dS+ 显示了更多信息，包括表的大小信息。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

8、查看数据库端口号

postgres=# show port;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

9、查看表空间

postgres=# \db+文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

10、列出所有模式

postgres=# \dn文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

11、查看数据库的表

postgres=# \dt文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

12、查看表字段

postgres=# \d {{tablename}}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

13、创建一个数据库

CREATE DATABASE DBTEST1;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

14、切换数据库

postgres=# \c dbtest1文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

15、显示所有帮助信息

dbtest1=# \h文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=# \h文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Available help:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ABORT                            CHECKPOINT                       CREATE USER                      DROP TRIGGER文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER AGGREGATE                  CLOSE                            CREATE USER MAPPING              DROP TYPE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER COLLATION                  CLUSTER                          CREATE VIEW                      DROP USER文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER CONVERSION                 COMMENT                          DEALLOCATE                       DROP USER MAPPING文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER DATABASE                   COMMIT                           DECLARE                          DROP VIEW文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER DEFAULT PRIVILEGES         COMMIT PREPARED                  DELETE                           END文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER DOMAIN                     COPY                             DISCARD                          EXECUTE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER EVENT TRIGGER              CREATE ACCESS METHOD             DO                               EXPLAIN文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER EXTENSION                  CREATE AGGREGATE                 DROP ACCESS METHOD               FETCH文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER FOREIGN DATA WRAPPER       CREATE CAST                      DROP AGGREGATE                   GRANT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER FOREIGN TABLE              CREATE COLLATION                 DROP CAST                        IMPORT FOREIGN SCHEMA文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER FUNCTION                   CREATE CONVERSION                DROP COLLATION                   INSERT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER GROUP                      CREATE DATABASE                  DROP CONVERSION                  LISTEN文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER INDEX                      CREATE DOMAIN                    DROP DATABASE                    LOAD文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER LANGUAGE                   CREATE EVENT TRIGGER             DROP DOMAIN                      LOCK文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER LARGE OBJECT               CREATE EXTENSION                 DROP EVENT TRIGGER               MOVE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER MATERIALIZED VIEW          CREATE FOREIGN DATA WRAPPER      DROP EXTENSION                   NOTIFY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER OPERATOR                   CREATE FOREIGN TABLE             DROP FOREIGN DATA WRAPPER        PREPARE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER OPERATOR CLASS             CREATE FUNCTION                  DROP FOREIGN TABLE               PREPARE TRANSACTION文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER OPERATOR FAMILY            CREATE GROUP                     DROP FUNCTION                    REASSIGN OWNED文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER POLICY                     CREATE INDEX                     DROP GROUP                       REFRESH MATERIALIZED VIEW文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER PROCEDURE                  CREATE LANGUAGE                  DROP INDEX                       REINDEX文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER PUBLICATION                CREATE MATERIALIZED VIEW         DROP LANGUAGE                    RELEASE SAVEPOINT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER ROLE                       CREATE OPERATOR                  DROP MATERIALIZED VIEW           RESET文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER ROUTINE                    CREATE OPERATOR CLASS            DROP OPERATOR                    REVOKE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER RULE                       CREATE OPERATOR FAMILY           DROP OPERATOR CLASS              ROLLBACK文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER SCHEMA                     CREATE POLICY                    DROP OPERATOR FAMILY             ROLLBACK PREPARED文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER SEQUENCE                   CREATE PROCEDURE                 DROP OWNED                       ROLLBACK TO SAVEPOINT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER SERVER                     CREATE PUBLICATION               DROP POLICY                      SAVEPOINT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER STATISTICS                 CREATE ROLE                      DROP PROCEDURE                   SECURITY LABEL文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER SUBSCRIPTION               CREATE RULE                      DROP PUBLICATION                 SELECT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER SYSTEM                     CREATE SCHEMA                    DROP ROLE                        SELECT INTO文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE                      CREATE SEQUENCE                  DROP ROUTINE                     SET文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLESPACE                 CREATE SERVER                    DROP RULE                        SET CONSTRAINTS文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TEXT SEARCH CONFIGURATION  CREATE STATISTICS                DROP SCHEMA                      SET ROLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TEXT SEARCH DICTIONARY     CREATE SUBSCRIPTION              DROP SEQUENCE                    SET SESSION AUTHORIZATION文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TEXT SEARCH PARSER         CREATE TABLE                     DROP SERVER                      SET TRANSACTION文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TEXT SEARCH TEMPLATE       CREATE TABLE AS                  DROP STATISTICS                  SHOW文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TRIGGER                    CREATE TABLESPACE                DROP SUBSCRIPTION                START TRANSACTION文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TYPE                       CREATE TEXT SEARCH CONFIGURATION DROP TABLE                       TABLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER USER                       CREATE TEXT SEARCH DICTIONARY    DROP TABLESPACE                  TRUNCATE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER USER MAPPING               CREATE TEXT SEARCH PARSER        DROP TEXT SEARCH CONFIGURATION   UNLISTEN文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER VIEW                       CREATE TEXT SEARCH TEMPLATE      DROP TEXT SEARCH DICTIONARY      UPDATE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ANALYZE                          CREATE TRANSFORM                 DROP TEXT SEARCH PARSER          VACUUM文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

BEGIN                            CREATE TRIGGER                   DROP TEXT SEARCH TEMPLATE        VALUES文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CALL                             CREATE TYPE                      DROP TRANSFORM                   WITH文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=#文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

16、显示创建表的帮助信息

dbtest1=# \h create table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

 文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=# \h create table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Command:     CREATE TABLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Description: define a new table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Syntax:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

| table_constraint文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

| LIKE source_table [ like_option ... ] }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[, ... ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ INHERITS ( parent_table [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ PARTITION BY { RANGE | LIST | HASH } ( { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ USING method ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ WITH ( storage_parameter [= value] [, ... ] ) | WITHOUT OIDS ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ TABLESPACE tablespace_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

OF type_name [ (文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ column_name [ WITH OPTIONS ] [ column_constraint [ ... ] ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

| table_constraint }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[, ... ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ PARTITION BY { RANGE | LIST | HASH } ( { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ USING method ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ WITH ( storage_parameter [= value] [, ... ] ) | WITHOUT OIDS ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ TABLESPACE tablespace_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PARTITION OF parent_table [ (文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ column_name [ WITH OPTIONS ] [ column_constraint [ ... ] ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

| table_constraint }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[, ... ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

) ] { FOR VALUES partition_bound_spec | DEFAULT }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ PARTITION BY { RANGE | LIST | HASH } ( { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=#文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

17、显示ALTER TABLE的帮助信息

dbtest1=# \h ALTER TABLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=# \h ALTER TABLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Command:     ALTER TABLE文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Description: change the definition of a table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

Syntax:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

action [, ... ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

RENAME [ COLUMN ] column_name TO new_column_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

RENAME CONSTRAINT constraint_name TO new_constraint_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

RENAME TO new_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET SCHEMA new_schema文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET TABLESPACE new_tablespace [ NOWAIT ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ATTACH PARTITION partition_name { FOR VALUES partition_bound_spec | DEFAULT }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER TABLE [ IF EXISTS ] name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DETACH PARTITION partition_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

where action is one of:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DROP [ COLUMN ] [ IF EXISTS ] column_name [ RESTRICT | CASCADE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name SET DEFAULT expression文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name DROP DEFAULT文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name { SET | DROP } NOT NULL文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( sequence_options ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name { SET GENERATED { ALWAYS | BY DEFAULT } | SET sequence_option | RESTART [ [ WITH ] restart ] } [...]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name DROP IDENTITY [ IF EXISTS ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name SET STATISTICS integer文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ADD table_constraint [ NOT VALID ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ADD table_constraint_using_index文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

VALIDATE CONSTRAINT constraint_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DROP CONSTRAINT [ IF EXISTS ]  constraint_name [ RESTRICT | CASCADE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DISABLE TRIGGER [ trigger_name | ALL | USER ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE TRIGGER [ trigger_name | ALL | USER ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE REPLICA TRIGGER trigger_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE ALWAYS TRIGGER trigger_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DISABLE RULE rewrite_rule_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE RULE rewrite_rule_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE REPLICA RULE rewrite_rule_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE ALWAYS RULE rewrite_rule_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DISABLE ROW LEVEL SECURITY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

ENABLE ROW LEVEL SECURITY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

FORCE ROW LEVEL SECURITY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

NO FORCE ROW LEVEL SECURITY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CLUSTER ON index_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET WITHOUT CLUSTER文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET WITHOUT OIDS文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET TABLESPACE new_tablespace文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET { LOGGED | UNLOGGED }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

SET ( storage_parameter [= value] [, ... ] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

RESET ( storage_parameter [, ... ] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

INHERIT parent_table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

NO INHERIT parent_table文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

OF type_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

NOT OF文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

OWNER TO { new_owner | CURRENT_USER | SESSION_USER }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

REPLICA IDENTITY { DEFAULT | USING INDEX index_name | FULL | NOTHING }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

and partition_bound_spec is:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

IN ( partition_bound_expr [, ...] ) |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

FROM ( { partition_bound_expr | MINVALUE | MAXVALUE } [, ...] )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

TO ( { partition_bound_expr | MINVALUE | MAXVALUE } [, ...] ) |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

WITH ( MODULUS numeric_literal, REMAINDER numeric_literal )文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

and column_constraint is:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ CONSTRAINT constraint_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ NOT NULL |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

NULL |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

CHECK ( expression ) [ NO INHERIT ] |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

DEFAULT default_expr |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

GENERATED ALWAYS AS ( generation_expr ) STORED |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( sequence_options ) ] |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

UNIQUE index_parameters |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PRIMARY KEY index_parameters |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ ON DELETE referential_action ] [ ON UPDATE referential_action ] }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

and table_constraint is:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ CONSTRAINT constraint_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ CHECK ( expression ) [ NO INHERIT ] |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

UNIQUE ( column_name [, ... ] ) index_parameters |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PRIMARY KEY ( column_name [, ... ] ) index_parameters |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) index_parameters [ WHERE ( predicate ) ] |文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] }文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

and table_constraint_using_index is:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ CONSTRAINT constraint_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ UNIQUE | PRIMARY KEY } USING INDEX index_name文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ INCLUDE ( column_name [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ WITH ( storage_parameter [= value] [, ... ] ) ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

[ USING INDEX TABLESPACE tablespace_name ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

exclude_element in an EXCLUDE constraint is:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

{ column_name | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

URL: https://www.postgresql.org/docs/12/sql-altertable.html文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

dbtest1=#文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

18、查询数据库的链接信息

postgres=# select * from pg_stat_activity;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

19、查询数据库中已经存在的用户和角色

postgres=# select * from pg_stat_activity;
postgres=# SELECT rolname FROM pg_roles;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

20、退出数据库

postgres=# \q文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

PostgreSQL深入浅出 | 数据库的日常维护文章源自菜鸟学院-https://www.cainiaoxueyuan.com/sjk/27655.html

  • 本站内容整理自互联网，仅提供信息存储空间服务，以方便学习之用。如对文章、图片、字体等版权有疑问，请在下方留言，管理员看到后，将第一时间进行处理。
  • 转载请务必保留本文链接：https://www.cainiaoxueyuan.com/sjk/27655.html

Comment

匿名网友 填写信息

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定