#postgresql

How to dump and restore a Postgres DB with new table ownership

I've used MySQL for years. But recently, I found myself working with PostgreSQL and simple things like dumping and restoring a database are different enough that I decided to document the process. It's straightforward enough once I knew how. So first...