Blake McBride wrote: > data.sql is an untouched dump of a database from PostgreSQL 9.5.12. > > The import seems to have worked. I just need another \c after the \i.
An effect of reconnecting is to reset the search_path to what it was before including your dump file. You're most certainly affected by the search_path-related changes in pg_dump done in the latest versions following CVE-2018-1058 See https://www.postgresql.org/support/security/ or https://www.postgresql.org/about/news/1834/ Manually issuing RESET search_path; after \i data.sql should get "public" back in the search_path without reconnecting and after that \dt would work as usual. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
