This took me longer to figure out than I care to admit.
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.
Created 2021-02-23T19:03:04-08:00 · Edit