On Fri, Jul 15, 2016 at 10:02 AM, Paul Ramsey <pramsey(at)cleverelephant(dot)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.