Show the SQL schema for a PostgreSQL database#

This took me longer to figure out than I care to admit.

1
pg_dump -s name-of-database

Surprisingly there doesn’t seem to be an easy way to do this using a SELECT statement within PostgreSQL itself.

StackOverflow offers up a terrifying 72 line SQL monstrosity that attempts to recreate the CREATE TABLE for a given table.