postgres=# select * from pg_tables where tableowner = 'postgres';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
--------------------+-------------------------+------------+------------+------------+----------+-------------
pg_catalog | pg_type | postgres | | t | f | f
pg_catalog | pg_statistic | postgres | | t | f | f
information_schema | sql_features | postgres | | f | f | f
information_schema | sql_implementation_info | postgres | | f | f | f
information_schema | sql_languages | postgres | | f | f | f
pg_catalog | pg_authid | postgres | pg_global | t | f | t
information_schema | sql_packages | postgres | | f | f | f
information_schema | sql_parts | postgres | | f | f | f
pg_catalog | pg_database | postgres | pg_global | t | f | t
information_schema | sql_sizing | postgres | | f | f | f
information_schema | sql_sizing_profiles | postgres | | f | f | f
pg_catalog | pg_listener | postgres | | f | f | f
pg_catalog | pg_description | postgres | | t | f | f
pg_catalog | pg_cast | postgres | | t | f | f
pg_catalog | pg_user_mapping | postgres | | t | f | f
pg_catalog | pg_enum | postgres | | t | f | f
pg_catalog | pg_namespace | postgres | | t | f | f
pg_catalog | pg_attribute | postgres | | t | f | f
pg_catalog | pg_proc | postgres | | t | f | f
pg_catalog | pg_class | postgres | | t | f | f
pg_catalog | pg_attrdef | postgres | | t | f | f
pg_catalog | pg_constraint | postgres | | t | f | f
pg_catalog | pg_inherits | postgres | | t | f | f
pg_catalog | pg_index | postgres | | t | f | f
pg_catalog | pg_operator | postgres | | t | f | f
pg_catalog | pg_opfamily | postgres | | t | f | f
pg_catalog | pg_opclass | postgres | | t | f | f
pg_catalog | pg_am | postgres | | t | f | f
pg_catalog | pg_amop | postgres | | t | f | f
pg_catalog | pg_amproc | postgres | | t | f | f
pg_catalog | pg_language | postgres | | t | f | f
pg_catalog | pg_largeobject | postgres | | t | f | f
pg_catalog | pg_aggregate | postgres | | t | f | f
pg_catalog | pg_rewrite | postgres | | t | f | f
pg_catalog | pg_trigger | postgres | | t | f | f
pg_catalog | pg_conversion | postgres | | t | f | f
pg_catalog | pg_depend | postgres | | t | f | f
pg_catalog | pg_tablespace | postgres | pg_global | t | f | f
pg_catalog | pg_pltemplate | postgres | pg_global | t | f | f
pg_catalog | pg_shdepend | postgres | pg_global | t | f | f
pg_catalog | pg_shdescription | postgres | pg_global | t | f | f
pg_catalog | pg_ts_config | postgres | | t | f | f
pg_catalog | pg_ts_config_map | postgres | | t | f | f
pg_catalog | pg_ts_dict | postgres | | t | f | f
pg_catalog | pg_ts_parser | postgres | | t | f | f
pg_catalog | pg_ts_template | postgres | | t | f | f
pg_catalog | pg_foreign_data_wrapper | postgres | | t | f | f
pg_catalog | pg_foreign_server | postgres | | t | f | f
pg_catalog | pg_auth_members | postgres | pg_global | t | f | t
(49 rows)
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
--------------------+-------------------------+------------+------------+------------+----------+-------------
pg_catalog | pg_type | postgres | | t | f | f
pg_catalog | pg_statistic | postgres | | t | f | f
information_schema | sql_features | postgres | | f | f | f
information_schema | sql_implementation_info | postgres | | f | f | f
information_schema | sql_languages | postgres | | f | f | f
pg_catalog | pg_authid | postgres | pg_global | t | f | t
information_schema | sql_packages | postgres | | f | f | f
information_schema | sql_parts | postgres | | f | f | f
pg_catalog | pg_database | postgres | pg_global | t | f | t
information_schema | sql_sizing | postgres | | f | f | f
information_schema | sql_sizing_profiles | postgres | | f | f | f
pg_catalog | pg_listener | postgres | | f | f | f
pg_catalog | pg_description | postgres | | t | f | f
pg_catalog | pg_cast | postgres | | t | f | f
pg_catalog | pg_user_mapping | postgres | | t | f | f
pg_catalog | pg_enum | postgres | | t | f | f
pg_catalog | pg_namespace | postgres | | t | f | f
pg_catalog | pg_attribute | postgres | | t | f | f
pg_catalog | pg_proc | postgres | | t | f | f
pg_catalog | pg_class | postgres | | t | f | f
pg_catalog | pg_attrdef | postgres | | t | f | f
pg_catalog | pg_constraint | postgres | | t | f | f
pg_catalog | pg_inherits | postgres | | t | f | f
pg_catalog | pg_index | postgres | | t | f | f
pg_catalog | pg_operator | postgres | | t | f | f
pg_catalog | pg_opfamily | postgres | | t | f | f
pg_catalog | pg_opclass | postgres | | t | f | f
pg_catalog | pg_am | postgres | | t | f | f
pg_catalog | pg_amop | postgres | | t | f | f
pg_catalog | pg_amproc | postgres | | t | f | f
pg_catalog | pg_language | postgres | | t | f | f
pg_catalog | pg_largeobject | postgres | | t | f | f
pg_catalog | pg_aggregate | postgres | | t | f | f
pg_catalog | pg_rewrite | postgres | | t | f | f
pg_catalog | pg_trigger | postgres | | t | f | f
pg_catalog | pg_conversion | postgres | | t | f | f
pg_catalog | pg_depend | postgres | | t | f | f
pg_catalog | pg_tablespace | postgres | pg_global | t | f | f
pg_catalog | pg_pltemplate | postgres | pg_global | t | f | f
pg_catalog | pg_shdepend | postgres | pg_global | t | f | f
pg_catalog | pg_shdescription | postgres | pg_global | t | f | f
pg_catalog | pg_ts_config | postgres | | t | f | f
pg_catalog | pg_ts_config_map | postgres | | t | f | f
pg_catalog | pg_ts_dict | postgres | | t | f | f
pg_catalog | pg_ts_parser | postgres | | t | f | f
pg_catalog | pg_ts_template | postgres | | t | f | f
pg_catalog | pg_foreign_data_wrapper | postgres | | t | f | f
pg_catalog | pg_foreign_server | postgres | | t | f | f
pg_catalog | pg_auth_members | postgres | pg_global | t | f | t
(49 rows)
No comments:
Post a Comment