Re: Must re-connect to see tables

2018-03-27 Thread Daniel Verite
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 certainl

Re: Must re-connect to see tables

2018-03-27 Thread Blake McBride
On Tue, Mar 27, 2018 at 6:48 AM, rob stone wrote: > Hello Blake, > > On Tue, 2018-03-27 at 06:23 -0500, Blake McBride wrote: > > I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit > > Linux box. > > > > On Tue, Mar 27, 2018 at 6:22 AM, Blake McBride > > wrote: > > > Hi, > > > >

Re: Must re-connect to see tables

2018-03-27 Thread rob stone
Hello Blake, On Tue, 2018-03-27 at 06:23 -0500, Blake McBride wrote: > I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit > Linux box. > > On Tue, Mar 27, 2018 at 6:22 AM, Blake McBride > wrote: > > Hi, > > > > I have been using PostgreSQL for many years but all of a sudden a >

Re: Must re-connect to see tables

2018-03-27 Thread Ron
If it worked in 9.3.22 and now it's failed in 9.3.22, then  I'd look to see if something has changed in data.sql. On 03/27/2018 06:22 AM, Blake McBride wrote: 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 (e

Re: Must re-connect to see tables

2018-03-27 Thread Blake McBride
I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit Linux box. On Tue, Mar 27, 2018 at 6:22 AM, Blake McBride wrote: > 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: > > p