Hi, I have been using PostgreSQL for many years but all of a sudden a db load script I've been using no longer works. What id does (essentially) is:
psql postgres postgres drop database test; create database test; \c test \i data.sql \dt \q I tested this with a small data.sql and it worked fine. However, when I use a real (much larger) data.sql then \dt replies "No relations" ! I found this if I stick an extra '\c test' after the '\i data.sql' it works. The data.sql is a PostgreSQL dump from another database. When the '\i data.sql' is done, the prompt still shows 'test#' so it's not like I've changed databases. I only have one schema, 'public'. Can't figure out why a simple example works but a large file requires an extra \c. Sure appreciate any help. Blake McBride
