│ oid │ s_name │ t_name │ parent_oid │ parent_name │ rows │ size_bytes │ size_pretty │ size_plus_indexes │ bytes_per_row │ percent_of_partition_rows │ percent_of_partition_bytes │ This provides counts of tables, views and functions along with the size on disk of the objects within the schema. The highest level of querying provided by pgdd is at the schema level. SELECT s_name, v_name FROM dd.views() WHERE system_object Schema Query the functions to include system_object results. PgDD views wrap around functions with the same name and enforce WHERE NOT system_object. │ dd │ functions │ Data dictionary view: Lists functions, excluding system functions. │ dd │ columns │ Data dictionary view: Lists columns, excluding system columns. │ dd │ views │ Data dictionary view: Lists views, excluding system views. │ dd │ tables │ Data dictionary view: Lists tables, excluding system tables. │ dd │ schemas │ Data dictionary view: Lists schemas, excluding system schemas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |