│ 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. │ dd │ functions │ Data dictionary view: Lists functions, excluding system functions. │ dd │ columns │ Data dictionary view: Lists columns, excluding system columns. This shows the five (5) PgDD views currently available, columns, functions, schemas, tables and views. The basic idea of what's available in PgDD can be found by querying theĭd.views view for the views in the dd schema. The interface to PgDD is simply using standard SQL queries PgDD does not do anything magical, it is simplyĪ wrapper around the Postgres system catalogs!Ĭan be found using the psql client with its slash commands. User friendly to query for the type of details commonly needed. The challenge with using the system catalogs is they are not very Postgres' system catalogs are in the pg_catalog schema. Relational databases, including Postgres, track the majority of the information This data dictionary information from PgDD is made available using standard This post shows how PgDD provides access toĬurrent and accurate information about your databases for a variety of users: Makes it easy to inspect and explore your data structures in Postgres. By Ryan Lambert - Published January 04, 2022Ī data dictionary is an important tool for anyone that stores and consumes
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |