hermpheus/allDatabasesAndComments.sql

Created July 12, 2016 19:05

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hermpheus/8dd9c59a560e2646467bbfecefe9855d.js"></script>
Save hermpheus/8dd9c59a560e2646467bbfecefe9855d to your computer and use it in GitHub Desktop.

Download ZIP

PostgreSQL: Select all databases and comments

Raw

allDatabasesAndComments.sql

	SELECT
	datname
	,description
	FROM pg_shdescription
	INNER JOIN pg_database on objoid = pg_database.oid
	ORDER BY datname;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment