![]() ![]() ![]() Our other internal projects using Sqitch already. I picked Sqitch because it was easy for me with The initial releases used Sqitch to install Last year (fall 2018) I standardized the project and made it open source. Before long I had a variety of versions of views in differentĭatabases, and my own inconsistencies were not helping me out. The queries used so I could extract the same information without \dt+) had the output I needed, I just needed to get PgDD started a few years ago as a few helpful queries derived from "A good data dictionary provides insights into a database's structure, constraints, relationships, and sources of data found inside a system." History of PgDD Part of the reason good documentation is so important is because databasesĪre often the most long-lived portion of any system or application. The project README lists the data dictionary viewsĭocumentation is key for any system, this is especially true with databases. To find the 5 largest tables by size on disk, simply query the You do not need to use a specific tool or learnĪ set of new commands, simply install the extension and start querying. PgDD makes it possible to easily explore your database structure ![]() Read PgDD extension moves to Pgx and Postgres Data Dictionary for everyone for more details! Why PgDD is helpful This post is outdated, PgDD has been rewritten using the pgx framework. Query the most important database structures a huge benefit, hopefully others The PgDD (PostgreSQL Data Dictionary) project, why it exists, and how to install the extension. The PgDD project is now an extension for Postgres! This post is about By Ryan Lambert - Published November 17, 2019 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |