Re: disappearing tables

"paul butler" <paul@entropia.co.uk> writes:
> I've just pg_dumped a database (data and description  from version
> 7.13 and loaded into a blank local database ( I'm using cygwin ,
> pg7.2) using psql  \i. I've got php pages accessing it and everything
> is sweet, however in psql I can't view some of the tables, after a
> select I get is:
> less: not found

You evidently don't have the "less" program installed.  If you have
"more", try setting PAGER in psql's environment to "more".  Else turn
off the output-pager function with \pset.  See the psql man page for
more details.

> Also when I try to drop and create under the same name, I get the
> original dbase back. eg
> Drop database wage;
> Create database wage;
> Returns the dropped database, not a blank one.

Sounds to me like you imported everything into template1.  That was a
bad idea.  You can recover from this, see
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
but if you don't have anything critical stored yet it might be easier
to initdb and start over.

            regards, tom lane