How to generate PostgreSQL data dictionary from SQL script

Pubblicato il: 19 maggio 2021
sul canale di: DataResearchLabs

9,100

146

Sure, you can use pgAdmin, or Toad, or a similar IDE to generate a data dictionary from an application. But what if you don't have those applications? Or what if you want a more universal way of generating a data dictionary? Then the following SQL script is for you.

This script will return the schema and table names as well as numerous column properties beyond just the column name. It also includes the column's ordinal position, whether or not it is a part of a primary key / foreign key / unique key, its data type and various length/size/precision components, whether or not it is nullable, and the description.

This short video walks you through downloading the script, executing it, pulling the metadata into an Excel file where it can easily be formatted to look pretty and shared with other team members via email.

------ Chapter Timestamps (click to jump forward): ----------------------------
0:00 - Intro
0:10 - Ever Needed to Troubleshoot What Schema Change Broke Your App?
0:40 - Demo: How to Download the Script
1:30 - Demo: How to Run the Script and Generate the Data Dictionary
3:47 - Demo: The Data Dictionary output in Excel
5:50 - The End

Download:
https://raw.githubusercontent.com/Dat...

Watch related playlist videos:
   • PostgreSQL Scripts for Data Analysts

Connect with me on social media:
LinkedIn:   / mpiercead576
YouTube:    / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs

Subscribe to my YouTube Channel:
   / @dataresearchlabs

Background Music (via YouTube "always free" Audio):
"Rewind" by Ofshane:    / @ofshane

#PostgreSQL #datadictionary #autogenerate #sql #scripts

In questa pagina del sito puoi guardare il video online How to generate PostgreSQL data dictionary from SQL script della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataResearchLabs 19 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 9,100 volte e gli è piaciuto 146 spettatori. Buona visione!

994