pg参考之pg_tables
postgres=# select tablename,tableowner from pg_tables;tablename | tableowner
-------------------------+------------
pg_statistic | postgres
pg_type | postgres
pg_foreign_server | postgres
pg_authid | postgres
pg_statistic_ext_data | postgres
pg_user_mapping | postgres
pg_subscription | postgres
pg_attribute | postgres
pg_proc | postgres
pg_class | postgres
pg_attrdef | postgres
pg_constraint | postgres
pg_inherits | postgres
pg_index | postgres
pg_operator | postgres
pg_opfamily | postgres
pg_opclass | postgres
pg_am | postgres
pg_amop | postgres
pg_amproc | postgres
pg_language | postgres
pg_largeobject_metadata | postgres
pg_aggregate | postgres
pg_largeobject | postgres
pg_statistic_ext | postgres
pg_rewrite | postgres
pg_trigger | postgres
pg_event_trigger | postgres
pg_description | postgres
pg_cast | postgres
pg_enum | postgres
pg_namespace | postgres
pg_conversion | postgres
pg_depend | postgres
pg_database | postgres
pg_db_role_setting | postgres
pg_tablespace | postgres
pg_pltemplate | postgres
pg_auth_members | postgres
pg_shdepend | postgres
pg_shdescription | postgres
pg_ts_config | postgres
pg_ts_config_map | postgres
pg_ts_dict | postgres
pg_ts_parser | postgres
pg_ts_template | postgres
pg_extension | postgres
pg_foreign_data_wrapper | postgres
pg_foreign_table | postgres
pg_policy | postgres
pg_replication_origin | postgres
pg_default_acl | postgres
pg_init_privs | postgres
pg_seclabel | postgres
pg_shseclabel | postgres
pg_collation | postgres
pg_partitioned_table | postgres
pg_range | postgres
pg_transform | postgres
pg_sequence | postgres
pg_publication | postgres
pg_publication_rel | postgres
pg_subscription_rel | postgres
sql_packages | postgres
sql_features | postgres
sql_implementation_info | postgres
sql_parts | postgres
sql_languages | postgres
sql_sizing | postgres
sql_sizing_profiles | postgres
(70 rows)
页:
[1]