On Fri, Jul 15, 2016 at 10:02 AM, Paul Ramsey <pram...@cleverelephant.ca> wrote:
> > Make sure to pg_dump -Fc > (note the flags) > > You need to also include "--quote-all-identifiers" if you intend for the dump to be restored onto a newer version of PostgreSQL. https://www.postgresql.org/docs/9.6/static/app-pgdump.html And don't forget pg_dumpall to get the globals - or to do the whole thing. https://www.postgresql.org/docs/9.6/static/app-pg-dumpall.html David J.
