PostgreSQL utility scripts

Some scripts to show information about the PostgreSQL database.

There are a couple of ways to try these scripts. First, cd to the directory where you cloned/downloaded this folder. Then try out either of these options:

psql -f ./'<name-of-script.sql>' <your-database>
Log into PostgreSQL using psql and from within the interactive window run the command \i './<name-of-script.sql>'

The psql utility is very flexible and powerful utility!

Name		Name	Last commit message	Last commit date
Latest commit History 18 Commits
.gitignore		.gitignore
README.md		README.md
count-nulls-in-cols-of-table.sql		count-nulls-in-cols-of-table.sql
date-time-dimensions.sql		date-time-dimensions.sql
generate-current-year-calendar.sql		generate-current-year-calendar.sql
generate-random-ips.sql		generate-random-ips.sql
index-bloat.sql		index-bloat.sql
last-autovacuum-and-autoanalyze.sql		last-autovacuum-and-autoanalyze.sql
list-all-columns.sql		list-all-columns.sql
list-table-sizes.sql		list-table-sizes.sql
missing-primary-keys.sql		missing-primary-keys.sql
no-stats-table-check.sql		no-stats-table-check.sql
olap-settings.sql		olap-settings.sql
postgresql.conf		postgresql.conf
select-statements-for-all-tables.sql		select-statements-for-all-tables.sql
show-settings.sql		show-settings.sql
table-xid-age.sql		table-xid-age.sql
useless-cols.sql		useless-cols.sql
utility-functions.sql		utility-functions.sql

vlulla/postgresql-util-scripts

Folders and files

Latest commit

History

Repository files navigation

PostgreSQL utility scripts

About

Topics

Resources

Stars

Watchers

Forks

Languages